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

still not sure I understand fully what you want but maybe this will help

Help with Code Tags

(Toggle Plain Text)

if (mgr.stafflevelid IN (/* HERE WOULD BE SUBQUERY*/) 
	select [columns] from [tables] where e.active <> 0 and e.stafflevelid=m.stafflevelid and p.dept = m.dept) 
else
	select [columns] from [tables] where e.active <> 0

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?