Forum Replies Created

Viewing 15 posts - 3,676 through 3,690 (of 4,080 total)

  • RE: Are the posted questions getting worse?

    Returning to the idea of returning to the idea of this thread becoming self aware and evolving into Skynet is recursive.

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Are the posted questions getting worse?

    Returning to the idea of this thread becoming self aware and evolving into Skynet is recursive.

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Display column of different rows as column of a single row

    Why ask why? 😉

    I get these kinds of requests from our reports group. Some people want to squeeze as much information as they can onto a screen or...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Trouble with a Select and Group By

    When dealing with CTE's, keep in mind that you aren't really specifying a sequence of steps, it just reads that way. The optimizer treats it all as...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Display column of different rows as column of a single row

    This ought to get you started. The key to this is using "FOR XML" to do concatenation of the strings for the groups each employee belonged...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: OpenRowSet Error

    KT:

    You are dealing with what I call a "gremlin". A gremlin is an unexplained intermittent error. Without more information, I can't help you. ...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Are the posted questions getting worse?

    Back after 36 hours off and had to spend half an hour playing catch-up on this thread.

    Barry: Glad to see you recognized Eron. I used...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: View Dependency + Tracking is possible ?

    This should help you identify the set of views which need to be changed. I cringe at the idea of views nested within views, but good luck.

    select...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Are the posted questions getting worse?

    I pay them no mind. It's always good for ME 😉

    It's Friday night and we're online. We have GOT to get lives, Jeff.

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Column limitations when using OpenRowSet to import a txt file into a sql server table

    I tried to research this issue but couldn't find anything definite. However, if you use OpenRowset with a BCP format file, you are usually going to create the...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Are the posted questions getting worse?

    Barry: Wrath of God and Blinkies... an evil combination for a white deck. I remember a thread somewhere that was titled BLINKING @#$&ing SPIRITS DIE...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Are the posted questions getting worse?

    FBI1971US@yahoo.com

    This is the email address listed by our man Joe in his first-ever post. Use it at your own risk 😉

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: OpenRowSet Error

    This isn't really a T-SQL issue, because your code USUALLY works.

    That error doesn't give much to go on, and you say rebooting the server fixes the problem. ...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Are the posted questions getting worse?

    finished around 30th out of 250 with a record of 6-2-0

    Well I'm impressed!!

    Barry, please tell me you weren't playing a creatureless blue deck or something jank...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Are the posted questions getting worse?

    Bonus points to Max!

    Lynn, I was just kidding around. The "rude" reference was to the second quote in my list and was intended as a joke. ...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

Viewing 15 posts - 3,676 through 3,690 (of 4,080 total)