Thanks for your input guys. Yes this is SQl2000 🙂

I've also not got a column where I can determine that the hour = 1 or 2 or 3 etc..But...

Hi, I'm getting a similar problem on a server with Windows 2003 SP2. Did you patch your server beyond this level ??

thanks

Sorry, but dont understand that. The link assumes you can split the data across columns like a partition. This table has one date column only, I need to extract...

Thanks very much for that, minor tweaks and works perfectly 🙂

Thanks very much for that...worked fine!

Hi Scott, thanks for your resposne. Yes I was trying exactly what I'd typed. I had tried this just a few hours ago actually and like you say had...

Thanks for that CRC. Unfortunately like I say its part of a much larger piece of code which has other joins ands columns its retrieving and i cant limit...

Opps of course, just got that. :blush: Thanks for confirming Gail

Hi, yes they are all distinct values. Again, if I place the update statement in front of it I still get the error - 'Subquery returned more than 1 value'

thanks

Thanks guys. Yes basically I just need to see when a specific table has been accessed via a select (or other) statement. Could you please give me an...

Thats great, thanks everyone! 🙂

Thanks for that, yes I'd seen that the 'Audit Schema Object Access Event' trace option might pick it up so I could use that. I'll test it. Could you let...

Thanks again everyone for your valued input. Fortunately although the table is large the actual groups to be ranked are always less than 5.

Thanks for all your help guys. Matt, your script did the job fine!!!

However we are currently testing against a limited set of rows so I will insist we do...

Thanks for that effort, it looks very complicated for what I want though.

To make it easier ...lets say that I just have a table with just one column, trans_code and...