Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --Первый запрос:
- EXEC sp_executesql N'SELECT TOP 23
- T1._Date_Time,
- T1._Number,
- T1._Fld6651,
- T1._Fld6643,
- T1._Fld6652,
- T1._Fld6650,
- T1._Fld6649,
- T1._DocumentTRef,
- T1._DocumentRRef,
- T1._Marked,
- T1._Posted
- FROM _DocumentJournal6640 T1 WITH(NOLOCK)
- WHERE (T1._Date_Time >= @P1 AND T1._Date_Time <= @P2)
- ORDER BY (T1._Date_Time) ASC, (T1._DocumentTRef) ASC, (T1._DocumentRRef) ASC',
- Top(TOP EXPRESSION:((23)))
- |--Nested Loops(Inner Join, OUTER REFERENCES:([Expr1007], [Expr1008], [Expr1009]))
- |--Merge Interval
- | |--Concatenation
- | |--Compute Scalar(DEFINE:(([Expr1002],[Expr1003],[Expr1001])=GetRangeWithMismatchedTypes([@P1],NULL,(22))))
- | | |--Constant Scan
- | |--Compute Scalar(DEFINE:(([Expr1005],[Expr1006],[Expr1004])=GetRangeWithMismatchedTypes(NULL,[@P2],(42))))
- | |--Constant Scan
- |--Clustered Index Seek(OBJECT:([basename].[dbo].[_DocumentJournal6640].[_Document6640_ByDocDate_TR] AS [T1]), SEEK:([T1].[_Date_Time] > [Expr1007] AND [T1].[_Date_Time] < [Expr1008]) ORDERED FORWARD)
- -- Второй:
- EXEC sp_executesql N'SELECT TOP 20
- T1._Date_Time,
- T1._Number,
- T1._Fld6651,
- T1._Fld6643,
- T1._Fld6652,
- T1._Fld6650,
- T1._Fld6649,
- T1._DocumentTRef,
- T1._DocumentRRef,
- T1._Marked,
- T1._Posted
- FROM _DocumentJournal6640 T1 WITH(NOLOCK)
- WHERE ((T1._Date_Time >= @P1) AND (T1._Date_Time <= @P2)) AND T1._Date_Time = @P3 AND T1._DocumentTRef = @P4 AND T1._DocumentRRef > @P5
- ORDER BY (T1._Date_Time) ASC, (T1._DocumentTRef) ASC, (T1._DocumentRRef) ASC
- OPTION (FAST 1)',
- Top(TOP EXPRESSION:((20)))
- |--Clustered Index Seek(OBJECT:([basename].[dbo].[_DocumentJournal6640].[_Document6640_ByDocDate_TR] AS [T1]), SEEK:([T1].[_Date_Time]=[@P3] AND [T1].[_DocumentTRef]=[@P4] AND [T1].[_DocumentRRef] > [@P5]), WHERE:([basename].[dbo].[_DocumentJournal6640].[_Date_Time] as [T1].[_Date_Time]>=[@P1] AND [basename].[dbo].[_DocumentJournal6640].[_Date_Time] as [T1].[_Date_Time]<=[@P2]) ORDERED FORWARD)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement