Forum Replies Created

Viewing 15 posts - 376 through 390 (of 3,348 total)

  • RE: Finding related records within the same table

    First of all, I never buy the "we cannot change the data structure anymore" argument. The only argument I buy is that it would be too expensive, and the couterargument...

    August 5, 2016 at 12:45 pm

    #1894142

  • RE: Are the posted questions getting worse?

    ChrisM@Work (8/5/2016)

    More likely too focussed on the subject to recognise what the antagonist was up to 😀

    That does sound like me! :smooooth:

    August 5, 2016 at 9:55 am

    #1894084

  • RE: Are the posted questions getting worse?

    ChrisM@Work (8/5/2016)

    I've seen you deal with Stump the Chump, Hugo. SQL Bits Nottingham I think - a presentation on MERGE. It worked just fine.

    I did?

    Really?

    I always say that I've been...

    August 5, 2016 at 9:07 am

    #1894077

  • RE: Are the posted questions getting worse?

    ChrisM@Work (8/5/2016)

    Grant Fritchey (8/5/2016)

    BLOB_EATER (8/5/2016)

    I would like to get into the mind-set of speakers out there. Now, as it stands I have zero-interest in presenting/speaking due to a lack of...

    August 5, 2016 at 8:52 am

    #1894074

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (8/5/2016)

    Can anyone think of anything else I should consider (things that you all might customize and would want to save if you were getting kicked off your well-worn...

    August 5, 2016 at 6:09 am

    #1894023

  • RE: Are the posted questions getting worse?

    BLOB_EATER (8/5/2016)

    I would like to get into the mind-set of speakers out there. Now, as it stands I have zero-interest in presenting/speaking due to a lack of knowledge.

    My question is...

    August 5, 2016 at 5:10 am

    #1894007

  • RE: Today's Random Word!

    Ed Wagner (8/3/2016)

    djj (8/3/2016)

    whereisSQL? (8/3/2016)

    crookj (8/3/2016)

    Ed Wagner (8/3/2016)

    Y.B. (8/3/2016)

    Luis Cazares (8/3/2016)

    Hugo Kornelis (8/3/2016)

    Ed Wagner (8/3/2016)

    crookj (8/3/2016)

    djj (8/3/2016)

    Grumpy DBA (8/3/2016)

    djj (8/3/2016)

    Ed Wagner (8/2/2016)

    Audience

    Mob

    Mafia

    Made

    Created

    Born

    This way

    Out

    Side

    Winder

    (black) Mamba

    Venom

    Spiderman

    Arachnophobia

    Hippopotomonstrosesquipedaliophobia

    August 3, 2016 at 10:57 am

    #1893557

  • RE: Today's Random Word!

    Ed Wagner (8/3/2016)

    crookj (8/3/2016)

    djj (8/3/2016)

    Grumpy DBA (8/3/2016)

    djj (8/3/2016)

    Ed Wagner (8/2/2016)

    Audience

    Mob

    Mafia

    Made

    Created

    Born

    This way

    August 3, 2016 at 6:22 am

    #1893456

  • RE: ORDER BY ASC and NULLs last

    gauravsrmsin (8/3/2016)

    It will work as per required result and give the following result.

    1

    0

    -1

    NULL

    The problem posed in the question is this (emphasis mine):

    "I need to return the data sorted ascending and...

    August 3, 2016 at 1:26 am

    #1893411

  • RE: Today's Random Word!

    Luis Cazares (8/2/2016)

    Ed Wagner (8/2/2016)

    Ray K (8/2/2016)

    Ed Wagner (8/2/2016)

    Y.B. (8/2/2016)

    Revenant (8/2/2016)

    crookj (8/2/2016)

    Ray K (8/2/2016)

    Ed Wagner (8/2/2016)

    whereisSQL? (8/2/2016)

    Grumpy DBA (8/2/2016)

    Ed Wagner (8/2/2016)

    jasona.work (8/1/2016)

    scratch

    Itch

    Floozy

    woozy

    Sleep

    Wake

    Stir

    Stick

    Ball

    Volley

    Serve

    Food

    Please

    Crowd

    August 2, 2016 at 12:41 pm

    #1893326

  • RE: ORDER BY ASC and NULLs last

    gauravsrmsin (8/2/2016)

    It will also work if you write your query like below

    SELECT val FROM @table ORDER BY val desc

    How exactly would that sort in ascending order?

    August 2, 2016 at 3:31 am

    #1893159

  • RE: Are the posted questions getting worse?

    Grant Fritchey (8/1/2016)

    Gone for a week and come back to find you guys talking about Excel. Looking around now for talking apes and an exploded statue.

    The monkeys werer blown to...

    August 1, 2016 at 8:39 am

    #1892963

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (7/31/2016)

    Feel free to pitch in, someone not having a great day😀

    😎

    I think you already nailed it in your very first reply, but the OP either misunderstood or didn't...

    July 31, 2016 at 3:50 am

    #1892806

  • RE: Trying to use the HASHBYTES of a nvarcar(Max)

    joejuska (7/30/2016)

    You said "Quick questions, on what do you base that assumption?" I can't directly answer your question because YOUR QUESTION is wrong. IT'S NOT AN ASSUMPTION BUT AN...

    July 31, 2016 at 3:48 am

    #1892805

  • RE: Trying to use the HASHBYTES of a nvarcar(Max)

    joejuska (7/30/2016)

    No I DO NOT WANT TO HASH ONLY THE FIRST 50 CHARACTERS. I WANT TO HASH THE ENTIRE FILE BUT HAVE THE RESULTANT FIELD NVARCHAR(50) OR CHAR(50) INSTEAD...

    July 31, 2016 at 3:39 am

    #1892804

Viewing 15 posts - 376 through 390 (of 3,348 total)