Get Value from a table Based on current Day

• Sureshbabu Sankarasubbu

  SSC Enthusiast

  Points: 162

  More actions

  August 22, 2005 at 10:03 am

  #167957

  Hi All,

      I need to write a query which get me either one of the column(WKDAY or WKEND) based on the Following conditions.

  i. If Current day is between Mon - Friday, Need to pick value from WKDAY column from a Table.

  ii. If Current day is either saturday or sunday, need to pick value from WKEND column from a Table.

  Any help would be appreciated.

  Thanks in advance

  -Suresh

   

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  August 22, 2005 at 10:08 am

  #583966

  Select case when datepart(dw, GetDate()) < 6 then A.WKDAY else B.WKEND end as WEWD from ...