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) >>
>Must declare the scalar variable "@voter_id".
>
>