Advertisement
WorkAkkaunt

Убер долго открывается

Aug 2nd, 2019
126
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 1.24 KB | None | 0 0
  1. DECLARE @DATE_START datetime = '20190729 23:59'
  2. DECLARE @DATE_END datetime = '20190731 23:59'
  3.  
  4. DECLARE @TASKS TABLE(Id uniqueidentifier)
  5.  
  6. INSERT INTO @TASKS
  7. SELECT Id
  8. FROM [oktell].[dbo].[A_TaskManager_Tasks];
  9. --------------------------------------------------------------------------------------------------------------------
  10. DECLARE @ListsId TABLE (Id uniqueidentifier, ListId uniqueidentifier)
  11.  
  12. INSERT INTO @ListsId
  13. SELECT T.Id, TMT.ListId
  14. FROM @TASKS as T
  15. LEFT JOIN [oktell].[dbo].[A_TaskManager_Tasks] as TMT
  16.     ON T.Id = TMT.Id
  17.  
  18. DECLARE @TasksEnumerator CURSOR
  19.  
  20. SET @TasksEnumerator = CURSOR SCROLL FOR
  21.  
  22. SELECT JoinedTable
  23. FROM [oktell].[dbo].[A_TaskManager_Lists]
  24. WHERE Id IN (SELECT ListId FROM @ListsId)
  25.  
  26. DELETE @ListsId
  27.  
  28. ------ОТКРЫВАЕМ КУРСОР-----------------------------------------------------------------------------------------------
  29. DECLARE @JTable nvarchar(100)
  30.  
  31. OPEN @TasksEnumerator
  32.  
  33. FETCH NEXT FROM @TasksEnumerator INTO @JTable
  34.  
  35. WHILE @@FETCH_STATUS = 0
  36.     BEGIN
  37.         FETCH NEXT FROM @TasksEnumerator INTO @JTable
  38.         PRINT @JTable
  39.         PRINT 'kek'
  40.     END
  41.  
  42. CLOSE @TasksEnumerator
  43. DEALLOCATE @TasksEnumerator
  44. ------------------------------------------------------------------------------
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement