"fetch"

• aanryn

  SSC-Addicted

  Points: 415

  More actions

  October 17, 2007 at 7:07 am

  #178545

  How to fetch the records when salary flag equal to 1 then sum up the corresponding vacation hours and sick Leave hours. If salary flag is Zero then display the sick Leave hours alone

  Condition: use single select statement with out where clauses.

  employeeid salariedflag vacationhours sickleavehours

  1 0 3 4

  2 1 4 6

  3 0 2 1

  4 1 1 8

  Expected Output

  Employeeid paidtimeoff

  1 4

  2 10

  3 1

  4 9

• David Burrows

  SSC Guru

  Points: 65144

  More actions

  October 17, 2007 at 7:17 am

  #742703

  :ermm: suspicious question

  SELECT employeeid, sickleavehours + (vacationhours * salariedflag) AS [paidtimeoff]

  Far away is close at hand in the images of elsewhere.
  Anon.

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  October 17, 2007 at 7:18 am

  #742704

  Is this a homework question? You'll find that people are more likely to help you if you show what you've tried so far.

  John

• Tushar.Tupe

  SSC-Addicted

  Points: 415

  More actions

  November 21, 2011 at 11:22 pm

  #1411205

  Check this..........

  SELECT Employeeid ,

  CASE WHEN salariedflag = 1 THEN vacationhours + sickleavehours

  ELSE sickleavehours

  END paidtimeoff