Viewing 3 posts - 16 through 18 (of 18 total)
I didn't handle nulls in your output, but I got you as far as that problem...
/*building my input*/
create table myInput (sn int, fld int)
insert into myInput values (1,3)
insert into myInput...
March 19, 2007 at 2:16 pm
#695804
There's not much of an if/then since you want "if/both". Assuming the datatypes of your Counselor and Advisor fields are manageable, you can...
March 19, 2007 at 12:54 pm
#695786
Once you have your output from exec sp_who2 tabled, you use the same method to capture your DBCC output and join the two temp tables together on spid...
create table #temp...
March 19, 2007 at 9:52 am
#695755