Forum Replies Created

Viewing 3 posts - 16 through 18 (of 18 total)

  • RE: Comparison of Dates in SQL

    craig.lovegren (4/28/2009)

    rob.lobbe (4/28/2009)

    Not sure why dates cause so much trouble...

    declare

    @date datetime,

    @today datetime,

    @tonight datetime

    select

    @date = getdate(),

    @today = dateadd(dd,0,datediff(dd,0,@date)), 😉

    @tonight...

    April 28, 2009 at 5:21 pm

    #985576

  • RE: Comparison of Dates in SQL

    Not sure why dates cause so much trouble...

    declare

    @date datetime,

    @today datetime,

    @tonight datetime

    select

    @date = getdate(),

    @today = dateadd(dd,0,datediff(dd,0,@date)), 😉

    @tonight = dateadd(ms,-3,@today+1)...

    April 28, 2009 at 5:03 pm

    #985574

  • RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

    gautamsheth2000 (4/13/2009)

    Should use this code 🙂

    Select count(*) From master.sys.columns C1 CROSS JOIN master.sys.columns C2

    try

    select power(count(*),2) from master.sys.columns

    April 15, 2009 at 3:36 pm

    #978459

Viewing 3 posts - 16 through 18 (of 18 total)