Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. tomandlis

    how do I select the top n records

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

    how do I select the top n records

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

    how do I select the top n records

    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!
  4. tomandlis

    how do I select the top n records

    Yep, that worked, thanks hmckillop!
  5. tomandlis

    how do I select the top n records

    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...
  6. tomandlis

    how do I select the top n records

    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...
  7. tomandlis

    how do I select the top n records

    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.
  8. tomandlis

    how do I select the top n records

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

    how do I select the top n records

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

    how do I select the top n records

    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...
  11. tomandlis

    Delayed Delivery Timestamp

    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...
  12. tomandlis

    Delayed Delivery Timestamp

    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...

Part and Inventory Search

Back
Top