Viewing 15 posts - 91 through 105 (of 183 total)
No problem... glad to see the 12 mugs of coffee today have paid off and kept me awake!
August 30, 2005 at 11:09 am
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...
August 30, 2005 at 11:00 am
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...
August 25, 2005 at 10:52 am
Try this:
SELECT * FROM @players p WHERE ReportDate = (SELECT MAX(ReportDate) FROM @players q WHERE p.PlayerId = q.PlayerId)
HTH.
August 23, 2005 at 4:59 am
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...
August 23, 2005 at 3:56 am
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...
August 23, 2005 at 3:40 am
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...
August 19, 2005 at 4:22 am
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...
August 18, 2005 at 10:51 am
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...
August 3, 2005 at 10:02 am
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...
August 3, 2005 at 5:44 am
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...
July 28, 2005 at 7:04 am
Precisely... it is not HOW they do it, it's the fact they do it in the first place, that is the problem.
July 19, 2005 at 10:03 am
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. ...
July 19, 2005 at 6:45 am
Excellent - happy to help.
I've been caught out by this one many times before!
July 15, 2005 at 2:56 am
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...
July 14, 2005 at 10:30 am
Viewing 15 posts - 91 through 105 (of 183 total)