Forum Replies Created

Viewing 15 posts - 3,631 through 3,645 (of 4,080 total)

  • RE: A Case For Concatenation (Building Delimited Strings ) In T-SQL

    Thanks Jeff:

    I realize that I've got a double thread going now, and I just had a light bulb go on when I looked at elapsed time for writing to disk,...

    __________________________________________________

    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

    Jeff, this is a tremendous learning experience for me, so please hang in with me a little while longer.

    I notice that you are grouping on an int...

    __________________________________________________

    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

    My first thought was, "You're kidding.....", but I know you are not.

    O geez.

    By the way I experimented with a larger number of departments (20) and the concatenation started running a...

    __________________________________________________

    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

    You're a lot more current than I am, so I'll take your word for it. Thanks 🙂

    __________________________________________________

    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?

    All hail The Thread.

    Mighty, Mighty is The Thread.

    All-Knowing, All-Merciful....

    Is this the beginning of a Cult of the ThreadHeads?

    __________________________________________________

    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: A Case For Concatenation (Building Delimited Strings ) In T-SQL

    (Sigh... nobody has a sense of humor anymore.)

    Guys, I've learned to document code out of self-preservation... because I may be the one who has to revisit the code months 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: A Case For Concatenation (Building Delimited Strings ) In T-SQL

    Ah... but you are denying them the opportunity to broaden their horizons and expand their minds by saying "What the...? How did he DO that???" ...

    __________________________________________________

    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: Cross Apply

    You don't get the speed benefits of cross apply unless the UDF is a an inline table valued function. Because an inline table valued function is a...

    __________________________________________________

    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: A Case For Concatenation (Building Delimited Strings ) In T-SQL

    Jack, I can see that it would be considered advanced. I never heard about using FOR XML this way until the last couple of months. But...

    __________________________________________________

    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: A Case For Concatenation (Building Delimited Strings ) In T-SQL

    I'm afraid I can't, but I will listen respectfullly to anyone who can, if they'd care to report their results. However, I see that as a different issue...

    __________________________________________________

    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?

    Why don't you start a thread in the Strategies forum?

    Just did, thanks 🙂

    http://www.sqlservercentral.com/Forums/Topic663702-49-1.aspx

    __________________________________________________

    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?

    Gail, can I respond to the "doing things where they make sense" through an email or something? I think there is a case where it does make...

    __________________________________________________

    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 just answer "do what Jeff said" and go on my way

    Sure... spoil my fun... 😉

    Steve, it wasn't really a dispute. I'm trying hard to adopt...

    __________________________________________________

    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?

    More likely, everyone was so busy chatting about favourite books that no one answered any questions.

    Not true, Gail!! I even got into a dispute with Jeff about concatenation!!

    Of...

    __________________________________________________

    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?

    How do you recognize the Episcopalians at a Star Wars convention?

    When someone says "May the Force be with you.", the Episcopalians reply "And also with you."

    (Don't worry, Steve... I...

    __________________________________________________

    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,631 through 3,645 (of 4,080 total)