RSS

Re: In-line If-Else Block?

Please support our MS SQL advertiser: Programming Forums

In-line If-Else Block?

•

Join Date: Jul 2005

Location: Dallas, TX

Posts: 482

Reputation: campkev is an unknown quantity at this point

Rep Power: 4

Solved Threads: 19

campkev

Offline

Posting Pro in Training

Re: In-line If-Else Block?

Apr 20th, 2006

yes. There are a couple of different ways depending on how your database is setup and what you are trying to do with your query. Here are a couple of examples. Mess with them and let me know if you need more help.
Example A (get customer or deleted customer):

Help with Code Tags

(Toggle Plain Text)

create proc sp_generic (@cust int, @type int)
if @type = 1
 select * from customer where customerid = @cust
else
 Select * from deleted_customers where customerid = @cust

Example B get just one department or all departments:

Help with Code Tags

(Toggle Plain Text)

create proc sp_generic (@deptid int )

select * from employees where departmentid = case when @dept >0 then @dept else departmentid end
order by departmentid

DaniWeb Home > Forums > Web Development > Databases > MS SQL > In-line If-Else Block?

Re: In-line If-Else Block?

In-line If-Else Block?

Re: In-line If-Else Block?