Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Dynamic Query Problem
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
01518212
Message ID:
01518216
Views:
55
See FAQ #8130. Something like
SET @Command = 'SELECT @voter_id = voterid FROM tblCamp_CT WHERE VoterId = @VoterId AND ' + 
EXEC sp_executesql @Command, ... , @VoterId = @VoterId, @voter_id = @voter_id OUTPUT
>I'm trying to run this query:
>
>
>DECLARE @voter_id INT
>SET @Command = 'SELECT @voter_id = voterid FROM tblCamp_CT WHERE VoterId = ' + CAST(@VoterId AS VARCHAR(20)) + ' AND ' + @Query
>EXEC (@Command)
>
>
>and I'm getting the error
>
>
>Must declare the scalar variable "@voter_id".
>
>
>What am I not seeing here???
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform