I have below query and Data returned is below
Select [No_] , [Name] , [Totaling] from [DSL Live].[dbo].[XYZ $G_L Account] where [Account Type] = 4 . Further i want that all Capital Accounts Data from 1-L020000 to 1-L029999 . Reserves And Surplus Total Accounts from 1-L030000 to 1-L039999
be displayed under specific Heads i.e Capital Total , Reserves And Surplus Total.
No Name Totaling
1-L029999 CAPITAL TOTAL 1-L050000..1-L005999
1-L039999 RESERVES AND SURPLUS TOTAL 1-L060000..1-L006999