Forum Replies Created

Viewing 15 posts - 2,341 through 2,355 (of 3,666 total)

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (3/15/2010)


    Alvin Ramard (3/15/2010)


    CirquedeSQLeil (3/15/2010)


    Lynn only needs 4 more posts for 10,000 posts (not overall pts).

    CountDown on?

    Got the tent ready for the party? D'you sweep out all the hippo...

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (3/15/2010)


    Lynn only needs 4 more posts for 10,000 posts (not overall pts).

    CountDown on?

    Got the tent ready for the party? D'you sweep out all the hippo droppings?

  • RE: Are the posted questions getting worse?

    You know ..... If the right "outsider" read the Thread, some of us might end up with free room and board for the rest of our lives, wall padding included....

  • RE: Are the posted questions getting worse?

    Timewarp may be broken. I tried to use it last night to rewind the weekend and I could not get it to work. 🙁

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (3/15/2010)


    I'm with Alvin. Wary of overloads on dates. Especially with potential calendar issues across time zones. I prefer using the functions that explicitly call for the...

  • RE: Are the posted questions getting worse?

    Lynn Pettis (3/15/2010)


    Alvin Ramard (3/15/2010)


    Lynn Pettis (3/15/2010)


    Alvin Ramard (3/15/2010)


    CirquedeSQLeil (3/15/2010)


    Lynn Pettis (3/15/2010)


    Alvin Ramard (3/15/2010)


    Anybody else see a problem with this statement?

    DECLARE @selectDate = getdate()-365

    Yes, in SQL Server 2008 it is...

  • RE: Are the posted questions getting worse?

    Lynn Pettis (3/15/2010)


    Alvin Ramard (3/15/2010)


    CirquedeSQLeil (3/15/2010)


    Lynn Pettis (3/15/2010)


    Alvin Ramard (3/15/2010)


    Anybody else see a problem with this statement?

    DECLARE @selectDate = getdate()-365

    Yes, in SQL Server 2008 it is missing the data type....

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (3/15/2010)


    Lynn Pettis (3/15/2010)


    Alvin Ramard (3/15/2010)


    Anybody else see a problem with this statement?

    DECLARE @selectDate = getdate()-365

    Yes, in SQL Server 2008 it is missing the data type. Should be:

    DECLARE @selectDate...

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (3/15/2010)


    Alvin Ramard (3/15/2010)


    Anybody else see a problem with this statement?

    DECLARE @selectDate = getdate()-365

    Yup

    The expression getdate()-365 was used in a few places in today's denormalization article. Now it's showing...

  • RE: Are the posted questions getting worse?

    Anybody else see a problem with this statement?

    DECLARE @selectDate = getdate()-365

  • RE: Are the posted questions getting worse?

    Lynn Pettis (3/15/2010)


    GilaMonster (3/15/2010)


    Lynn Pettis (3/15/2010)


    Grant Fritchey (3/15/2010)


    Lynn Pettis (3/15/2010)


    Grant Fritchey (3/15/2010)


    GSquared (3/15/2010)


    Grant Fritchey (3/15/2010)


    Oh cool, tossed under another bus. Thanks Alvin.

    What year? (My birthday was yesterday, so I'm...

  • RE: Are the posted questions getting worse?

    Grant Fritchey (3/15/2010)


    Lynn Pettis (3/15/2010)


    Grant Fritchey (3/15/2010)


    GSquared (3/15/2010)


    Grant Fritchey (3/15/2010)


    Oh cool, tossed under another bus. Thanks Alvin.

    What year? (My birthday was yesterday, so I'm curious as to what the...

  • RE: Are the posted questions getting worse?

    Grant Fritchey (3/15/2010)


    GSquared (3/15/2010)


    Grant Fritchey (3/15/2010)


    Oh cool, tossed under another bus. Thanks Alvin.

    What year? (My birthday was yesterday, so I'm curious as to what the actual age difference is.)...

  • RE: Are the posted questions getting worse?

    GSquared (3/15/2010)


    Grant Fritchey (3/15/2010)


    Oh cool, tossed under another bus. Thanks Alvin.

    What year? (My birthday was yesterday, so I'm curious as to what the actual age difference is.) If...

  • RE: Are the posted questions getting worse?

    Grant Fritchey (3/15/2010)


    Oh cool, tossed under another bus. Thanks Alvin.

    You're welcome. 😛

Viewing 15 posts - 2,341 through 2,355 (of 3,666 total)