Home Forums SQL Server 2005 Development Conditional Where or Having Clause RE: Conditional Where or Having Clause

  • April 8, 2009 at 1:08 pm

    #974624

    so if for a particular State = NULL ,count(status)>1 only 'Active' status row should be displayed or any status row can be displayed('Active' or 'Pending').