>DECLARE @voter_id INT >SET @Command = 'SELECT @voter_id = voterid FROM tblCamp_CT WHERE VoterId = ' + CAST(@VoterId AS VARCHAR(20)) + ' AND ' + @Query > >EXEC sp_executesql @Command, N'@voter_id int OUTPUT', @voter_id = @voter_id OUTPUT >Ok, I tried this
DECLARE @voter_id INT SET @Command = 'SELECT @voter_id = voterid FROM tblCamp_CT WHERE VoterId = ' + CAST(@VoterId AS VARCHAR(20)) + ' AND ' + @Query EXEC sp_executesql @Command, N'@voter_id int OUTPUT', @voter_id = @voter_id OUTPUT SELECT @voter_idand I'm now getting
Procedure expects parameter '@statement' of type 'ntext/nchar/nvarchar'.Not sure what @statement' is.