declare @str nvarchar(1000) declare @cstr nvarchar(2000) DECLARE @c1 CURSOR set @str=N'SELECT EmpID FROM Emp where ' + @whereqry set @cstr = 'SET @c1 = CURSOR FOR ' + @str exec sp_executesql @cstr open @c1 FETCH NEXT FROM @c1 INTO @id WHILE @@FETCH_STATUS = 0 BEGIN ........ FETCH NEXT FROM @c1 INTO @id END CLOSE @c1 DEALLOCATE @c1
declare @str nvarchar(1000) declare @cstr nvarchar(2000) set @str=N'SELECT EmpID FROM Emp where ' + @whereqry set @cstr = 'DECLARE c1 CURSOR FOR ' + @str exec sp_executesql @cstr open c1 FETCH NEXT FROM c1 INTO @id WHILE @@FETCH_STATUS = 0 BEGIN ........ FETCH NEXT FROM c1 INTO @id END CLOSE c1 DEALLOCATE c1
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)