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 @TasksEnumerator CURSOR
- SET @TasksEnumerator = CURSOR SCROLL FOR
- SELECT TMT.Id, TMT.Name, JoinedTable
- FROM [oktell].[dbo].[A_TaskManager_Lists] as TML
- JOIN [oktell].[dbo].[A_TaskManager_Tasks] as TMT
- ON TMT.ListId = TML.Id
- WHERE TMT.Id IN (SELECT * FROM @TASKS)
- ------ОТКРЫВАЕМ КУРСОР-----------------------------------------------------------------------------------------------
- DECLARE @sqltext nvarchar(max)
- DECLARE @TaskId uniqueidentifier
- DECLARE @Name nvarchar(100)
- DECLARE @JTable nvarchar(100)
- DECLARE @CountAll int
- DECLARE @IdTable TABLE(TaskId uniqueidentifier, Name nvarchar(100), JTable nvarchar(100), Contacts int, NewContacts int)
- OPEN @TasksEnumerator
- FETCH NEXT FROM @TasksEnumerator INTO @TaskId, @Name, @JTable
- BEGIN TRY
- WHILE @@FETCH_STATUS = 0
- BEGIN
- FETCH NEXT FROM @TasksEnumerator INTO @TaskId, @Name, @JTable
- DECLARE @CountNew int = 0
- SET @sqltext = 'SELECT @Count = COUNT(*) FROM ' + @JTable
- EXEC SP_EXECUTESQL @sqltext, N'@Count int out', @CountAll out
- INSERT INTO @IdTable VALUES(@TaskId, @Name, @JTable, @CountAll, @CountNew)
- END
- CLOSE @TasksEnumerator
- DEALLOCATE @TasksEnumerator
- END TRY
- BEGIN CATCH
- END CATCH
- ------------------------------------------------------------------------------
- SELECT [Name] as 'Оператор'
- , Contacts as 'Всего контактов'
- , NewContacts as 'Новые'
- ,(SELECT COUNT(*) FROM [yandextaxi].[dbo].[tbl_processing] as tp WITH(NOLOCK) WHERE main.TaskId = tp.idtask) as 'В обработке'
- --,(SELECT COUNT(*) from oktell.dbo.A_TaskManager_SubTasks as ST WHERE Main.TaskId = ST.TaskId AND NResult = 1) 'Дозвон успешен'
- FROM @IdTable as Main
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement