Hmmm, remove points for bad jokes. I might need to get a big purple button on each post for enforcing that.

Taxes

I didn't write this earlier, but I tend to agree that mandates don't necessarily help. There are plenty of doctors that don't keep up, or that don't get much from...

I'd like to do it every month. I need to get the topics out in advance. Someone actually asked me to drop this in there, and they put it out...

Ah, 5.25" floppies, memories...

I hope they do read it! I know a few PMs that tend to read the editorials, so hopefully this is one they catch.

That doesn't really help. For example, are you looking for the test itself? Someone's answers? The data on the test? There are any number of things that relate to a...

I don't think the checkpoint is needed. Once you switch to simple mode, a checkpoint will get run and until the full is run, you might be stuck.

Note that once...

I flip through the emails I get to keep up. That and the "Active Threads" to the left.

Not sure about the RSS. There might be some authentication here that's needed....

Basically you can use the stored procedure sp_msforeachtable and pass in a "SELECT * where TESTID = xxx" for this. you'll get a series of result sets, one for each...

Two things,

1. do you have rights for this? Sysadmin or serveradmin rights?

2. What code did you run?

You should post the code you're running, some sample data, and where the dups are occuring.

I might change the "in" to an = as well

Please update this if you find any issues. It would be good to know if there is anything else you find, other than what Jason noted.

Yep, I've seen lots of questions like that. So often management doesn't want a better solution. They just want one working, and having you move on to something else.

It is...

Or just a

select top 1

max(date), col1, col2, col3

from mytable

group by col1, col2, col3