Forum Replies Created

Viewing 15 posts - 38,716 through 38,730 (of 59,072 total)

  • RE: Using OPENROWSET to import CSV files

    ColdCoffee (4/24/2010)

    I am also quite interested in GSquared's import to temp table solution, i will give a shot at this in some time!

    BWAA-HAA!!! Try it on the Sample2.CSV file...

    --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 24, 2010 at 3:42 pm

    #1157341

  • RE: CROSS TAB Query Question.

    keyun (4/24/2010)

    Imu92 & Rob,

    Here is my sample code where i found out how to do cross tab by using 92's suggestion on RoW_NUMBER() function.

    DROP TABLE ##TBL1

    CREATE TABLE ##TBL1

    (Accountvarchar(20),

    Prod_codenumeric(18,0),

    AmountMoney

    )

    INSERT INTO...

    --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 24, 2010 at 2:49 pm

    #1157339

  • RE: Is there a function which determines if a varchar is a number?

    Edward-445599 (11/3/2008)

    Hi is there a function which determines if a varchar is a number?

    E.g.

    Select * from table where filed <> to a number

    Let's ask a question here... is 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)

    April 24, 2010 at 2:42 pm

    #1157338

  • RE: Financial Data in the Cloud?

    I equate "Cloud Storage" to child care... who in their right mind would give their kids to someone they've never met and send them to a place they don't 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)

    April 24, 2010 at 2:34 pm

    #1157337

  • RE: Minimal Meetings

    Heh... supposed time wasted in meetings is the least of my worries. A bazillion emails and IM's are a total waste of time compared to the productive time 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)

    April 24, 2010 at 1:58 pm

    #1157334

  • RE: Converting to DateTime

    I'd like to know why we're using SQL Server to format anything. This stuff should be done in a GUI if you have one and most reporting software qualifies.

    --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 24, 2010 at 1:48 pm

    #1157330

  • RE: Speed improvement help needed for large xml queries

    BWAA-HAA!!!!... you're talking to the wrong guy about XML. There's not much in my life that I take the time to hate but I hate XML. It's hierarchical...

    --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 24, 2010 at 1:43 pm

    #1157329

  • RE: Which one is faster and best

    vidya_pande (4/24/2010)

    run

    DBCC FREEPROCCACHE

    and

    DBCC DROPCLEANBUFFERS

    while running the queries again to test the performance. This will make sure you are comparing perfoamnce with correct values

    I'm not sure I'd do either 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)

    April 24, 2010 at 1:18 pm

    #1157325

  • RE: Trigger For Delete - Multiple Row Value

    shen-dest (4/21/2010)

    hi,

    you may use cursor to get all values deleted.

    Heh... that'll probably get you fired because of how slow it is. It's also really, really bad advice. One...

    --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 24, 2010 at 1:13 pm

    #1157324

  • RE: Quick question about len

    Bhuvnesh (4/24/2010)

    Jeff Moden (4/23/2010)

    Bhuvnesh (4/23/2010)

    Also check ANSI_NULL and ANSI_PADDING settings on both databases ?

    Spot on.

    Jeff , i didnt get you here ? did i suggest wrong workaround ?

    No... "Spot...

    --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 24, 2010 at 12:49 pm

    #1157317

  • RE: SQL Query Question on Union All

    Bhuvnesh (4/24/2010)

    Jeff Moden (4/23/2010)

    Also, is there a chance that WWW and WWW1 are actually views.

    Why do you think that it could be view ? because of "Select * "...

    --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 24, 2010 at 12:46 pm

    #1157312

  • RE: MCJ - The Missing Link

    WayneS (4/24/2010)

    Jeff, I agree that it is implicitly covered. However, I agree with Lynn that it needs to be explicitly stated. Perhaps as I amended above?

    Cool... let's add a thousand...

    --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 24, 2010 at 12:39 pm

    #1157309

  • RE: MCJ - The Missing Link

    Lynn Pettis (4/23/2010)

    Jeff Moden (4/23/2010)

    [font="Arial Black"]The Oath and Pledges of the ______________[/font] (insert the correct name of the certification. For example, if the name of the certification is indeed...

    --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 24, 2010 at 9:46 am

    #1157278

  • RE: Speed improvement help needed for large xml queries

    lmu92 (4/24/2010)

    Jeff Moden (4/23/2010)

    ...

    I agree. IMHO, storing raw XML is as bad or worse than storing CSV's. Both are denormalized... both require special handling... neither can be optimized.

    I...

    --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 24, 2010 at 9:38 am

    #1157274

  • RE: Don't I need a TRY..CATCH block in the stored proc?

    Barkingdog (4/24/2010)

    Jeff,

    You wrote "Actually, you don't need TRY/CATCH for any of that. Take it out of the above query and see what happens." I tried that and found that, indeed,...

    --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 24, 2010 at 9:19 am

    #1157269

Viewing 15 posts - 38,716 through 38,730 (of 59,072 total)