Forum Replies Created

Viewing 15 posts - 1,696 through 1,710 (of 3,666 total)

  • RE: SQL Database comparison

    Alvin Ramard (9/22/2010)


    Hold on.

    We don't know if the problem was caused by a trigger, a view, or anything else.

    We also don't know what problems might be caused by using a...



    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: No function FINDSTRING?

    DrStrangepork (9/22/2010)


    sorry, should have searched the forums before posting....

    The correct syntax for what I'm trying to accomplish:

    LEFT(esl.text,CHARINDEX('(',esl.text)-1) as Text

    WOW

    Your timing was something else. Happy you found the solution.



    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: No function FINDSTRING?

    The page you posted a reference to is for SSIS. Are you trying to use this in SSIS or T-SQL?

    If you're trying to do this in T-SQL then may...



    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?

    Ray K (9/22/2010)


    Alvin Ramard (9/22/2010)


    Jack Corbett (9/22/2010)


    jcrawf02 (9/22/2010)


    It is the only way I get any points, after all. Damn Hugo and his questions!

    😉

    [rant?]

    By the way, just read Tom LaRock's post,...



    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: SQL Database comparison

    Hold on.

    We don't know if the problem was caused by a trigger, a view, or anything else.

    We also don't know what problems might be caused by using a new table.

    Please,...



    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?

    Jack Corbett (9/22/2010)


    jcrawf02 (9/22/2010)


    It is the only way I get any points, after all. Damn Hugo and his questions!

    😉

    [rant?]

    By the way, just read Tom LaRock's post, am I the only...



    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 (9/22/2010)


    Alvin Ramard (9/22/2010)


    There was no attempt at any form of poetry.

    Records are read,

    Logs are backed up.

    Some poems rhymes,

    And some are messed up!

    😛

    I am seriously contemplating submitting a...



    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: SQL Database comparison

    doug 40899 (9/22/2010)


    Alvin,

    This was fixed by creating a new table called Newclients2 and having data inserted into that table. For whatever reason, when I tried doing this with the newclient...



    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: SuppressConfigurationWarnings property not working

    You might want to consider two (or more) configuration files per package. The first file would only contain what is common to all packages. The second file would be specific...



    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?

    jcrawf02 (9/22/2010)


    Alvin Ramard (9/22/2010)


    Why did I have to go down that path?

    Why am I not surprised at the answer?

    Why do I not feel like helping someone where they don't hire...



    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?

    Why did I have to go down that path?

    Why am I not surprised at the answer?

    Why do I not feel like helping someone where they don't hire qualified staff?

    Why do...



    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?

    Steve Jones - Editor (9/22/2010)


    CirquedeSQLeil (9/22/2010)


    I don't see any way Gail beats the thread to 20k unless the thread keels over.

    well of course not, not at the rate you people...



    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: SQL Database comparison

    Don't you have a DBA you could ask?



    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: What Do We Need in SQL Server?

    david_wendelken (9/22/2010)


    Alvin,

    I just noticed your photo and that you're in Memphis.

    You didn't go to college in Memphis circa 1975-82 did you?

    Because there was some guy that drove a nice car...



    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: SQL Database comparison

    Is msbtotal.dbo.newclients a view that references the members table?



    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 - 1,696 through 1,710 (of 3,666 total)