Forum Replies Created

Viewing 15 posts - 436 through 450 (of 7,164 total)

  • RE: Performance & uniqueness

    salardx (1/21/2016)

    Thank you Hugo Kornelis and Grant Fritchey

    Based on your responses I think I found what I need to do to overcome this problem

    You've been given some great guidance from...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 21, 2016 at 6:34 am

    #1853462

  • RE: Update with Lock

    Can you rephrase your post please? It looks like some info did not make it into the post and the wording is not clear as to what you're experiencing or...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 21, 2016 at 6:31 am

    #1853461

  • RE: Is there a way of listing Access only as a database on a resume?

    Depends on what kind of position youre looking for. If youre getting calls for Access Programmer positions (eg Forms and Reports dev) and you are not interested in that then...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 21, 2016 at 6:27 am

    #1853460

  • RE: Split row data to multiple columns

    As an aside, do you control the design of these tables? Typically it is not a good practice to store delimited strings in your database. What kind of data is...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 21, 2016 at 6:22 am

    #1853456

  • RE: Split row data to multiple columns

    What have you tried so far? You could lookup the functions CHARINDEX and SUBSTRING in Books Online to get started towards a solution.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 21, 2016 at 5:51 am

    #1853445

  • RE: Reading an Excel cell date value via an Execute SQL Task

    This thread comes up on Bing when searching for a way to capture the contents of a cell with a date in it and nowhere else I could find specifically...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 20, 2016 at 9:44 pm

    #1853356

  • RE: Retrieve specific cell value from Excel into SSIS variable

    murtzd (1/20/2016)

    File attached.

    I could not get this to work using a mapping to a scalar variable in the Execute SQL Task. It will work by pulling a Full Resultset and...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 20, 2016 at 9:05 pm

    #1853353

  • RE: Retrieve specific cell value from Excel into SSIS variable

    MMartin1 (1/20/2016)

    Just have to ask, you mentioned you tried all the data types in SSIS. I assume this includes the "double" type as well? I am surprised it would fail...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 20, 2016 at 12:54 pm

    #1853271

  • RE: Retrieve specific cell value from Excel into SSIS variable

    murtzd (1/20/2016)

    File attached.

    Thanks. I'll give it a spin later tonight.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 20, 2016 at 12:52 pm

    #1853269

  • RE: Need to calculate nth day of nth month

    ScottPletcher (1/20/2016)

    Holiday calendars are necessary -- there's not arithmetic calc to tell you which days are holidays in a given country.

    Actually, if memory serves, there are algorithms for calculating all...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 20, 2016 at 10:42 am

    #1853227

  • RE: Need to calculate nth day of nth month

    Ed Wagner (1/20/2016)

    Orlando Colamatteo (1/20/2016)

    ScottPletcher (1/20/2016)

    Orlando Colamatteo (1/19/2016)

    ScottPletcher (1/19/2016)

    Of course that code doesn't specify the date key, so it will do a full table scan. Again, vastly too much overhead...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 20, 2016 at 10:37 am

    #1853225

  • RE: Error Handling - Pass Error as variable

    ringovski (1/20/2016)

    There not duplicate until I run the update and remove the double quotes in the column.

    Yes, but you know the current state and desired end state.

    Check this out:

    USE tempdb;

    GO

    IF...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 20, 2016 at 9:59 am

    #1853207

  • RE: Need to calculate nth day of nth month

    ScottPletcher (1/20/2016)

    Orlando Colamatteo (1/19/2016)

    ScottPletcher (1/19/2016)

    Of course that code doesn't specify the date key, so it will do a full table scan. Again, vastly too much overhead when two very simple...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 20, 2016 at 7:50 am

    #1853145

  • RE: BCP from sql to flat file as JOB

    PSB (1/19/2016)

    We are doing a BCP because of the amount of rows to be fetched from Server 1 to Server 2 . The time shrinks to 2-3 minutes from 30...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 19, 2016 at 11:39 pm

    #1853037

  • RE: Konesans File Watcher and Trash Destination2008

    duplicate post

    http://www.sqlservercentral.com/Forums/Topic1753899-364-1.aspx#bm1754000

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 19, 2016 at 11:33 pm

    #1853036

Viewing 15 posts - 436 through 450 (of 7,164 total)