Forum Replies Created

Viewing 15 posts - 38,836 through 38,850 (of 59,072 total)

  • RE: Converting a date

    Nabha (4/15/2010)

    I am guessing,

    wo.COMPLETEDTIME >= Convert(bigint, convert(timestamp, getdate()))

    and ofcourse

    wo.COMPLETEDTIME < Convert(bigint, convert(timestamp, getdate() + 1))

    Ummmm... I know it's just a guess, Nabha, but the TIMESTAMP data type has absolutely...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 18, 2010 at 10:32 pm

    #1153577

  • RE: The best way to add next month

    lmu92 (4/16/2010)

    The best way to deal with date values is to store it as date values.

    So, instead of having an integer value it woul be a lot better and easier...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 18, 2010 at 10:12 pm

    #1153573

  • RE: define composite primary key with more than 900 bytes

    I still can't believe that someone needs a 70 column primary key. Without actually understanding the table at hand, I believe that some normalization would be in order. 😉

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 18, 2010 at 10:00 pm

    #1153571

  • RE: dateDiff question

    SQL_NuB (4/14/2010)

    OK, I've been looking online and reading many articles on how to exclude weekends, however, most of the articles are assuming that your start date or end date begin...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 18, 2010 at 9:57 pm

    #1153568

  • RE: selecting column name dynamically

    I agree with Paul on this...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 18, 2010 at 9:50 pm

    #1153567

  • RE: Insert a text column from a flatfile into a Datetime Column in a Table

    Import it into your staging table as character based information and convert it when you transfer it to the final table.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 18, 2010 at 9:47 pm

    #1153566

  • RE: TSQL Lookup using BETWEEN (Ip Addresses)

    Actually, for anything bigger than 11K rows, I just use a CROSS JOIN on my trusty ol' Tally table because I KNOW how many rows that has. 😀

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 18, 2010 at 9:35 pm

    #1153563

  • RE: FizzBuzz

    As a glimmer of hope for the folks still running SQL Server 2000, the following doesn't cause any unnecessary log growth, either...

    DECLARE @max-2 INT

    SET @max-2 =...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 18, 2010 at 8:43 pm

    #1153552

  • RE: FizzBuzz

    With a bit of egg on my face (a whole omelette, actually), it would appear that IDENTITY is, in fact, the culprit and not the 3 way CROSS JOINs. ...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 18, 2010 at 7:14 pm

    #1153538

  • RE: FizzBuzz

    CirquedeSQLeil (4/18/2010)

    Stefan_G (4/18/2010)

    I used a triple cross join to create the results. I didn't post that query back when I did my testing. My recovery model was simple.

    Well, on my...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 18, 2010 at 6:48 pm

    #1153533

  • RE: FizzBuzz

    BWAA-HAAA.... I forgot to make room. 😛

    Msg 9002, Level 17, State 4, Line 3

    The transaction log for database 'TestLogGrowth' is full. To find out why space in the log cannot...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 18, 2010 at 5:43 pm

    #1153527

  • RE: FizzBuzz

    Stefan_G (4/18/2010)

    What is your recovery model ?

    Right now, I'm testing with the FULL recovery model. I'll follow that up with the SIMPLE model but most folks don't run SIMPLE...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 18, 2010 at 4:14 pm

    #1153517

  • RE: FizzBuzz

    First test is still running on my dedicated but old desktop after 52 minutes. Log file has grown to 34.5 gig and is still growing. Like I said,...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 18, 2010 at 3:43 pm

    #1153515

  • RE: Map IP Address to a Geographical Location

    sam-610757 (4/16/2010)

    I smoked for 20+ years. I have not had a cigarette in 2.5 years give or take. This is what it took for me to quit.

    I chewed the...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 18, 2010 at 3:41 pm

    #1153514

  • RE: Map IP Address to a Geographical Location

    stevefromOZ (4/18/2010)

    Off topic -

    Hey Jeff, head to Australia where they're contemplating $20 (!!!) a packet, am sure this could influence your behaviour 😉

    Heh... it sure would. I'd build...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    April 18, 2010 at 3:30 pm

    #1153513

Viewing 15 posts - 38,836 through 38,850 (of 59,072 total)