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 10:31 pm

    #1654770

    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

    Sorry for the erroneous solution given. This is the correct one

    [Code="sql"]

    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)

    [/code]