Forum Replies Created

Viewing 15 posts - 406 through 420 (of 3,666 total)

  • RE: Are the posted questions getting worse?

    Lynn Pettis (8/11/2015)


    Alvin Ramard (8/11/2015)


    WayneS (8/11/2015)


    Lynn Pettis (8/11/2015)


    What an attitude.

    Duly smacked

    It's actually the last variable, that's NULL. 😀

    I think we scared him off.

    WTF = Where's That Fellow ??? ...



    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?

    WayneS (8/11/2015)


    Lynn Pettis (8/11/2015)


    What an attitude.

    Duly smacked

    It's actually the last variable, that's NULL. 😀



    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: PRINT bug ?

    SQLRNNR (8/11/2015)


    Alvin Ramard (8/11/2015)


    I thought he was just asking: "Wed, Thurs, Fri?" 😀

    No. It means "Where's The Fire?"

    Well, That's Fine.



    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: PRINT bug ?

    I thought he was just asking: "Wed, Thurs, Fri?" 😀



    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: PRINT bug ?

    Eirikur Eiriksson (8/11/2015)


    mar.ko (8/11/2015)


    WHILE @@FETCH_STATUS = 0

    BEGIN

    FETCH NEXT FROM C_tables INTO

    @ColName

    ,@ColOrdPosit

    ,@TabSchema

    ,@TabName

    ,@ColDataType

    ,@ColDefaultVal

    ;

    PRINT @ColName + ' ' +STR(@ColOrdPosit) + ' ' +@TabSchema + ' ' +@TabName + ' ' +...



    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: error after case when statement

    te_<3 (8/11/2015)


    OMG, that's it, I had an extra 'else'?

    thank you thank you thank you thank you thank you thank you thank you thank you thank you

    You're welcome.

    Extra Else and...



    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: SSIS Job Fails for No Reason

    Eirikur Eiriksson (8/11/2015)


    Michelle-138172 (8/11/2015)


    I have a job that runs an SSIS package. The job seems to be able to run through the package successfully, but at the end it errors...



    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: error after case when statement

    te_<3 (8/11/2015)


    I've tried a few variations of this, but the error is when I start my from statement: i.e.

    this is my last line of my select statement, tried ending the...



    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: SSIS Job Fails for No Reason

    Michelle-138172 (8/11/2015)


    I have a job that runs an SSIS package. The job seems to be able to run through the package successfully, but at the end it errors out saying...



    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: SSIS Job Fails for No Reason

    Please stop posting the same question multiple times.



    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?

    SQLRNNR (8/11/2015)


    Just curious if anybody knows what a "SPAM DIG" happens to be? Is that like a clam dig?

    ... got me thinking (I know, scary!) ...

    Not sure I'll eat...



    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?

    SQLRNNR (8/11/2015)


    Eirikur Eiriksson (8/11/2015)


    Steve Jones - SSC Editor (8/11/2015)


    Ahh, 50,000 posts. Off doing real work and missed it. Amazing. Lots of forums don't have 50,000 posts in total.

    Would have been...



    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: Restricting Sysadmins from adding new sysadmins

    Steve Jones - SSC Editor (8/11/2015)


    Jeff Moden (8/11/2015)


    Despicable types that are inhouse might like to cover their tracks by altering logs. External hackers might also try if they got...



    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?

    andrew gothard (8/11/2015)


    Jack Corbett (8/10/2015)


    Steve Jones - SSC Editor (8/10/2015)


    Query query, sql sql, should we debate tomatoes and potatoes as well?

    How about "daytah" vs. "dahtah"?

    I thought Patrick Steward...



    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: Archiving Data Script

    Lynn Pettis (8/11/2015)


    Personally, I'd start with something like this and modify it as needed:

    declare @BatchSize int = 5000, -- change as desired

    @ArchiveDate...



    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 - 406 through 420 (of 3,666 total)