Is it possible to use a CURSOR Variable in a SELECT WHERE clause or do I have to build dynamic SQL to loop through and plug in the values???
Is this possible or do I need dynamic SQL??
USE [FBMC] GO /* All Stored Procedure Variables are declared here! */ DECLARE @FirstName VARCHAR(15), @LastName VARCHAR(20) DECLARE Member_Roster_Cursor CURSOR GLOBAL FOR SELECT [MemberRoster].[FirstName], [MemberRoster].[LastName] FROM [dbo].[MemberRoster] OPEN Member_Roster_Cursor FETCH NEXT FROM Member_Roster_Cursor INTO @FirstName, @LastName /* @@FETCH_STATUS being a System Function: @@FETCH_STATUS = 0 indicates a valid FETCH @@FETCH_STATUS = -1 indicates End of CURSOR @@FETCH_STATUS = -2 indicates a missing(deleted) row */ WHILE (@@FETCH_STATUS=0) BEGIN IF EXISTS(SELECT 1 FROM [Report].[dbo].[member] WHERE [member].[NAME_FIRST] LIKE @FirstName AND [member].[NAME_FIRST] LIKE @LastName BEGIN
Thanks for your review and am hopeful for a reply.....