Home Forums SQL Server 2005 T-SQL (SS2K5) using case when condition in WHERE in SP RE: using case when condition in WHERE in SP

  • September 30, 2013 at 6:32 am

    #1654515

    parulprabu (9/30/2013)

    Hi,

    Try with this code

    where id=@id and month=@month and Eid=

    case when @Eid=0 then case when Eid>0 then Eid else 0 end else @Eid end =Eid

    There's a syntax error and a pointless logical check in this code. Can you identify them, parulprabu?

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden