View: dbo.Payroll_Check_Payroll_Item_Distribution_With_Account_Range_View | |||
View definition | |||
--Distribution view that includes summarized gl account range information. --Windowing allows the aggregations without resorting to addtional group by operations. This will allow --the query optimizer to make the most optimal plan. CREATE VIEW dbo.Payroll_Check_Payroll_Item_Distribution_With_Account_Range_View AS SELECT dbo.Payroll_Check_Payroll_Item_Distribution.* , MIN(expense__gl_account_KEY) OVER(PARTITION BY payroll_check_payroll_item_KEY) AS expense__gl_account_min , MAX(expense__gl_account_KEY) OVER(PARTITION BY payroll_check_payroll_item_KEY) AS expense__gl_account_max , MIN(liability__gl_account_KEY) OVER(PARTITION BY payroll_check_payroll_item_KEY) AS liability__gl_account_min , MAX(liability__gl_account_KEY) OVER(PARTITION BY payroll_check_payroll_item_KEY) AS liability__gl_account_max FROM dbo.Payroll_Check_Payroll_Item_Distribution | |||