Select host_name()

You must admit that we're the two biggest fish on that subject...

Told you he wasn't that bad... He has poor english and comes from another part of the world. He seems rude but I don't think it's all on purpose.

If you wanna see criticism or down right bashing, check for joe Celko's answers on this type of questions... My answer will look like a 2 months old baby licking...

the safest way would be to go like this (in case you forgot something in the validation or if you or someone else forgets to validate) : "exec dbo.sp ["...

Maybe that was just for testing... but you're right of course .

Not gonna happen today... I have other fish to fry .

WHERE (table.col = @varName or @vanName is null)

and

(table.col2 = @varName2 or @vanName2 is null)

Why can't you just rerun that sp when needed? You can insert the results in a temp table, then do all the count(*) you need to log the information.

No I like ADPS (ADE), but they are not the same as mdb. You're gonna have to see how much different they are by yourself.

As for the downloading the...

Then you shall send him a 24 pack .

Declare @a as int

SET @a = null

Declare @Tbl table (Col int primary key clustered)

insert into @Tbl (col) values (2)

insert into @Tbl (col) values (6)

insert into @Tbl (col) values (1)

insert into...

I think his comments were directed to me .

He specified his loops over sql server internal loops. There's no notion of set based approach in the question. Maybe I didn't understand the question correctly... wouldn't be...

What do you expect? We can't bribe the same guy for 70 messages...