>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".
>
>declare @VoterID int, @SQL nvarchar(max) set @VoterID = 1 set @SQL = 'SELECT top (1) @Voter_ID = VoterID FROM tblCamp_CT where VoterID = @VoterID AND ' + @Query execute sp_ExecuteSQL @SQL, N'@VoterID int OUTPUT' @VoterID OUTPUT