Columns Tor

• narendra.babu57

  Old Hand

  Points: 386

  More actions

  December 15, 2014 at 10:35 pm

  #293578

  Hi All,

  My requirement as follows, if any know please let me know

  Table Structure :

  CropCountSeedCountRetSalesDisSales

  2 3 100 200

  3 7 400 800

  Desired Output:

  Type Count Sales

  CropCount 5 0

  SeedCount 10 0

  RetSales 0 500

  DiSales 0 1000

• narendra.babu57

  Old Hand

  Points: 386

  More actions

  December 16, 2014 at 12:26 am

  #1764863

  Hi All,

  I got the solution:

  Select Type,Sum(Count)Count,0 as sales From (select Type,Count from #test unpivot(Count for Type in([cropcnt],[SeedCnt])) as upvt1)b

  Group by Type

  union all

  Select Type,0 as Count,Sum(Sales)Sales From (select Type,sales from #test unpivot(Sales for Type in([RetSales],DisSales)) as upvt1)b

  Group by Type