Forum Replies Created

Viewing 15 posts - 1,306 through 1,320 (of 3,666 total)

  • RE: Are the posted questions getting worse?

    Jack Corbett (11/2/2010)


    CirquedeSQLeil (11/2/2010)


    GilaMonster (11/2/2010)


    Grant Fritchey (11/2/2010)


    For those who don't know, several of our locals are up for an award at SQLServerPedia for blog posts done over the last year....



    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: Convert date to "YYYYMM" in ssis package

    chinni-652949 (11/2/2010)


    can we do all that in data convertion task

    I believe you should be able to. I do not have time to try it, but it should just be...



    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?

    Jeff Moden (11/2/2010)


    Roy Ernest (11/2/2010)


    Tail of Tropical Storm Tomas hit Curacao (My island) leaving 3 people dead, lots material damage, 280 mm of rain and lightning. We are expecting more...



    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: Daylight Savings Time

    Stefan Krzywicki (11/2/2010)


    Alvin Ramard (11/2/2010)


    You could have a procedure that runs on start-up and runs in a loop checking the execution of the jobs. I wouldn't recommend it, but...



    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: Daylight Savings Time

    You could have a procedure that runs on start-up and runs in a loop checking the execution of the jobs. I wouldn't recommend it, but it's an option.



    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: Convert date to "YYYYMM" in ssis package

    chinni-652949 (11/2/2010)


    Thank you.

    But how can I format in Data Conversion to YYYYMM.

    Take the year and month from the date; convert them to strings; pad them to the right length; then...



    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: Daylight Savings Time

    Stefan Krzywicki (11/2/2010)


    WayneS (11/2/2010)


    george sibbald (11/2/2010)


    I'd agree with tom here, I've never noticed a problem, clocks going back or forward, other than negative run times recorded in SQL2000. 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: Are the posted questions getting worse?

    Craig Farrell (11/2/2010)


    Brandie Tarvin (11/2/2010)


    GilaMonster (11/2/2010)


    WayneS (11/2/2010)


    Date field stored as varchar(8000) - what kinds of problems do you see coming up from this OP?

    8000 characters for a date? I could...



    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/2/2010)


    jcrawf02 (11/2/2010)


    Ha! This one is for Lynn and others who ref soccer - what NOT to do for the kickoff:

    http://runningahospital.blogspot.com/2010/10/sad-news-on-soccer-pitch.html

    It's also a good blog by the CEO of...



    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: Check Files existence in a folder

    Raunak Jhawar (11/2/2010)


    Think Big...Think Windows Service that will poll a directory implementing Windows Management Instrumentation Events..lol...

    Yes Phil FEL can be used but the ST has to invlove a suitable code...



    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 parameters validation

    Take a look at using expressions with precedence constraints.



    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?

    Grant Fritchey (11/2/2010)


    For those who don't know, several of our locals are up for an award at SQLServerPedia for blog posts done over the last year. Gail is in three...



    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?

    Chris Morris-439714 (11/2/2010)


    Gianluca earns Sainthood points here.

    I'll be the first to admit that I usually do not have that much patience.



    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: Election Day

    Nelson Williams-487553 (11/2/2010)


    So, are you going to vote today? You really should.

    No endorsements here. Just asking you to vote.

    No. I'm in the US, but I'm not a US citizen.



    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: Daylight Savings Time

    GSquared (11/2/2010)


    WayneS (11/1/2010)


    But... you could have a different problem.

    If your job is scheduled to run, say, every 15 minutes. When it runs @ 1:45 (the first time), it gets set...



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