Forum Replies Created

Viewing 15 posts - 46,516 through 46,530 (of 59,062 total)

  • RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

    psmg01 (12/17/2008)

    Hi SSC,

    Thanks for your reply.

    Is there a url for a site, where I can generate sql for crosstab?

    or How to write the query in my case?

    I am...

    December 17, 2008 at 2:20 pm

    #914162

  • RE: Guest Editorial: On writing SQL

    BWAA-HAAAA! As opposed to what? Today's bloated "systems" and people who think spreadsheets and XML are an efficient manner of data transfer? Right... 😉

    December 17, 2008 at 10:31 am

    #914018

  • RE: Are the posted questions getting worse?

    I'll throw my hat into the ring on all that! There is no place where I could have had the opporuntity to learn so much nor stretch the limits...

    December 17, 2008 at 9:39 am

    #913974

  • RE: The Full Potential of SQL 2000

    Lynn Pettis (12/17/2008)

    Co-worker at my previous employer really like Power Basic. Creates extremely fast and tight code. They recently added a /bloat switch that makes the executable bigger,...

    December 17, 2008 at 9:24 am

    #913949

  • RE: Useful Dates: The Many Uses of Date Tables

    TheSQLGuru (12/17/2008)

    Jeff, I am very interested in your findings! Perhaps this is one of those "step outside the box" situations where we all come out with something very useful...

    December 17, 2008 at 8:59 am

    #913925

  • RE: Are the posted questions getting worse?

    GilaMonster (12/17/2008)

    r.hensbergen (12/17/2008)

    Do posters think we're answering bots instead of real people?

    I suspect that some do, or think that we work for SSC. I recall someone apologising after I...

    December 17, 2008 at 8:49 am

    #913909

  • RE: Useful Dates: The Many Uses of Date Tables

    rkonopka (12/17/2008)

    Instead of double converting (first to varchar then back to datetime), wouldn't it be simpler and "cleaner" to do this:

    select dateadd(dd,datediff(dd,0,getdate()),0)

    Enjoyed the article

    Yes... and faster to boot.

    December 17, 2008 at 8:43 am

    #913901

  • RE: The Full Potential of SQL 2000

    rog pike (12/17/2008)

    The great silicon dividend has been wasted. How can anyone gloat over all the bloat

    Heh... man, do I agree with that! How many times have we heard...

    December 17, 2008 at 8:41 am

    #913899

  • RE: PIVOT vertical table without Aggregating

    david.c.holley (12/16/2008)

    Within that framework, the information that I provided would have been sufficient.

    I'll be looking for a forum a bit more consistent with my prior experience so as not to...

    December 17, 2008 at 8:29 am

    #913882

  • RE: Easy way

    Forgive my ignorance... does that mean that the reporting server has "linked servers" to all the other servers or does that mean all the data from the other servers is...

    December 17, 2008 at 8:11 am

    #913859

  • RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

    psmg01 (12/17/2008)

    Hi Jeff,

    I have a table that has the following values.

    col1 | col2 | col3 | col4

    1 | val1| val2 | val3

    2 ...

    December 17, 2008 at 8:08 am

    #913855

  • RE: Useful Dates: The Many Uses of Date Tables

    Brandon,

    Not sure what the text editor you used may have done to you, but there's a lot of missing spaces in your code... for example CREATE TABLE has become CREATETABLE...

    December 17, 2008 at 8:00 am

    #913845

  • RE: Are the posted questions getting worse?

    GilaMonster (12/16/2008)

    I think he's a developer in over his head.

    Heh... aren't they all?

    December 17, 2008 at 12:08 am

    #913633

  • RE: Are the posted questions getting worse?

    RBarryYoung (12/16/2008)

    Lynn Pettis (12/16/2008)

    bitbucket (12/16/2008)

    Jeff

    I particularly liked ol' Bit Bucket's response... I'm gonna have to add him to the pork chop hall of fame.

    Jeff should I be proud of...

    December 17, 2008 at 12:06 am

    #913631

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (12/16/2008)

    I always wonder what those things mean next to the threads. I tend to ignore them.

    Not sure I want a "twit" flag out there. As much...

    December 17, 2008 at 12:05 am

    #913630

Viewing 15 posts - 46,516 through 46,530 (of 59,062 total)