Forum Replies Created

Viewing 15 posts - 331 through 345 (of 7,168 total)

  • RE: SSIS Bulk Insert doesn't load last line of data

    You had an extra column in Flat File Connection Manager "HREXPORTTest Flat File" named Column38 that did not seem to belong there. I went into it and "Reset Columns" and...

    February 2, 2016 at 8:30 am

    #1856003

  • RE: What is the True Version of Code?

    Andy Warren (2/2/2016)

    I'm interested in the why. I like source control, use it all the time for code. Why isn't it used as naturally/often for the database? Is it really...

    February 2, 2016 at 8:15 am

    #1855996

  • RE: What is the True Version of Code?

    In principle I agree with everyrhing you said. In particular this:

    Whether anything has eroded my confidence or not, I just believe in making sure. Every time.

    and this, ideally are constants...

    February 2, 2016 at 1:42 am

    #1855924

  • RE: Pulling multiple record values as a single value

    tarr94 (2/1/2016)

    I'm trying to identify the best way to retrieve the values from the MyValue column as a single, comma-delimited value. How can this be done through SQL Server?

    It...

    February 1, 2016 at 10:17 pm

    #1855905

  • RE: Need to sum up a team's win totals in last 5 games

    If you would post CREATE TABLE, INSERT statements and your desired results based on the test data you will have a much better chance of getting a working solution meets...

    February 1, 2016 at 9:58 pm

    #1855903

  • RE: What is the True Version of Code?

    Ed Wagner (2/1/2016)

    Concurrent development on multiple branches that have not been unified can't be called current. If you have an emergency code change, there's no way to consolidate everything...

    February 1, 2016 at 8:10 pm

    #1855894

  • RE: What is the True Version of Code?

    mister.magoo (2/1/2016)

    Before making changes to SQL objects, I'm in the habit of updating my dev VCS from production, then checking for any changes that may have "slipped" in before starting...

    February 1, 2016 at 5:36 pm

    #1855884

  • RE: GOTO statement on a script does not skip to the end

    jcarranza 23978 (2/1/2016)

    Thanks Orlando for your prompt input and for your recommendation in regards to using obsolete code.

    However, the error is the same.

    "The target database, 'PapersDB' (not the...

    February 1, 2016 at 4:55 pm

    #1855880

  • RE: What is the True Version of Code?

    I see roger.plowman as an idealist and Phil as a pragmatist in this debate...both of you are right and you both believe in using a VCS to store the Gold...

    February 1, 2016 at 4:42 pm

    #1855877

  • RE: GOTO statement on a script does not skip to the end

    jcarranza 23978 (2/1/2016)

    I have the following script on an AlwaysON High Availability Group. I am trying to run a set of statements on the Primary Node only but not on...

    February 1, 2016 at 4:15 pm

    #1855875

  • RE: SSIS Bulk Insert doesn't load last line of data

    Melanie Peterson (2/1/2016)

    Ah hah. I edit attachments. Here is my masterwork. Thank you for your help, both past and future. 🙂

    I need a table definition for dayforce.EmployeeInformation.

    February 1, 2016 at 4:09 pm

    #1855874

  • RE: Servername along with SP

    Steve Jones - SSC Editor (2/1/2016)

    I don't think you can do this in a single statement. I might be wrong, but I suspect you could drop the results into a...

    February 1, 2016 at 4:05 pm

    #1855873

  • RE: Need help related to index

    Hugo Kornelis (2/1/2016)

    Orlando Colamatteo (2/1/2016)

    sqlinterset (2/1/2016)

    I have a transnational table which every time dropped and created in a job to get updated data.

    Earlier there was no index, but now one...

    February 1, 2016 at 3:42 pm

    #1855869

  • RE: Need help related to index

    Ed Wagner (2/1/2016)

    Orlando Colamatteo (2/1/2016)

    As an aside, it is a best practice in SQL Server for all tables to have a clustered index and a primary key. Any reason why...

    February 1, 2016 at 3:01 pm

    #1855853

  • RE: Servername along with SP

    sqlnewbie17 (2/1/2016)

    Yes,that will be run against multiple servers as part of an SSIS package.

    Thanks

    Doing this in T-SQL will be a pain. Easier way will be to use a Derived Column...

    February 1, 2016 at 2:44 pm

    #1855842

Viewing 15 posts - 331 through 345 (of 7,168 total)