Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @DATE_START datetime = '20190729 23:59'
- DECLARE @DATE_END datetime = '20190731 23:59'
- DECLARE @TASKS TABLE(Id uniqueidentifier)
- INSERT INTO @TASKS
- SELECT Id
- FROM [oktell].[dbo].[A_TaskManager_Tasks];
- --------------------------------------------------------------------------------------------------------------------
- DECLARE @ListsId TABLE (Id uniqueidentifier, ListId uniqueidentifier)
- INSERT INTO @ListsId
- SELECT T.Id, TMT.ListId
- FROM @TASKS as T
- LEFT JOIN [oktell].[dbo].[A_TaskManager_Tasks] as TMT
- ON T.Id = TMT.Id
- DECLARE @TasksEnumerator CURSOR
- SET @TasksEnumerator = CURSOR SCROLL FOR
- SELECT JoinedTable
- FROM [oktell].[dbo].[A_TaskManager_Lists]
- WHERE Id IN (SELECT ListId FROM @ListsId)
- DELETE @ListsId
- ------ОТКРЫВАЕМ КУРСОР-----------------------------------------------------------------------------------------------
- DECLARE @JTable nvarchar(100)
- OPEN @TasksEnumerator
- FETCH NEXT FROM @TasksEnumerator INTO @JTable
- WHILE @@FETCH_STATUS = 0
- BEGIN
- FETCH NEXT FROM @TasksEnumerator INTO @JTable
- PRINT @JTable
- PRINT 'kek'
- END
- CLOSE @TasksEnumerator
- DEALLOCATE @TasksEnumerator
- ------------------------------------------------------------------------------
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement