Forum Replies Created

Viewing 15 posts - 47,836 through 47,850 (of 59,095 total)

  • RE: add column between two column

    Sure you can do it. And, you don't have to write a lick of T-SQL to do it... Enterprise Manager will write all of the code for you.

    Open Enterprise...

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

    October 9, 2008 at 8:15 pm

    #883207

  • RE: tsql

    Ummm... cramming for an interview is a bad thing. If you don't know an answer for a question they ask, chances are you really don't know and reciting 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)

    October 9, 2008 at 7:49 pm

    #883202

  • RE: Converting rows into columns

    maynor_ramirez (10/9/2008)

    I need to pivot on some not all rows, I have search the sqlservercentral site for the answer but nothing yet..

    Thanks

    [url="Cross Tabs and Pivots, Part 1 – Converting Rows...

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

    October 9, 2008 at 7:35 pm

    #883199

  • RE: Select *

    That would grab /*__*/ if it's on the same line as some code of embedded within a statement.

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

    October 9, 2008 at 7:28 pm

    #883196

  • RE: Select *

    Vincent Central (10/9/2008)

    Who said developers have full access to production? Doing a select * only takes read access.

    Thank you all for your replies. I have "coached" the offending developers and...

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

    October 9, 2008 at 6:47 pm

    #883191

  • RE: Updating NULL Values

    cdex3 (10/9/2008)

    Thanks for the info!

    This is my first post so I apologize for any lack of etiquette.

    Your never too old or too young to learn new things and ideas.

    Heh......

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

    October 9, 2008 at 6:17 pm

    #883188

  • RE: Updating NULL Values

    Oh yeah... almost forgot... you can usually get away without using an Index "Hint", but like ORDER BY in a Select, it's always best to have one to force the...

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

    October 9, 2008 at 6:04 pm

    #883185

  • RE: Updating NULL Values

    That and you need a "anchor" column even if it doesn't do anything for the code... one that is just @variable = @column. Sometimes it works without one... don't...

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

    October 9, 2008 at 6:01 pm

    #883184

  • RE: Exclude Word List to filter SELECT results

    rbarryyoung (10/9/2008)

    Here's another (simple) way to do it:

    Select *

    From Locations

    Where NOT EXISTS( Select * From Excludes

    Where Location LIKE '%'+Excludes+'%')

    This is probably close to what Jeff intended to write,...

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

    October 9, 2008 at 5:58 pm

    #883183

  • RE: 'N' number of usage - Tally Table

    Sergiy (10/9/2008)

    Jeff Moden (10/9/2008)

    change all the delimiters to a "thorn" and go for it.

    There is no guarantee "thorn" is not or will not be used within the filed 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)

    October 9, 2008 at 5:56 pm

    #883182

  • RE: Data Shuffle

    Heh... I was hoping you had an IDENTITY PK... I won't have to make many changes to the script I just wrote above...

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

    October 9, 2008 at 5:54 pm

    #883181

  • RE: Table Variables and performance

    Michael Earl (10/8/2008)

    While it is running, look for tables in tempdb:

    SELECT * FROM TempDB..Sysobjects WHERE Type = 'u'

    A table variable usually has to get pretty big before it spills over...

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

    October 9, 2008 at 4:27 pm

    #883168

  • RE: Table Variables and performance

    G Bryant McClellan (10/8/2008)

    Michael,

    Thanks for the reply. I can see that testing is the only sure-fire method to compare the performance, but there must be some indication that the switch...

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

    October 9, 2008 at 4:26 pm

    #883167

  • RE: 'N' number of usage - Tally Table

    Dang it... I forgot about RegEx. That might work... change all the delimiters to a "thorn" and go for 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)

    October 9, 2008 at 1:15 pm

    #883113

  • RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

    riga1966 (10/9/2008)

    I have a very clear understanding of how to do a Cross-Tab now.

    How about Uncross-Tab?

    Does anyone have any samples?

    Thanks,

    Heh... that's called either "UnPivot" or "Normalizing". You could probably...

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

    October 9, 2008 at 1:12 pm

    #883112

Viewing 15 posts - 47,836 through 47,850 (of 59,095 total)