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

    November 2, 2010 at 12:43 pm

    #1245653

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

    November 2, 2010 at 12:37 pm

    #1245647

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

    November 2, 2010 at 12:33 pm

    #1245641

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

    November 2, 2010 at 12:20 pm

    #1245626

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

    November 2, 2010 at 12:08 pm

    #1245620

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

    November 2, 2010 at 11:56 am

    #1245609

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

    November 2, 2010 at 11:53 am

    #1245606

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

    November 2, 2010 at 11:48 am

    #1245603

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

    November 2, 2010 at 10:34 am

    #1245531

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

    November 2, 2010 at 9:17 am

    #1245480

  • RE: SSIS parameters validation

    Take a look at using expressions with precedence constraints.

    November 2, 2010 at 9:13 am

    #1245477

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

    November 2, 2010 at 8:33 am

    #1245426

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

    November 2, 2010 at 8:24 am

    #1245419

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

    November 2, 2010 at 8:15 am

    #1245408

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

    November 2, 2010 at 8:02 am

    #1245387

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