Home Forums SQL Server 2005 SQL Server 2005 General Discussion Where clause Case Statement and IN RE: Where clause Case Statement and IN

  • December 24, 2012 at 1:07 pm

    #1571363

    I basically want to say if @Component = -1 then parentTypeId In (601, 605, 606) else parentTypeId = @Component