Forum Replies Created

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

  • RE: Few interview questions

    Heh... the point is that Interviewer's ask some of the darnedest questions to find out if you really know instead of just memorizing a list of "interview questions". 🙂

    --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 9:23 pm

    #883223

  • RE: Primary Key

    chintan kotwal (10/9/2008)

    Hello Everyone,

    I was reading an article, and in that article as one of the rules for the database architect being 'Every table has a Primary Key'.

    My question: Would...

    --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:53 pm

    #883216

  • RE: Job processing all views in DB

    Heh... I agree... this is what cursors are for...

    ...but then you'd have to admit to actually putting one in production. 😛

    In SQL Server 2005, there is absolutely no reason 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)

    October 9, 2008 at 8:44 pm

    #883214

  • RE: Need Help--Derived Tables???

    bharathi (10/9/2008)

    I found it myself...Thankss a lot anywayz...

    Two way street here... would you please post your solution? Thanks. 🙂

    --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:21 pm

    #883208

  • 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

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