- Select (F1.D32-F1.D20) As Profit_For_The_Period ,
- F3.D2 as Current_Libilities,
- F5.D20 As Capital_Acount,
- M1.Name As Name,
- F2.D20 AS Loan_Liabilities,
- F4.d1 As Opening_Diff --F2.D68 As Loan,
- from Folio1 As F1
- inner Join Master1 As m1 on m1.Code like '101'
- or m1.Code Like '102' or m1.Code Like '106'
- or m1.Code Like '109' or m1.Code lIke '103'
- inner Join Folio1 As F2 On (F2.MasterCode=F2.MasterCode)
- inner Join Folio1 As F3 On (F3.MasterCode=F3.MasterCode)
- inner Join Folio1 As F4 On (F4.MasterCode=F4.MasterCode)
- inner Join Folio1 As F5 On (F5.MasterCode=F5.MasterCode)
- Where F1.MasterCode=109
- and F2.MasterCode =106
- and F3.MasterCode=103
- and F4.MasterCode=102
- And F5.MasterCode=101
Horizontal To Vertical Sql Server
Below is my Output
1 12392 0 0 Capital Account 4000 -200
2 12392 0 0 Current Assets 4000 -200
3 12392 0 0 Current Liabilities 4000 -200
4 12392 0 0 Loans (Liability) 4000 -200
5 12392 0 0 Revenue Accounts 4000 -200
desire Output
1 Capital Account 12392
2 Current Assets 0
3 Current Liabilities 0
4 Loans (Liability) 4000
5 Revenue Accounts -200
Atul KumarPosted Jan 28, 2019, 11:10 PM
Sanwar RanwaPosted Jan 28, 2019, 11:06 PM