Forum Replies Created

Viewing 15 posts - 39,301 through 39,315 (of 59,072 total)

  • RE: Facing Problem With Bulk Insert

    steve-893342 (3/15/2010)

    Yes that's right Jeff, you wouldn't need a format file for BULK INSERT. It really depends how much flexibility you need. OPENROWSET BULK allows 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)

    March 15, 2010 at 7:15 pm

    #1134192

  • RE: Are the posted questions getting worse?

    Alvin Ramard (3/15/2010)

    You know ..... If the right "outsider" read the Thread, some of us might end up with free room and board for the rest of our lives, wall...

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

    March 15, 2010 at 7:00 pm

    #1134189

  • RE: Are the posted questions getting worse?

    Greg Edwards-268690 (3/15/2010)

    bitbucket-25253 (3/15/2010)

    Lynn Pettis (3/15/2010)

    Grant Fritchey (3/15/2010)

    Lynn Pettis (3/15/2010)

    Grant Fritchey (3/15/2010)

    GSquared (3/15/2010)

    Grant Fritchey (3/15/2010)

    Oh cool, tossed under another bus. Thanks Alvin.

    What year? (My birthday was yesterday, so I'm...

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

    March 15, 2010 at 6:54 pm

    #1134185

  • RE: Are the posted questions getting worse?

    Alvin Ramard (3/15/2010)

    CirquedeSQLeil (3/15/2010)

    Alvin Ramard (3/15/2010)

    CirquedeSQLeil (3/15/2010)

    Lynn only needs 4 more posts for 10,000 posts (not overall pts).

    CountDown on?

    Got the tent ready for the party? D'you sweep out all...

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

    March 15, 2010 at 6:52 pm

    #1134183

  • RE: Transposing repeating sets of rows into colums

    wiernyjacek (3/15/2010)

    These are fake names, so no private information is sent here. However I analysed the file again and it looks like the age is not always given, so 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)

    March 15, 2010 at 2:23 pm

    #1134062

  • RE: Facing Problem With Bulk Insert

    karthik -450760 (3/15/2010)

    Thanks for the reply Steve... The output file format vaires everytime. Please let me know if your code works for the below scenario that I face.. I have...

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

    March 15, 2010 at 2:20 pm

    #1134061

  • RE: Facing Problem With Bulk Insert

    steve-893342 (3/15/2010)

    Yes it should always work up to the first INSERT query viz

    INSERT #ConnectivityTest

    SELECT BulkColumn

    FROM OPENROWSET (

    BULK 'C:\ConnTest.txt',

    FORMATFILE = 'C:\grasshopper2.fmt',

    FIRSTROW = 1

    ) AS Z

    --WHERE NOT BulkColumn...

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

    March 15, 2010 at 2:16 pm

    #1134060

  • RE: Facing Problem With Bulk Insert

    steve-893342 (3/15/2010)

    Jeff makes the point about BULK INSERT being quite restrictive because you have to match up the column list and you cannot manipulate the individual columns very easily. OPENROWSET...

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

    March 15, 2010 at 7:14 am

    #1133678

  • RE: Duplicating a record within a table

    Paul White (3/14/2010)

    Jeff Moden (3/14/2010)

    Heh... user defined columns :sick:... that's the real problem. 😉

    True. I worked with an application once that shared a schema across all customers...and any customer...

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

    March 15, 2010 at 6:41 am

    #1133656

  • RE: select all field except field wich have NULL value

    Paul White (3/14/2010)

    sinamora (3/14/2010)

    thanks for all. it's very help me 🙂

    Looks like Jeff isn't getting his answer.

    Heh... Diodes, check valves, and one way streets are useful tools... just not 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)

    March 15, 2010 at 6:38 am

    #1133652

  • RE: If I increase the Memory allocated, Will the query run faster.?

    Joy Smith San (3/12/2010)

    I've found that when I had to use linked servers, OPENQUERY provided much faster results.

    It's amazing..! Open query is too fast...to be precise, it fetches data...

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

    March 15, 2010 at 6:31 am

    #1133643

  • RE: How to check if indexing is running?

    Ajit-297150 (3/15/2010)

    Ya it rebuild index. When we use the DBCC DBREINDEX 'tablename', it takes some time to rebuild it. And if in the mean time if a user queries 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)

    March 15, 2010 at 6:27 am

    #1133637

  • RE: please help me to develop this query

    madhuri-425013 (3/15/2010)

    Hi,

    Thanks for your suggestions. I am posting the output of the results which needs to come.

    my table contains below data

    tbl1

    -------

    name dt

    xxx 01-Apr-2010

    xyz 02-May-2010

    abc 01-Mar-2010

    results should come like below

    name dt

    xxx...

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

    March 15, 2010 at 6:14 am

    #1133627

  • RE: Normalization

    Kevin Butterworth (3/15/2010)

    That way the location could be used to return the gender, allowing compliance with California style legislation as it spreads around the world.

    Heh... Avoid needing to be compliant...

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

    March 15, 2010 at 6:01 am

    #1133611

  • RE: Stored Procedure Problem Help!

    Heh... you must really be bored, Paul. 🙂 It does show, however, what a PITA a Cursor is compared to the simple Set-Based methods.

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

    March 15, 2010 at 5:50 am

    #1133606

Viewing 15 posts - 39,301 through 39,315 (of 59,072 total)