convert NULL to 0 in Pivot Result Set

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  November 26, 2012 at 2:53 am

  #1562111

  SSSsil174 (11/26/2012)

  ---

  I want the rollup of D1, D2 etc for each name.

  Example: If the result set like the below..

  Clientid TagId NameD1D2D3D4D5

  147American100050030000

  148Hispanic0001000200

  147American100050030000

  148Hispanic0001000200

  I want the result set like the following..

  Clientid TagId NameD1D2D3D4D5

  147American100050030000

  147American100050030000

  147 ALL 2000 1000 600 0 0

  148Hispanic0001000200

  148Hispanic0001000200

  148 ALL 0 0 0 2000 400

  PLEASE HELP ME OUT

  sailu ..DOnt hijack other's post , use new thread/post for new questions always see the link, i have with my signature

  -------Bhuvnesh----------
  I work only to learn Sql Server...though my company pays me for getting their stuff done;-)