Forum Replies Created

Viewing 15 posts - 48,736 through 48,750 (of 59,102 total)

  • RE: Instead of Using Cursor? Other Ways?

    pockeyfan (8/14/2008)

    Thanks for your suggestion!

    I'm new to SQL and SP, will read the article to see whether I could apply it in my case...

    Tally table won't do it, in this...

    --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)

    August 17, 2008 at 7:40 pm

    #859232

  • RE: Instead of Using Cursor? Other Ways?

    Lester Policarpio (8/13/2008)

    "I think" it can be done using a tally table. Some experts here in the forum maybe can share something about it.

    And also please read the article...

    --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)

    August 17, 2008 at 7:17 pm

    #859228

  • RE: GOTO vs WHILE

    Heck... I wouldn't even use the WHILE loop... it's RBAR. Most WHILE loop solutions are because someone doesn't know T-SQL well enough to come up with the proper set...

    --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)

    August 17, 2008 at 7:05 pm

    #859224

  • RE: reset sequence when value of one column changes

    Loner (8/13/2008)

    It is SQL Server 2000 so I cannot use RANK, that is why I posted the question in this forum.

    The one you posted for SQL Server 2000 worked liked...

    --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)

    August 17, 2008 at 7:00 pm

    #859222

  • RE: Arrays

    You can get by without creating the extra temp table...

    SELECT d.Name,t.N*10 AS DeciCount

    FROM (SELECT Name,COUNT(*) AS TheCount

    ...

    --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)

    August 17, 2008 at 6:53 pm

    #859220

  • RE: Selecting The Top 3 Numbers Used The Most

    Lian Pretorius (8/12/2008)

    karthikeyan (8/12/2008)

    Hey Trevor,

    I have tested the below script, It is giving perfect result.

    Same here.

    Trevor, Karthik's script above uses a temp table - Which cannot be used in view's...

    --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)

    August 17, 2008 at 6:45 pm

    #859216

  • RE: dbo

    It means "DataBase Owner" and is a server role. Lookup server roles in Books Online.

    --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)

    August 17, 2008 at 6:39 pm

    #859213

  • RE: List out SP's Columns into a Table

    sqlindia (8/12/2008)

    Hi All

    I want to list out columns name of SP into a table. They can be dynamic.

    Thank in advance

    sonny

    I'm pretty sure this can't be done reliably. Sure,...

    --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)

    August 17, 2008 at 6:38 pm

    #859212

  • RE: Creating CLR assemblies with VS 2008

    I guess I'd have to ask... what does the CLR and the C# function 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)

    August 17, 2008 at 6:17 pm

    #859208

  • RE: Beginner Question about CLR

    So far, the only place I've seen CLR's beat T-SQL is in the area of RegEx Replace...

    --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)

    August 17, 2008 at 6:10 pm

    #859206

  • RE: Risk Of Enabling CLR

    Denby (7/21/2008)

    Also, is the anything i should be monitoring from a DBA's perpective if feature is enable.

    Absolutely! First, I'd make bloody sure that the source code was in 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)

    August 17, 2008 at 6:09 pm

    #859205

  • RE: IdentityColumn is Duplicated ?

    dolly (7/30/2008)

    In my web based application Identity column is duplicated when simultaneously record are inserted by different machine

    (i think so) i will solution for handling...

    --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)

    August 17, 2008 at 6:01 pm

    #859204

  • RE: XML

    Without a whole lot more information ;), my answer would be... change it so it doesn't do that anymore. 🙂

    You might want to conscribe any XML to the VARCHAR(MAX)...

    --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)

    August 17, 2008 at 5:16 pm

    #859201

  • RE: How to use stored procedure instead of cursors?

    It's a paradigm shift... with Cursors, you think "rows"... with setbased programming, you must learn to think "columns"... as in "What do I need to do to this column for...

    --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)

    August 17, 2008 at 5:12 pm

    #859200

  • RE: Debugger For SQL

    Lemme get this straight, Carl... you think it's better for the app to write and pass data in the forum of Unioned SELECT statements than to pass a comma seperated...

    --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)

    August 17, 2008 at 5:04 pm

    #859199

Viewing 15 posts - 48,736 through 48,750 (of 59,102 total)