DECLARE crsPhrase3 CURSOR FOR
SELECT ID
FROM @tblMain WHERE Processed=0
OPEN crsPhrase3
FETCH NEXT FROM crsPhrase3 INTO @ID
WHILE @@FETCH_STATUS = 0
BEGIN --crsPhrase3
SELECT @deletable = [delete] FROM @tblMain WHERE ID = @ID
IF @deletable .......
DECLARE crsLeaderboard CURSOR FOR
SELECT Username
FROM Users
OPEN crsLeaderboard
FETCH NEXT FROM crsLeaderboard INTO @un
declare @name varchar(255)
select @name = Person_nameFirst + ' ' + Person_nameLast FROM Users where Username = @un
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
From novice to tech pro — start learning today.
you will have to use dynamic sql