Forum Replies Created

Viewing 15 posts - 49,816 through 49,830 (of 59,091 total)

  • RE: eliminating duplicates

    Oh, very clever... well done, Barry!

    Only corrections are to remove the CASE in the final insert and to delete the compressed rows...

    Other than that, very, very clever... 🙂

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 21, 2008 at 2:46 pm

    #832293

  • RE: eliminating duplicates

    Tally table method in 2000 for this would require a triangular join... I believe. If you know a way to do this in 2k without using a loop but...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 21, 2008 at 12:53 pm

    #832271

  • RE: Rules, Defaults and the SQL Standard

    Jeff Moden (6/21/2008)

    Steve Jones - Editor (6/21/2008)

    SQL Apprentice Jeff...has a nice ring to it. Maybe we can chip in for a pointy hat for you to wear to the meetings...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 21, 2008 at 12:51 pm

    #832270

  • RE: Rules, Defaults and the SQL Standard

    rbarryyoung (6/21/2008)

    I want to add that IMHO, the reason that the work of ths ANSI SQL has seemed so out of step with users and practioners for the last 15...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 21, 2008 at 12:50 pm

    #832269

  • RE: Rules, Defaults and the SQL Standard

    Steve Jones - Editor (6/21/2008)

    SQL Apprentice Jeff...has a nice ring to it. Maybe we can chip in for a pointy hat for you to wear to the meetings 😉

    Heh... you...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 21, 2008 at 12:47 pm

    #832268

  • RE: What's the difference. . .

    Dang... I just can't beat the kids anymore... 😀

    Very nice, Matt. Thanks.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 21, 2008 at 12:40 pm

    #832266

  • RE: What's the difference. . .

    Matt Miller (6/21/2008)

    I'm looking at this now - and I'm not so sure at all about this. I don't get the same results out of Count(*) as I do...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 21, 2008 at 9:12 am

    #832220

  • RE: use a sequence of column values in a query

    Absolutely perfect... you actually need to use two tables... let's say you have TableA and TableB and they are identical. You have a view or a synonym pointing...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 21, 2008 at 8:34 am

    #832206

  • RE: Get TempTable name

    Mobasha,

    To be true, there is a UID (User ID) column in the TempDB..SysObjects comapatibility view of SQL Server 2005... it's not the ID of the person that made it, though......

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 21, 2008 at 8:14 am

    #832202

  • RE: TAB

    I don't understand why you think there's a problem... no one else has access to the Temp Table or Table Variables... why are you using a transaction on them? ...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 21, 2008 at 8:01 am

    #832200

  • RE: How to ignore the comma seperator inside ","

    sharma (6/21/2008)

    Thanks..

    I am using BULK INSERT in that i had specified ROW TERMINATOR & FIELD TERMINATOR only.

    How to specify a TextQualifier?

    I had used format file also.

    To the best of my...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 21, 2008 at 7:57 am

    #832199

  • RE: eliminating duplicates

    ...and, if you just happend to have posted in the wrong forum and you actually have SQL Server 2005, you need to let us know that because there's a very...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 21, 2008 at 1:05 am

    #832177

  • RE: PLEASE HELP

    sqldba (6/20/2008)

    But in this case , the apllication is sending some strings

    example

    (SVDB, N, Y; SFGB, N, N; SGTE Y, S; SVHG Y,Y; SVFH, Y, Y; ........)

    data set in string...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 21, 2008 at 12:57 am

    #832175

  • RE: PLEASE HELP

    karthikeyan (6/20/2008)

    sqldba,

    first of all try yourself, otherwise you can't learn anything new. Try to write your own SP. Becuase it is a basic one, without knowing how to wite a...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 21, 2008 at 12:54 am

    #832174

  • RE: eliminating duplicates

    There is a way to do this using SET ROWCOUNT 1 and a cursor (which is technically an intermediate table but fools most people). Performance will totally suck. ...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    June 21, 2008 at 12:37 am

    #832172

Viewing 15 posts - 49,816 through 49,830 (of 59,091 total)