Forum Replies Created

Viewing 15 posts - 91 through 105 (of 183 total)

  • RE: Date with No time...

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

  • RE: Date with No time...

    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...

  • RE: Could not find installable ISAM

    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...

  • RE: Getting Top 1 record from group

    Try this:

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

    HTH.

  • RE: Propblem with Where clause (days in month)

    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...

  • RE: Multiple columns in one single column

    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...

  • RE: Could not find installable ISAM

    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...

  • RE: Could not find installable ISAM

    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...

  • RE: Return Newest records first

    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...

  • RE: Return Newest records first

    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...

  • RE: How to do autonomous transaction in SqlServer 2000

    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...

  • RE: Using Technology to Terrorize

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

  • RE: Using Technology to Terrorize

    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. ...

  • RE: Cannot Get File Written with OSQL and xp_Cmdshell via APP

    Excellent - happy to help.

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

  • RE: Cannot Get File Written with OSQL and xp_Cmdshell via APP

    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...

Viewing 15 posts - 91 through 105 (of 183 total)