Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT 'Name' AS [Type],
- SUM ( [Subquery1].[Amount] ) AS [Amount],
- SUM ( [Subquery1].[Count] ) AS [Count]
- FROM ( SELECT [Subquery2].[Amount],
- [Subquery2].[Count]
- FROM ( SELECT [Subquery3].[Location],
- SUM ( CASE WHEN [Subquery3].[TransactionType] = 'Return'
- THEN -[Subquery3].[Amount]
- ELSE [Subquery3].[Amount]
- END ) AS [Amount],
- COUNT ( * ) AS [Count]
- FROM ( SELECT 'Location' AS [Location],
- *
- FROM [dbo].[Table]
- WHERE [Table].[TransactionType] <> 'Invalid'
- AND [Table].[CardDescription] = 'Desired'
- AND [Table].[Terminal] NOT IN
- ( 'TERMINAL A', 'TERMINAL B' )) AS [Subquery3]
- GROUP BY CASE WHEN DATEPART ( WEEKDAY, [Subquery3].[DateTime] ) = 6
- THEN DATEADD ( DAY, 1, [Subquery3].[DateTime] )
- ELSE [Subquery3].[DateTime]
- END,
- [Subquery3].[Location],
- [Subquery3].[Terminal] ) AS [Subquery2] ) AS [Subquery1] ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement