Advertisement
Guest User

Untitled

a guest
Nov 11th, 2019
132
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 1.17 KB | None | 0 0
  1. Select BillNo,RowCode
  2.     ,(Case ExpMonth When 'BudgetOAmount_M1' Then  1 When 'BudgetOAmount_M2' Then  2 When 'BudgetOAmount_M3' Then 3
  3.     When 'BudgetOAmount_M4' Then 4 When 'BudgetOAmount_M5' Then 5 When 'BudgetOAmount_M6' Then 6
  4.     When 'BudgetOAmount_M7' Then 7 When 'BudgetOAmount_M8' Then 8 When 'BudgetOAmount_M9' Then 9
  5.     When 'BudgetOAmount_M10' Then 10 When 'BudgetOAmount_M11' Then 11 When 'BudgetOAmount_M12' Then 12
  6.     else 0 End) as ExpMonth
  7.     ,P2.ExpMoneyMon
  8. From
  9. (
  10.     Select AA.BillNo,BB.RowCode,AA.FIYear
  11.     ,BB.BudgetOAmount_M1,BB.BudgetOAmount_M2,BB.BudgetOAmount_M3,BB.BudgetOAmount_M4,BB.BudgetOAmount_M5,BB.BudgetOAmount_M6
  12.     ,BB.BudgetOAmount_M7,BB.BudgetOAmount_M8,BB.BudgetOAmount_M9,BB.BudgetOAmount_M10,BB.BudgetOAmount_M11,BB.BudgetOAmount_M12
  13.     From X_glBudgetDepPrj AA
  14.     Inner Join X_glBudgetDepPrjDetail BB on AA.BillNo=BB.BillNo
  15.     Where AA.BillNo='00001' And BB.RowNo=1
  16. ) as P1
  17. UNPIVOT
  18. (ExpMoneyMon For ExpMonth in (P1.BudgetOAmount_M1,P1.BudgetOAmount_M2,P1.BudgetOAmount_M3,P1.BudgetOAmount_M4,P1.BudgetOAmount_M5,P1.BudgetOAmount_M6
  19.     ,P1.BudgetOAmount_M7,P1.BudgetOAmount_M8,P1.BudgetOAmount_M9,P1.BudgetOAmount_M10,P1.BudgetOAmount_M11,P1.BudgetOAmount_M12)
  20. ) as P2
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement