Forum Replies Created

Viewing 15 posts - 44,251 through 44,265 (of 59,101 total)

  • RE: How to make this stored procedure flexible?

    sku370870 (4/11/2009)

    Now, this all works - but it is effectively hard coded. What happens when someone adds Department 5 - or deletes Department 3.

    I want to write this in such...

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

    April 11, 2009 at 2:35 pm

    #976188

  • RE: How to make this stored procedure flexible?

    Florian Reischl (4/11/2009)

    Hi

    Try to handle it with a PIVOT operator.

    Greets

    Flo

    PS: Maybe have a look to the "Best Practices" link in my signature for posting sample data and DDL. This always...

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

    April 11, 2009 at 2:32 pm

    #976187

  • RE: Difrrence between two rows

    mister.magoo (4/11/2009)

    Jeff Moden (4/11/2009)

    Oh... be careful folks... this wonderful and great interplay of thoughts and ideas to come up with some absolutely outstanding code all share the same common fault......

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

    April 11, 2009 at 2:22 pm

    #976186

  • RE: Difrrence between two rows

    I missed one... there is one solution above that takes an IDENTITY column into consideration.

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

    April 11, 2009 at 2:20 pm

    #976185

  • RE: Difrrence between two rows

    Oh... be careful folks... this wonderful and great interplay of thoughts and ideas to come up with some absolutely outstanding code all share the same common fault... they all can...

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

    April 11, 2009 at 2:11 pm

    #976183

  • RE: Which is more efficient or does it matter?

    The answers about sargeable predicates have already been pretty well covered on this thread, so I'll not go there.

    Going back to the original question, the first code snippet uses correlated...

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

    April 11, 2009 at 1:55 pm

    #976180

  • RE: Use of GO

    arup_kc (4/9/2009)

    Why are we using GO statement? Generally SQL statements are executed sequentially, then why r we using GO?

    Here is a situatrion where without GO, its throwing an error.

    ALTER TABLE...

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

    April 11, 2009 at 1:47 pm

    #976179

  • RE: varchar to date distinct select

    Apologies for the large delay in responding...

    At this point, I'm not sure... guess I'd have to play with it. I'd probably clean all the data so that anything that...

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

    April 11, 2009 at 1:05 pm

    #976175

  • RE: How to return a "start of group" column?

    Sheng (4/7/2009)

    Jeff Moden (4/6/2009)

    Soooo.... does that mean you're happy now?

    ...... I can't follow you.:-) I just want to discuss if I've made a right decision about generating this column in...

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

    April 11, 2009 at 12:58 pm

    #976171

  • RE: Convert multiple rows into columns

    vishal.chawla (4/7/2009)

    Am not a sql expert and I used the excel 07 file as an attachment for sample data as it was one of the file type options. Am reattaching...

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

    April 11, 2009 at 12:51 pm

    #976170

  • RE: Just Walk Away - Blacklisting - and Twits without Twitter

    Jim Russell (4/8/2009)

    I'm not sure why I started reading this thread. As I did, I kept asking myself "Did I do that?", "Are they talking about me?"

    Don't you dare...

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

    April 11, 2009 at 12:28 pm

    #976162

  • RE: Manners

    Lynn Pettis (4/7/2009)

    Jeff Moden (4/7/2009)

    Only they don't get to come back after calming down.

    BWA-HAA!!! That's not a fault... that's a feature. 😛

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

    April 11, 2009 at 12:20 pm

    #976159

  • RE: How to display number of rows in each table in database

    mosaic (4/9/2009)

    quick and dirty - but handy for ad-hoc use:

    Set query output to text

    sp_MSforeachtable @command1=" SELECT '?', COUNT(*) FROM ?"

    Um... maybe. If you have tables like what are...

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

    April 11, 2009 at 12:11 pm

    #976155

  • RE: The T-SQL Paradigm

    Sorry... I forgot... here's the code I used for the INT truncation which is the fastest method for truncating a date that I know of.

    CREATE FUNCTION dbo.jbmTrunc

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

    April 11, 2009 at 11:46 am

    #976146

  • RE: The T-SQL Paradigm

    andrew gothard (4/11/2009)

    Bit of a typing error there - meant to write "I always". Now you know my issues with more typing than required. True - what 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)

    April 11, 2009 at 11:41 am

    #976142

Viewing 15 posts - 44,251 through 44,265 (of 59,101 total)