switch case in where clause
- by Nimesh
hi,
i need to check three conditions:
if @filter = 1
{
**select * from employeestable where rating is not null**
}
else if @filter = 2
{
**select * from employeestable where rating is null**
}
else
{
**select * from employeestable**
}
This i need to do using a case statement. now i have more than 30 lines of query, if i use case i can reduce my code upto 70%
Please let mek now how can i do this.
