Forum Replies Created

Viewing 15 posts - 3,691 through 3,705 (of 8,761 total)

  • RE: Reaping the benefits of the Window functions in T-SQL

    Alan.B (9/1/2015)


    Hope it's not too late to say, "Great article Eirikur!". I just finished reading this for a second time (there is a problem that I was struggling with that...

  • RE: Select group by

    Corobori (4/21/2016)


    1) What I am showing in list1 and list2 is what I am expecting to get

    2) Pr_Id is the product id, Pr_Em_Id is the provider id

    Quick question, can you...

  • RE: Recording data in an .xml file to SQL server for tracking

    Further on Alan's questions, does it save a new file every 2 seconds or does it append to the existing file? Like Alan mentioned, this seems very straight forward with...

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (4/21/2016)


    That's the wrong guy. He's dbpub.com. There's a db-pub.com (hypen) that shows up, but isn't loading now.

    Ooops my bad, here is the db-pub.com registration

    😎

    Domain Name:...

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (4/21/2016)


    Luis Cazares (4/21/2016)


    BLOB_EATER (4/21/2016)


    Luis Cazares (4/21/2016)


    Brandie Tarvin (4/21/2016)


    Okay, this is weird. I went searching for an error I got in SSIS 2012 and the first thread that pops...

  • RE: Max value in Case Statements

    Luis Cazares (4/20/2016)


    Just to add timing to the performance tests.

    CREATE TABLE temp (ID int, [Date] DATE);

    WITH

    E(n) AS(

    SELECT n FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0))E(n)

    ),

    E2(n) AS(

    SELECT...

  • RE: Are the posted questions getting worse?

    WayneS (4/20/2016)


    Ed Wagner (4/19/2016)


    SQLRNNR (4/19/2016)


    GilaMonster (4/19/2016)


    And more homework in the forums. Is it wrong to want to post a sensible-looking but completely incorrect query as answers?

    Do it!

    Are you thinking something...

  • RE: Are the posted questions getting worse?

    Phil Parkin (4/20/2016)


    I apologise in advance for what I am about to say. In my spare time, I'm a proofreader and that probably explains some things. Forgive me, but ...

    ......

  • RE: Max value in Case Statements

    hegdesuchi (4/19/2016)


    I have a simple logic but i am missing something in below query.

    For all the records with Max(column), set the flag to 1 else 0. how can i...

  • RE: Are the posted questions getting worse?

    Jacob Wilkins (4/19/2016)


    Brandie Tarvin (4/19/2016)


    Phil Parkin (4/19/2016)


    Ed Wagner (4/19/2016)


    SQLRNNR (4/19/2016)


    GilaMonster (4/19/2016)


    And more homework in the forums. Is it wrong to want to post a sensible-looking but completely incorrect query as...

  • RE: Are the posted questions getting worse?

    Phil Parkin (4/19/2016)


    Ed Wagner (4/19/2016)


    SQLRNNR (4/19/2016)


    GilaMonster (4/19/2016)


    And more homework in the forums. Is it wrong to want to post a sensible-looking but completely incorrect query as answers?

    Do it!

    Are you thinking...

  • RE: Today's Random Word!

    Ray K (4/18/2016)


    Ed Wagner (4/18/2016)


    crookj (4/18/2016)


    Grumpy DBA (4/18/2016)


    DonlSimpson (4/18/2016)


    Revenant (4/18/2016)


    kosher

    Deli

    Sammich

    PB&J

    Ham

    Cheese

    Slice

  • RE: Performance tuning a query

    drew.allen (4/18/2016)


    Eirikur Eiriksson (4/18/2016)


    Why does the ActivitiesSamplesPartners join not have an ON clause or is it just bad code formatting?

    😎

    The tables are logically joined in the order of the ON...

  • RE: getting killed on new server

    Quick question, is the SQL server a VM or bare metal?

    😎

Viewing 15 posts - 3,691 through 3,705 (of 8,761 total)