SET @Count = 1

...

while @Count = 3

since when does 1=3???

You don't have a choice...

Easier when I'm browsing microsoft to download vs studio/sql server september, framework 2.0.... .

No need to bet you... Noeld's there .

I can.

What's the cost of creating/droping a temp table for each use, then populate it with 50 round trips on the server to do then a join??

What's the cost...

HTH.

Hey bull, how you doing ??

DECLARE @Count as integer

DECLARE @Done as bit

SET @Count = 0

SET @Done = 0

WHILE @Done = 0

BEGIN

SET @Count =...

I can't imagine this working in a multi-user environement where they all need to get results based on a list of criterias. I think my solution would be more...

I haven't heard of fortune 100 shops before... what's that like ?

Is this some homework or you need this to go on a production server??

That's why I always ask why the heck do you want to do that for... now I'll rememeber to never forget to ask that again

It wouldn't break if it weren't for us .

Keep thinking about it. I used the word derived table.

Check out the counter... it goes up about 8 reads/second on that article .

Come on guys, you're late now .