SUM and Addition of Null

• Lokesh Vij

  SSChampion

  Points: 10836

  More actions

  November 6, 2012 at 5:14 am

  #1556409

  Thanks for the question. An easy one considering the available answer options

  ~ Lokesh Vij
  

  ---

  Guidelines for quicker answers on T-SQL question[/url]
  Guidelines for answers on Performance questions

  Link to my Blog Post --> www.SQLPathy.com[/url]

  Follow me @Twitter

  

• David Conn

  SSCertifiable

  Points: 6010

  More actions

  November 6, 2012 at 9:58 pm

  #1556634

  Thanks. I enjoyed this question. Had to think about the '' but got there in the end.

• SQLRNNR

  SSC Guru

  Points: 281334

  More actions

  November 13, 2012 at 2:48 pm

  #1558671

  Thanks for the question.

  Jason...AKA CirqueDeSQLeil
  _______________________________________________
  I have given a name to my pain...MCM SQL Server, MVP
  SQL RNNR
  Posting Performance Based Questions - Gail Shaw[/url]
  Learn Extended Events

• manik_anu

  SSCrazy

  Points: 2397

  More actions

  January 28, 2013 at 4:05 am

  #1581528

  nice question, really thingable one....:-D

  Manik
  You cannot get to the top by sitting on your bottom.

• Neeraj Prasad Sharma

  Ten Centuries

  Points: 1315

  More actions

  May 28, 2013 at 4:22 am

  #1618903

  select '1' as num1, '' as num2

  tricky part but 1+

  Neeraj Prasad Sharma
  Sql Server Tutorials