Forum Replies Created

Viewing 15 posts - 43,156 through 43,170 (of 59,063 total)

  • RE: Help Needed ???

    [font="Arial Black"]I still want to know the business requirement behind all this, please.[/font]

    Ok... here's a very simple answer especially if you have more than 3 columns that you need to...

    --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 29, 2009 at 8:12 pm

    #1017329

  • RE: Help Needed ???

    mandirkumar (6/29/2009)

    Hi ALL

    I have a table and I need both horizontal and vertical sorting for the table

    Example:-

    What is the business requirement behind doing this? It...

    --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 29, 2009 at 7:33 pm

    #1017319

  • RE: get real!

    SanjayAttray (6/29/2009)

    in SQL server 2005 result is 1.234568E+09

    while in SQL 2000 result is 1.2345679E+9

    Does it make any difference ?

    Heh... only if you're answering a QOD and only if both answers...

    --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 29, 2009 at 6:24 pm

    #1017314

  • RE: Split string using XML

    peter (6/29/2009)

    I have a set of comma delimited strings which have between 1 and 100's of invoice records per string (with each invoice record having the same 10 data fields)....

    --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 29, 2009 at 6:09 pm

    #1017311

  • RE: printing 1 to 100 in SQL Server as a batch....

    I'm pretty happy that someone brought up the fact that when you're going to be doing something like genning numbers using systems tables or views, that the end user "must...

    --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 29, 2009 at 4:23 pm

    #1017293

  • RE: Are the posted questions getting worse?

    Heh... solve it all... store everything in one big EAV with SCD 2 applied to eliminate the need for separate auditing or archiving... 😛

    --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 29, 2009 at 10:52 am

    #1016982

  • RE: printing 1 to 100 in SQL Server as a batch....

    Lynn Pettis (6/29/2009)

    And that will work until the SQL Server 2000 system table "views", like sys.syscolumns, go away in a future version od SQL Server. They have been depreciated.

    I'm...

    --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 29, 2009 at 8:41 am

    #1016868

  • RE: converting lowercase to uppercase

    Peso (6/29/2009)

    Or use COLLATION

    CONSTRAINT ss CHECK (adp IN ('T', 'F') COLLATE SQL_Latin1_General_Cp437_BIN)

    That's a good check but I'd have to introduce someone to a serious volley of high speed pork chops...

    --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 29, 2009 at 6:41 am

    #1016785

  • RE: 911 - Cursor killing my trigger

    As a side bar, I'm still waiting for the OP to post code where the things he wants to use aren't actually commented out so I can be sure of...

    --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 29, 2009 at 6:37 am

    #1016782

  • RE: 911 - Cursor killing my trigger

    Scott Coleman (6/29/2009)

    It is a triangular join, but without knowing more about the data I'm just guessing that there are a relatively small number of notes for each bug. ...

    --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 29, 2009 at 6:33 am

    #1016779

  • RE: printing 1 to 100 in SQL Server as a batch....

    Paul White (6/29/2009)

    Peso (6/29/2009)

    I only have 92 column in my master.sys.columns.

    This is because I have an edited very slim version of MASTER database.

    This is not something common, but you should...

    --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 29, 2009 at 6:14 am

    #1016765

  • RE: Retrieve comma-separated list within group by

    In order to do the concatenation to create the CSV list, some form of sub-query either in the form of an actual sub-query or in the form of a UDF...

    --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 29, 2009 at 5:58 am

    #1016750

  • RE: printing 1 to 100 in SQL Server as a batch....

    Sinshith S Anand (6/28/2009)

    Actually i was expecting different methods for counting 1 to 100.Methods using CTE,While loop,Go to,Cursor......I was expecting some different methods than this...Gail posted a different method...Thats why...

    --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 29, 2009 at 5:53 am

    #1016746

  • RE: Split string using XML

    Chandra Sekhar Manchukonda (6/29/2009)

    We are having only five characters ( , ', ", & ) that need escape character in XML.

    We can use replace function for handling them.

    DECLARE @test-2...

    --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 29, 2009 at 5:42 am

    #1016740

  • RE: Split string using XML

    sam.walker (6/29/2009)

    Ignore that last post.

    I've just simply compared on my server.

    Rows 4096 based on huge repitition of AAAA,BB,CCCCCCCCC,D

    Inline function

    126 ms

    123 ms

    130 ms

    Partial CLR plus tally table

    3 ms

    3 ms

    3 ms

    I used...

    --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 29, 2009 at 5:39 am

    #1016734

Viewing 15 posts - 43,156 through 43,170 (of 59,063 total)