Forum Replies Created

Viewing 7 posts - 1 through 7 (of 7 total)

  • RE: Batch or Mass Load Process

    P_DBA (11/19/2008)

    Hi,

    Yes this is the fastest way to load bulk data into the table. It works smoothly when both the target table and the input file has same number of...

    November 20, 2008 at 8:34 am

    #901092

  • RE: Batch or Mass Load Process

    Wow, thank you for this idea though I am wondering if this is the fastest and safest way to do mass loading of data from a text file? What if...

    November 19, 2008 at 9:26 pm

    #900861

  • RE: Help on Dups

    Christopher Stobbs (9/24/2008)

    Yeah it shouldn't be a problem to hard code that Column, cause looks like that Column and the Code Column will be the only two that you kow...

    September 24, 2008 at 4:17 am

    #876205

  • RE: Help on Dups

    Christopher Stobbs (9/23/2008)

    Are there any other cols in the table that might help with identifying the groupings?

    There are no other columns to determine groupings, another information though is that the...

    September 23, 2008 at 7:12 pm

    #876075

  • RE: Help on Dups

    Christopher Stobbs (9/23/2008)

    Ok at last I see what is need, now just to work it out 🙂

    Thank you Chris for the help.

    September 23, 2008 at 3:08 am

    #875499

  • RE: Help on Dups

    Hello Chris,

    Thanks for the response and help, I really appreciate it.

    Actually the code you supplied doesn't give me the correct output. The first example should output 10,11 while the second...

    September 23, 2008 at 2:41 am

    #875484

  • RE: Help on Dups

    Christopher Stobbs (9/22/2008)

    HI there

    Are you sure your outputs are correct?

    I'm a bit confused.

    thanks

    Chris

    Yes I am Sure with my output. If we're going to look at the first example:

    DECLARE @Table TABLE...

    September 22, 2008 at 8:28 pm

    #875379

Viewing 7 posts - 1 through 7 (of 7 total)