Forum Replies Created

Viewing 15 posts - 41,236 through 41,250 (of 59,069 total)

  • RE: Exporting Data from SQL Server

    Jeff Moden (11/6/2009)

    Bridget Elise Nelson (11/6/2009)

    Thanks. That sounds like a very good idea. I will be trying that.:-)

    Thanks for the feedback... If you have the time, please let us know...

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

    November 6, 2009 at 9:32 pm

    #1076225

  • RE: Exporting Data from SQL Server

    lmu92 (11/6/2009)

    Button (im)pressed. Nice one, Jeff!

    I thought there was an easy solution out there...

    Thanks Lutz. I love the "old" ways... so simple... 😀

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

    November 6, 2009 at 9:24 pm

    #1076224

  • RE: Exporting Data from SQL Server

    Bridget Elise Nelson (11/6/2009)

    Thanks. That sounds like a very good idea. I will be trying that.:-)

    Thanks for the feedback... If you have the time, please let us know how 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)

    November 6, 2009 at 9:21 pm

    #1076222

  • RE: Using OPENROWSET to import CSV files

    Simon Parry (11/6/2009)

    Hi

    i have tried using BULK INSERT

    using

    set @string ='BULK INSERT CSVTest FROM ''\\10.1.2.107\rp_uploaded_files\'+@file+''' WITH (FIELDTERMINATOR = '','',ROWTERMINATOR = '''')'

    exec (@string)

    but this requires the destintation table to have 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)

    November 6, 2009 at 9:18 pm

    #1076221

  • RE: Inspiring Change

    laurav (11/6/2009)

    I could not disagree more. I work with plenty of brilliant women who fall under the "genius" category. And I don't think the men "choose" who will...

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

    November 6, 2009 at 9:10 pm

    #1076220

  • RE: Inspiring Change

    Bob Hoffman-209065 (11/6/2009)

    Oh Steve, I think you need to come off the farm for a while and get reacquainted with life in the city. It's not an empolyee favored...

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

    November 6, 2009 at 9:04 pm

    #1076217

  • RE: Import data from csv file

    Dr.D (11/6/2009)

    It is not about a job interview nor university final exam nor homework. This is my task at work and i have 3 days to finish it. Yesterday was...

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

    November 6, 2009 at 8:48 pm

    #1076216

  • RE: Money vs. Decimal Data type

    repent_kog_is_near (11/4/2009)

    Hi

    Float always gives the result of the calculator. That is why I assumed that Float will always be accurate. Can you give an example when Decimal gives...

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

    November 6, 2009 at 8:45 pm

    #1076214

  • RE: Looping through a directory for sub-directories' names

    ktlady (11/6/2009)

    Is there any way to do the sub-directory search inside SSIS package without having to involve database? Thanks!

    Probably, but I don't know because I don't use SSIS. I've...

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

    November 6, 2009 at 8:34 pm

    #1076213

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (11/6/2009)

    Luke L (11/6/2009)

    jcrawf02 (11/6/2009)

    So then we've finally found a definitive benefit of RBAR - environment control

    Jeff's gonna be pissed...

    Though I suppose if you get it to raise the temps...

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

    November 6, 2009 at 8:28 pm

    #1076211

  • RE: Running Totals

    Lynn Pettis (11/6/2009)

    First, watch SSC for Jeff's rewritten article on Running Totals. IIRC, it is coming out on 11/10/2009. It will be extremely enlightening.

    With that, here is 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)

    November 6, 2009 at 4:41 pm

    #1076184

  • RE: Running Totals

    wizard5203 (11/6/2009)

    Jeff, thanks for the reply. You could tell from the post I'm a newbie. I looked at your link and will follow it on the next post. Thanks again.

    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)

    November 6, 2009 at 4:17 pm

    #1076175

  • RE: Running Totals

    Lynn Pettis (11/6/2009)

    Jeff Moden (11/6/2009)

    ...

    What? No comments on the sample code I provided? I really thought you'd have more to add. 😉

    I'm not done posting on...

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

    November 6, 2009 at 4:16 pm

    #1076174

  • RE: Running Totals

    aravind.s (11/5/2009)

    Hi.

    Try this

    Select a.col1,a.col2,(select sum(hrs) from table where emp_id <=a.emp_id) ‘col3’

    From table a

    assuming empid is your key to the table and You want the running total of HRS column.

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

    November 6, 2009 at 4:04 pm

    #1076170

  • RE: Sum(ISNULL(GSTExclusiveAmt,0))

    Ummm... looking up the two functions in Books Online is certainly the way to go folks, but stop and think about WHY someone wrote the code like that. SUM...

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

    November 5, 2009 at 10:12 pm

    #1075713

Viewing 15 posts - 41,236 through 41,250 (of 59,069 total)