Forum Replies Created

Viewing 15 posts - 511 through 525 (of 2,452 total)

  • RE: Date Range overlaps

    Dreckly.

    wonder how many other people here know the meaning of that 😛

  • RE: Date Range overlaps

    sql restarted

    10 runs each

    comment ms

    CJM2 ...

  • RE: Date Range overlaps

    ChrisM@Work (7/11/2016)


    J Livingston SQL (7/11/2016)


    ChrisM@Work (7/11/2016)


    Assuming you're in a playpen, CHECKPOINT then dbcc dropcleanbuffers. You might free up a few kb 😀

    I'll tell you what I'll do Chris......as its only...

  • RE: Date Range overlaps

    ChrisM@Work (7/11/2016)


    Assuming you're in a playpen, CHECKPOINT then dbcc dropcleanbuffers. You might free up a few kb 😀

    I'll tell you what I'll do Chris......as its only a home laptop that...

  • RE: Date Range overlaps

    ChrisM@Work (7/11/2016)


    J Livingston SQL (7/11/2016)


    == CJM2 ==========================================================================

    Table 'testtable'. Scan count 9, logical reads 24440, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead...

  • RE: Date Range overlaps

    == CJM2 ==========================================================================

    Table 'testtable'. Scan count 9, logical reads 24440, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

    Table 'Worktable'. Scan...

  • RE: Date Range overlaps

    guess I am !!

    only 12 GB here

  • RE: Date Range overlaps

    It's quick G but not quite as quick as this, which uses no Black Magic at all:

    I dont get the same results Chris....any thoughts ??

    PRINT '== IBG =========================================================================='

    SET STATISTICS...

  • RE: Date Range overlaps

    ChrisM@Work (7/11/2016)


    Following on from this, I had a few hours to spare on Saturday morning to spend on JLS' test harness.

    IBG's first query looks like this:

    SELECT code, startdate AS...

  • RE: SQL Script: Create Inventory record for each day of the year

    Basically, I would like take these 10 records and create each item (inventory) or each day of the year.

    thanks for the sample data...appreciated....but I think that you now need to...

  • RE: SQL Script: Create Inventory record for each day of the year

    rjjh78 (7/9/2016)


    Hello,

    I am working on a database and would like to create a script that would auto-generate 1,2,3, or 5 years of data in one run.

    in answer to...

  • RE: Row Number With Repeated Numbers

    rootfixxxer (7/9/2016)


    Thanks

    Came from the 2005 version, and didnt know this functions...

    "every day is a school day " 🙂

    glad to be of help

  • RE: Need help to modify XML file using T-SQL

    durga.palepu (7/9/2016)


    How to do that pointing?

    seems like Jeff has already "wyafy" 😛

    Jeff Moden (7/9/2016)


    Duplicate post. Please, let's keep all the answers in one spot. Don't post on this...

  • RE: Row Number With Repeated Numbers

    rootfixxxer (7/9/2016)


    Hello

    The topic name it isn't the best, but it's what i need.

    So i have a list of times from a race, i need to order the athletes to show,...

Viewing 15 posts - 511 through 525 (of 2,452 total)