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???