Debra Owens (1/25/2008)
After running several test the top 1000... will not work with the query.The user name and date is being queried, member quired is not one of the 1000 returned therefore, no items selected.
When I run it with the udf random it works.
Debra - the "top 1000" was there for my purposes (the test table was rather large). I just wanted to highlight the Checksum(NewID()) method....
You absolutely don't need the TOP n syntax if your case doesn't lend itself to it.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?