Возникает ошибка:
| Цитата |
The query has exceeded the maximum number of result sets that can be displayed in the results grid. Only the first 100 result sets are displayed in the grid.
|
Не более 100 результатов.
| Код |
DECLARE @F2_ID VARCHAR(50),
@MESSAGE VARCHAR(50),
@IDENT VARCHAR(50)
DECLARE klient_cursor CURSOR LOCAL FOR
SELECT DISTINCT [F2_ID]
FROM [dbo].[F1]
WHERE
( [ISU] = '1160400' OR [ISU] = '75160100' )
ORDER BY [F2_ID]
OPEN klient_cursor
FETCH NEXT FROM klient_cursor INTO @F2_ID
WHILE @@FETCH_STATUS=0
BEGIN
SELECT @MESSAGE=@F2_ID
-----------------------------------------------------------------------------------------------------------
SELECT ID, F2_ID, ISU, DATISUN, DATISUO
FROM [dbo].[F1] AS T1
WHERE
[F2_ID] = @MESSAGE AND
( [ISU] = '1160400' OR [ISU] = '75160100' )
AND EXISTS
(
SELECT *
FROM [dbo].[F1] AS T2
WHERE
[F2_ID] = @MESSAGE AND
( [ISU] = '1160400' OR [ISU] = '75160100' )
AND [T1].[DATISUN] < [T2].[DATISUN] and [T1].[DATISUO] > T2.[DATISUO]
)
UNION
SELECT ID, F2_ID, ISU, DATISUN, DATISUO
FROM [dbo].[F1] AS T1
WHERE
[F2_ID] = @MESSAGE AND
( [ISU] = '1160400' OR [ISU] = '75160100' )
AND EXISTS
(
SELECT *
FROM [dbo].[F1] AS T2
WHERE
[F2_ID] = @MESSAGE AND
( [ISU] = '1160400' OR [ISU] = '75160100' )
AND [T1].[DATISUN] > [T2].[DATISUN] and [T1].[DATISUO] < T2.[DATISUO]
)
-----------------------------------------------------------------------------------------------------------
FETCH NEXT FROM klient_cursor INTO @F2_ID
END
CLOSE klient_cursor
DEALLOCATE klient_cursor
|
Как записать в переменную или отдельную таблицу значения | Код |
SELECT ID, F2_ID, ISU, DATISUN, DATISUO
|
Не получается вывести через PRINT внутри курсора.
|