IIF query alternate in sql server

• Sameen Kashif

  Old Hand

  Points: 330

  More actions

  June 12, 2007 at 1:54 am

  #174555

  hello am using the follwing

  SELECT

  Sum(IIf(attendance.present='P',1,0))  AS TotalPresent  from Attendance...

  it gives me error tht incorrect sytex near=..

   

  if i replace my iif with CASE such as

  SELECT

  case Present

  when 'P'

  then 1

  else 0

  end as TotalPresen from Attendance

   

  then how can i apply SUM function

  Thnx in advance

   

   

• David McFarland

  SSChampion

  Points: 11815

  More actions

  June 12, 2007 at 2:12 am

  #712189

  Just like you did with the immediate IF, you wrap the Sum around it.

  SELECT

  Sum(case Present

  when 'P'

  then 1

  else 0

  end) as TotalPresent from Attendance

  If that really is the extent of your resultset, you could also just do a SELECT COUNT... with the Present = 'P' in the WHERE clause.