Forum Replies Created

Viewing 15 posts - 7,171 through 7,185 (of 8,753 total)

  • RE: Return single row for matching columns based on 3rd column

    jamie_collins (9/3/2014)

    Worked great.

    Added DISTINCT to remove the duplicates but this is what I was after.

    Thanks.

    An alternative is to use the ROW_NUMBER function to filter the output

    😎

    USE tempdb;

    GO

    ;WITH BASE_DATA(Ticket,[User],[Priority]) AS

    (SELECT...

    September 3, 2014 at 10:47 pm

    #1743079

  • RE: export table

    Jeff Moden (9/3/2014)

    I didn't know there was ever a "good" case for XML. 😉

    Well now you know as you've just made one:-D

    😎

    September 3, 2014 at 10:36 pm

    #1743075

  • RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

    gbritton1 (9/3/2014)

    I'm using the splitter (just downloaded the zip file) and noticed something odd. Dunno if its just me, but check this out:

    select * from dbo.[DelimitedSplit8K](' ', ' ')...

    September 3, 2014 at 10:32 pm

    #1743073

  • RE: export table

    Jeff Moden (9/3/2014)

    Eirikur Eiriksson (8/25/2014)

    Jeff Moden (8/25/2014)

    Eirikur Eiriksson (8/25/2014)

    Feel I'm starting to repeat my self on the issue:pinch:

    BWAAA-HAAA!!! Me too!

    Switching from one delimiter to another is a form of...

    September 3, 2014 at 10:17 pm

    #1743072

  • RE: using linked server object name in join statements, a best practice?

    polkadot (9/3/2014)

    thinking about this further, I don't see evidence from my reading, that two different servers can't both point to the same third machine using the same linked server name.

    Additionally,...

    September 3, 2014 at 3:40 pm

    #1743027

  • RE: Are the posted questions getting worse?

    GilaMonster (9/3/2014)

    Eirikur Eiriksson (9/3/2014)

    BTW, the bouncing is easy, it's the catching of the server exceptions which is tricky

    You just need a large net. What's so difficult about that?

    That of course...

    September 3, 2014 at 3:13 pm

    #1743019

  • RE: Are the posted questions getting worse?

    SQLRNNR (9/3/2014)

    Eirikur Eiriksson (9/3/2014)

    Alvin Ramard (9/3/2014)

    Koen Verbeeck (9/3/2014)

    xsevensinzx (9/3/2014)

    I keep coming to this thread just to read all your fueled responses. It's baiting me to post a seriously dumb question...

    September 3, 2014 at 2:51 pm

    #1743014

  • RE: Adding a number to a string to create series

    CELKO (9/3/2014)

    It's a YACK, yet another combined key

    I like that initialism! Put it together, then pull it apart over and over and over ..

    Spot on! The subject is a...

    September 3, 2014 at 2:49 pm

    #1743013

  • RE: Are the posted questions getting worse?

    Alvin Ramard (9/3/2014)

    Koen Verbeeck (9/3/2014)

    xsevensinzx (9/3/2014)

    I keep coming to this thread just to read all your fueled responses. It's baiting me to post a seriously dumb question just to read...

    September 3, 2014 at 2:19 pm

    #1743005

  • RE: Are the posted questions getting worse?

    Luis Cazares (9/3/2014)

    Koen Verbeeck (9/3/2014)

    Bah. I couldn't resist it.

    Someone call the Relational Protection Agency, we have an offender...oh, wait. 😀

    Reminds me of an old story, once upon a time the...

    September 3, 2014 at 2:08 pm

    #1743000

  • RE: Return single row for matching columns based on 3rd column

    Quick solution (if I got it right 😉

    😎

    USE tempdb;

    GO

    ;WITH BASE_DATA(Ticket,[User],[Priority]) AS

    (SELECT Ticket,[User],[Priority] FROM

    ( VALUES

    ('A','ME' , 1)

    ...

    September 3, 2014 at 1:57 pm

    #1742996

  • RE: Programmatically generate a number sequence

    Ray K (9/3/2014)

    Eirikur Eiriksson (9/3/2014)

    Ray K (9/3/2014)

    Eirikur Eiriksson (9/3/2014)

    I share Sean's concern here, at least there should be a check for the key-number existence and adjustment if there is a...

    September 3, 2014 at 1:35 pm

    #1742986

  • RE: Programmatically generate a number sequence

    Ray K (9/3/2014)

    Eirikur Eiriksson (9/3/2014)

    I share Sean's concern here, at least there should be a check for the key-number existence and adjustment if there is a key combination collision.

    😎

    Folks, you're...

    September 3, 2014 at 12:51 pm

    #1742965

  • RE: Adding a number to a string to create series

    CELKO (9/3/2014)

    I have an EventID that may have many sub events. ..How can I check what the EventID is, then concatenate a sequence number by the EventID?

    Why are you...

    September 3, 2014 at 12:39 pm

    #1742963

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (9/3/2014)

    TomThomson (9/3/2014)

    Luis Cazares (9/3/2014)

    xsevensinzx (9/3/2014)

    Koen Verbeeck (9/3/2014)

    xsevensinzx (9/3/2014)

    I keep coming to this thread just to read all your fueled responses. It's baiting me to post a seriously dumb...

    September 3, 2014 at 11:05 am

    #1742925

Viewing 15 posts - 7,171 through 7,185 (of 8,753 total)