No problem... glad to see the 12 mugs of coffee today have paid off and kept me awake!

Would CONVERT(datetime, CONVERT(varchar, [datefield], 101)) work?

Haven't tried it but just a thought... because it strips out time references and into mm/dd/yyyy format then back to datetime, theoretically it should default...

We haven't had any problems since, but that's interesting to hear that it's cropped up again for you. I'll post on this thread if it happens again; similarly if...

Try this:

SELECT * FROM @players p WHERE ReportDate = (SELECT MAX(ReportDate) FROM @players q WHERE p.PlayerId = q.PlayerId)

HTH.

Assuming @DParm (datetime) is parameter passed to SP and DateCol (datetime) is date column in table, I think this should work?

(I haven't tested this.)

WHERE (DatePart(day, @DParm) = DatePart(day, DateCol)) OR...

Please can you clarify your design? It's unclear whether your email addresses are stored in separate columns in the same table or in a separate table that you're joining...

It's started working again since the reboot last night.

I'm unsure if it was the MDAC install or simply the reboot that helped, but with Andy's comments in mind I expect...

SP4 was put on on Tuesday 16th.  Windows updates last applied a little before that.

The routine ran fine on Wednesday 17th, nothing else changed, but it won't run today.

We've re-installed...

Should work in the linked server's syntax (might also depend on the driver being used) if you put the WHERE clause inside the passthrough query too.

I do it with Progress...

Calli's solution should work. If I understand correctly, the way you are doing it now, it will return the first 100 results from the passthrough query without ordering, then...

If I understand you correctly, then to my knowledge, what you ask for is not directly supported.

However, you may find useful this little workaround I use to make log entries...

Precisely... it is not HOW they do it, it's the fact they do it in the first place, that is the problem.

On a trip to Northern Ireland this year, upon being told the Europa in Belfast was the most bombed hotel in Europe, I decided to have a pint there. ...

Excellent - happy to help.

I've been caught out by this one many times before!

When you say the other users can "see" the file & folder, do you mean that they have also got Write and Delete permissions in that folder (and on the...