Forum Replies Created

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

  • RE: Equivalent of Excel''''s NORMSINV function

    Rick, Thanks. I need to run this on a MS SQL server, so I did some translating, but can't get past a few things.

    Maybe you or someone else can help...

  • RE: Excel to SQL Table -DTS No duplicates

    Ended up going from Excel to a temp table, then using the "Select Where Not" statement from the temp table to the destination table. Could never seem to use the...

  • RE: Excel to SQL Table -DTS No duplicates

    Thanks for all of the input.

    I like this idea:

    INSERT INTO table

    (A, B)

    SELECT Excel.A, Excel.B

    FROM Excel

    WHERE NOT EXISTS

    (SELECT 1

    FROM table

    WHERE Excel.A = Table.A

    AND Excel.B = Table.B)

    But being a Newbie I am...

  • RE: 1 Publication several subscriptions

    I am using MERGE.

    Any hints on what I might be able to use besides hostname? Hostname might work, but I would like to find out what my options are.

    Thanks!

    ...

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