Forum Replies Created

Viewing 15 posts - 45,121 through 45,135 (of 59,095 total)

  • RE: How to avoid Cursors?

    kishoregowtam (2/16/2009)

    Hi,

    I have requirement where I stores all quesries which need to be executed are stored in a table.

    Name of Table: Table1

    Column Name: Query--- Varchar(MAX)

    Query contains values...

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

    February 16, 2009 at 4:18 pm

    #944900

  • RE: How to avoid Cursors?

    Ramesh (2/16/2009)

    Or you can do something like...

    DECLARE @strSQL VARCHAR(MAX)

    SELECT @strSQL = COALESCE( @strSQL + '; ', '' ) + Query FROM Table1

    PRINT @strSQL

    --EXECUTE( @strSQL )

    Well done.

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

    February 16, 2009 at 4:17 pm

    #944897

  • RE: Help Me !!!

    If you can't speak English, it'll be difficult to refer you to a site that caters to non-English speaking folks. If you want to try...

    http://www.w3schools.com/sql/default.asp

    There are, of course, others......

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

    February 16, 2009 at 4:07 pm

    #944893

  • RE: Problem With IsNumeric()

    Bruce W Cassidy (2/16/2009)

    Jeff Moden (2/16/2009)

    Bruce W Cassidy (2/16/2009)

    In another thread, Jeff [font="Arial Black"]Modan [/font]reminded me that numbers of the form '1d3' and '1e3' are legitimate.

    Heh... and Bruce W [font="Arial...

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

    February 16, 2009 at 3:48 pm

    #944889

  • RE: Problem With IsNumeric()

    For more on the supposed problems with ISNUMERIC, please visit the following thread...

    http://www.sqlservercentral.com/Forums/Topic243646-8-1.aspx#BM245050

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

    February 16, 2009 at 3:46 pm

    #944888

  • RE: Problem With IsNumeric()

    Bruce W Cassidy (2/16/2009)

    In another thread, Jeff [font="Arial Black"]Modan [/font]reminded me that numbers of the form '1d3' and '1e3' are legitimate.

    Heh... and Bruce W [font="Arial Black"]Cassody [/font]used the information 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)

    February 16, 2009 at 3:36 pm

    #944881

  • RE: Help, my database is corrupt. Now what?

    Awesome article, Gail. Wish I had it when MSDB went sour on one of my Dev servers especially since my predecessors saw no need to backup a Dev Server....

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

    February 16, 2009 at 3:29 pm

    #944877

  • RE: SQL or Oracle

    gints.plivna (2/16/2009)

    Jeff Moden (2/16/2009)

    Roy Ernest (2/16/2009)

    Calm down people ... Calm down...:D It is a Monday afternoon...:D Not the best day to have arguments.... 😉

    It's a GREAT day for arguments! ...

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

    February 16, 2009 at 2:17 pm

    #944854

  • RE: SQL or Oracle

    Roy Ernest (2/16/2009)

    Calm down people ... Calm down...:D It is a Monday afternoon...:D Not the best day to have arguments.... 😉

    It's a GREAT day for arguments! 😛 Too...

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

    February 16, 2009 at 2:04 pm

    #944847

  • RE: SQL or Oracle

    Bruce W Cassidy (2/16/2009)

    Gift Peddie (2/16/2009)

    At least on 2006 the business chose Oracle

    Cannot find anything more recent of the same weight/popularity...

    I don't think those sales translate to business...

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

    February 16, 2009 at 1:50 pm

    #944840

  • RE: SQL or Oracle

    Bruce W Cassidy (2/16/2009)

    gints.plivna (2/16/2009)

    At least on 2006 the business chose Oracle 😉

    Cannot find anything more recent of the same weight/popularity...

    [font="Verdana"]No surprises there. Well, hang on... Unix is...

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

    February 16, 2009 at 1:47 pm

    #944836

  • RE: SQL or Oracle

    gints.plivna (2/16/2009)

    Perry Whittle (2/16/2009)

    Jeff Moden (2/15/2009)

    Heh... that's one man's opinion. Anything that won't even allow for more than a 30 character object name certainly isn't the most flexible 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)

    February 16, 2009 at 1:46 pm

    #944834

  • RE: Building a view to get summary data from multiple tables

    Bruce W Cassidy (2/16/2009)

    [font="Verdana"]Doing a full outer join was a nightmare (union of left and right outer joins) and doing a full cartesian product, er, cross join, was far too...

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

    February 16, 2009 at 1:31 pm

    #944824

  • RE: SQL or Oracle

    Bruce W Cassidy (2/16/2009)

    But it's all about value to the business, not value to the programmer.

    I have yet to see a business judge an RDBMS on "which is easier 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)

    February 16, 2009 at 1:24 pm

    #944817

  • RE: Function - Check Count

    Loner was on the right track... but, considering your query, not sure it's worth taking the time... you'd have to check for performance. Here's what your query would look...

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

    February 16, 2009 at 1:05 pm

    #944806

Viewing 15 posts - 45,121 through 45,135 (of 59,095 total)