convert tSQL mySQL to MSSQL

• Brad Marsh

  Say Hey Kid

  Points: 704

  More actions

  April 21, 2013 at 6:18 pm

  #292780

  Hi Guys need some help with converting this part of a query from MySQL, I need to run this on MSSQL.

  Select (SUM(if(rating = 5, 1, 0))-SUM(if(RATING < 4, 1, 0)))/SUM(if(RATING > 0, 1, 0))*100 as RECENT_NPS,

  SUM(if(RATING > 0, 1, 0)) as RECENT_RATINGS,

  ............

• mickyT

  SSChampion

  Points: 10360

  More actions

  April 21, 2013 at 8:50 pm

  #1608572

  Hi

  Try replacing your IF functions with a CASE statements, eg

  if(rating = 5, 1, 0)

  becomes

  CASE WHEN rating = 5 THEN 1 ELSE 0 END

  In SQL 2012 there is also the IIF function that could be used

• Brad Marsh

  Say Hey Kid

  Points: 704

  More actions

  April 21, 2013 at 10:44 pm

  #1608580

  perfect thanks MickyT