Home Forums SQL Server 2005 SQL Server Express using case in where clause having other conditions RE: using case in where clause having other conditions

  • June 13, 2013 at 3:05 am

    #1623603

    ssurekha2000 (6/13/2013)

    i got it using

    where id=@id

    and (

    (@con=0 AND YEARMONTH >=Replace(@YearMonth,'-',''))

    OR (@con<>0 AND YEARMONTH <>Replace(@YearMonth,'-',''))

    )

    Hope that it's a small row set and excellent performance is not a requirement...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass