Search results for query: *

so a table variable doesn't allow indexes? is that right?

btw, is the table variable any quicker than just making a temp table?

Man, I've seen that trick setting variables in an update statement about a dozen times now and I always forget about it when I need it. Thanks again!

Yep, that worked, thanks hmckillop!

This is a nightly run that caches everybody's result at once. It is also a step in a process and the next step needs to know the user rankings (depth chart) in order to determine other things like who should start in the next game. hmckillop, It looks like your code will work. I'll let you...

I think the reason you can't user @@recordcount is that you aren't just setting recordcount once, you need to set it for each user in tblUser Here is the code again using the 'code' brackets --************************************** --snip --************************************** use comm2 set...

Yes, I'm familiar with @@recordcount, but if you paste my code into query analyzer I think you'll see that you can't apply @@recordcount w/o a cursor because the recordcount I want comes from a table: tbluser.selectTopN.

btw, donutman, how did you get your code to come in that nice neat block.

Thanks Donutman, but that code would require a cursor and that is what I am trying to avoid.

How can I select the top 'n' records w/o a cursor where 'n' is a value in a table? I've constructed two sample tables and a udf (below) that shows what I'm trying (unsuccessfully) to do. Essentially, I'm trying to allow my users to rank players (football) and then define how many of the top...

Thanks, that worked. Now for my next step in my evil plan :-) Can you help with this? I want be able to send a message from an external address (hotmail) to my groupwise address and then have groupwise forward that message to a list of users. I want the forwarded message to be formated...

Hi, I use delayed delivery (mostly to make people think I am working late--a wonderful motivational tool, i.e., he's working late? Maybe I should), but I am foiled by the stupid timestamp that Groupwise puts on messages. Try it. Make a new email to yourself, click file, properties...