SQl if statement in where clause

• cvlasak

  SSC Veteran

  Points: 247

  More actions

  November 20, 2014 at 11:44 am

  #295249

  How do I make this a sql statement?

  ----------------------------------------------------------------------------------------------

  if DATEOFPAYMENT = yesterday then PaymentAmount else 0 as 'previous day'

  or

  if DATEOFPAYMENT = current_Month then PaymentAmount else 0 as 'MTD'

  or

  if DATEOFPAYMENT = current_Year then PaymentAmount else 0 as 'YTD

• dogramone

  Hall of Fame

  Points: 3216

  More actions

  November 20, 2014 at 11:51 am

  #1759935

  have a look at the case statement and use it in your select query. It will have a performance hit. Have you als othought of creting a lookup table and joining to it to translate values?

• cvlasak

  SSC Veteran

  Points: 247

  More actions

  November 20, 2014 at 11:56 am

  #1759937

  No I haven't and I don't know how

• Luis Cazares

  SSC Guru

  Points: 183706

  More actions

  November 20, 2014 at 12:02 pm

  #1759939

  Here you go:

  A solution

  Luis C.
  General Disclaimer:
  Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

  How to post data/code on a forum to get the best help: Option 1 / Option 2

• cvlasak

  SSC Veteran

  Points: 247

  More actions

  November 20, 2014 at 12:04 pm

  #1759940

  I'm working off of the test server