Forum Replies Created

Viewing 15 posts - 166 through 180 (of 3,666 total)

  • RE: Are We Engineers?

    GilaMonster (12/10/2015)


    No, we're not. We don't have the rigour, the formality, the adherence to standards that characterises engineering disciplines. The scientific method is not 'try stuff at random until something...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Connection String Parent to Child Packages

    sharepointfarmer (12/8/2015)


    Will this work in SQL Server 2008? I searched and it seems like the parameter binding functionality is there only form 2012 and above.

    SQL 2008 is a bit different....



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Connection String Parent to Child Packages

    Create a parameter in each of the child packages for the connection string. When the master package calls the child packages, have it pass the connection string to the parameter...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Strange SSIS problem - could use a little help

    Is this an old package that used to work or a new one that has not worked yet?

    When a package works correctly when run manually, but doesn't work correctly when...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: writing queries that easily readable

    ; is a statement terminator. It belongs at the end of a statement, not the beginning!



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: writing queries that easily readable

    Luis Cazares (12/2/2015)


    GilaMonster (12/2/2015)


    We can compensate for badly written code with more badly written code. Excellent plan.

    Correctly terminate all statements with a semicolon (they're statement terminators). The end.

    If someone...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: writing queries that easily readable

    As I read this thread, I can't help but think about the question of the day, Fun with qualifiers.

    That's a good example of something to avoid. 🙂



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Import Excel to SQL Server

    demin99 (11/26/2015)


    Hi All,

    We have an excel file which changes every week.Weekly data will be added to each column in excel every week. I am trying to load the data to...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: How to get SISS package to load data from SQL 2014 to SQL 2005

    Phil Parkin (12/1/2015)


    It's not a scenario I've had to deal with. However, I would have expected it to run just fine, assuming you have the connection string to the new...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    GilaMonster (12/1/2015)


    Me: Execution plans please

    OP: You can use AdventureWorks2012

    Well, yes I could, if I had it installed on the machine that I'm currently using (which I don't). Or I can...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Creating Trigger

    Lynn Pettis (11/30/2015)


    Lynn Pettis (11/30/2015)


    Alvin Ramard (11/30/2015)


    Lynn Pettis (11/30/2015)


    Pulling hen's teeth, but based on what little detail you have been willing to provide, does the following help?

    create table dbo.FirstTable(

    ...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: How to get SISS package to load data from SQL 2014 to SQL 2005

    What is the version of the server you are trying to run the package on? Is this the same server as before the upgrade?

    If the package is a SQL 2005...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Creating Trigger

    Lynn Pettis (11/30/2015)


    Alvin Ramard (11/30/2015)


    Lynn Pettis (11/30/2015)


    Pulling hen's teeth, but based on what little detail you have been willing to provide, does the following help?

    create table dbo.FirstTable(

    ...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Creating Trigger

    Lynn Pettis (11/30/2015)


    Pulling hen's teeth, but based on what little detail you have been willing to provide, does the following help?

    create table dbo.FirstTable(

    ColA int,

    ...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    Lynn Pettis (11/30/2015)


    Alvin Ramard (11/30/2015)


    Sean Lange (11/30/2015)


    Eirikur Eiriksson (11/30/2015)


    Announcing the front runner for the Crystal Ball Award nomination 2015

    😎

    NOTE: Please support your favourite CBA by NOT answering the missing questions:-D

    Yeah...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Viewing 15 posts - 166 through 180 (of 3,666 total)