Forum Replies Created

Viewing 15 posts - 2,371 through 2,385 (of 2,838 total)

  • RE: Daylight Savings Time

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

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    November 1, 2010 at 2:31 pm

    #1245077

  • RE: Daylight Savings Time

    george sibbald (11/1/2010)

    Stefan Krzywicki (11/1/2010)

    Thank you both for the helpful information. Now I can go on vacation this weekend without worrying. : -)

    George, where are you that you've already had...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    November 1, 2010 at 2:30 pm

    #1245076

  • RE: Are the posted questions getting worse?

    WayneS (11/1/2010)

    Stefan Krzywicki (11/1/2010)

    I was torn about whether to post this question here or in the forums, but settled on the forums because it might help other people too. Still,...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    November 1, 2010 at 2:30 pm

    #1245075

  • RE: Daylight Savings Time

    jcrawf02 (11/1/2010)

    Tom.Thomson (11/1/2010)

    There could be a similar interesting question about the other daylight saving time shift shift (in 6 months time). Will jobs scheduled to start between 0200 and...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    November 1, 2010 at 12:48 pm

    #1245014

  • RE: Daylight Savings Time

    Alvin Ramard (11/1/2010)

    Stefan Krzywicki (11/1/2010)

    Thank you both for the helpful information. Now I can go on vacation this weekend without worrying. : -)

    George, where are you that you've already had...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    November 1, 2010 at 12:34 pm

    #1245004

  • RE: Daylight Savings Time

    Thank you both for the helpful information. Now I can go on vacation this weekend without worrying. : -)

    George, where are you that you've already had daylight savings?

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    November 1, 2010 at 12:12 pm

    #1244989

  • RE: Are the posted questions getting worse?

    I was torn about whether to post this question here or in the forums, but settled on the forums because it might help other people too. Still, it is a...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    November 1, 2010 at 11:31 am

    #1244957

  • RE: SQL Server 2008 Setup Hangs

    Have you had any previous versions of SQL Server installed on this machine that have since been removed?

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    November 1, 2010 at 11:02 am

    #1244943

  • RE: Are the posted questions getting worse?

    Thanks for all the work Gail, that's a lot of help you've provided.

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    November 1, 2010 at 8:31 am

    #1244851

  • RE: Table Value Function

    mbender (10/29/2010)

    Ya i guess i really don't know the difference between a temp table and a variable table. I like using Variable Tables cause they are like a scratch...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    October 29, 2010 at 12:00 pm

    #1244370

  • RE: Table Value Function

    Lynn Pettis (10/29/2010)

    I really think that the code can be much simpler. I'll wai for the OP to post the DDL for the underlying tables, sample data, and expected...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    October 29, 2010 at 8:59 am

    #1244257

  • RE: Table Value Function

    I didn't have any data to run it against, but this is the kind of look you're shooting for.

    CREATE PROCEDURE YourProcedureName

    -- Add the parameters for the stored procedure here

    @MonthDate date

    @Office...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    October 29, 2010 at 8:19 am

    #1244223

  • RE: Table Value Function

    WayneS (10/28/2010)

    Stefan Krzywicki (10/28/2010)

    Roy Ernest (10/28/2010)

    I have couple of suggestions, but you have to take the first step on that. Put the Table structure here. We could help you with...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    October 28, 2010 at 7:52 pm

    #1243957

  • RE: Table Value Function

    Roy Ernest (10/28/2010)

    I have couple of suggestions, but you have to take the first step on that. Put the Table structure here. We could help you with the indexing.

    You also...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    October 28, 2010 at 7:38 pm

    #1243951

  • RE: Are the posted questions getting worse?

    Craig Farrell (10/28/2010)

    Think this would be a bit much as my signature?

    CREATE TRIGGER trg_Celko ON vw_SSC_PostList FOR AFTER INSERT

    AS

    -- Go read the documents, inline comments are for sissies.

    IF EXISTS (SELECT...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    October 28, 2010 at 6:07 pm

    #1243944

Viewing 15 posts - 2,371 through 2,385 (of 2,838 total)