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 ??? ...

  • 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. 😀

  • 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.

  • RE: PRINT bug ?

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

  • 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 + ' ' +...

  • 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...

  • 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...

  • 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...

  • 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...

  • RE: SSIS Job Fails for No Reason

    Please stop posting the same question multiple times.

  • 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...

  • 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...

  • 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...

  • 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...

  • 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...

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