The query finished - 2 hours 41 minutes and 53 seconds.

Table 'TicketFollowup'. Scan count 157439, logical reads 503584, physical reads 168, read-ahead reads 5, lob logical reads 0, lob physical...

I decided to leave the long running query running - it has now got to 1 hour + 30 minutes and is still running.

Chris

I dobt that this is the best way to do this but it is one way - you would not generate the period table dynamically as each period should be...

Thanks for the link...

The code project that was mentioned in the thread has given me some ideas - so I appreciate that.

The link for...

Hi

Thanks for the info on the FME SQL Server Loader Edition - but I...

I think you are on the wrong track there.

I am trying to convert a GIS SHAPE FILE to SQL SERVER Data.

Saying I should watch a SSIS video on sorting...

Anything more specific than this?

Is there some specific object I can use? Can you point me to an article online?

chris

I killed your last one scott after 14 minutes.

Just to be sure I ran the original one again from Mark-101232

WITH CTE1 AS (

SELECT Name ,Price ,DateTime,

...

I gave your new version a go Scott and I killed it after 40 minutes.

Chris

Hi Scott

I tried your code and got a few issues if I sort by Name, MinDate as can be seen below.

The first row the next Date Time is actually after...

Hi again

I just wanted to let you know that I put the query I liked the most in this thread into a blog post.

http://blog.crowe.co.nz/blog/archive/2010/06/22/SQL-Server--TSQL-Return-startend-price-and-startend-date.aspx

The reason was that I appreciated the...

Thanks Eugene Elutin

I will check the missing index and look over the TSQL all of you have provided.

It is an idea I need to get better at

cheers

chris

I made a small mistake on my test results in that I said that the first result from was "Bhuvnesh's" but it was in fact from "Cold Coffee"

I did not...

Hi All,

I have looked at your solutions and tried them against my data and here are the results.

Bhuvnesh

Your code worked fine, quite fast - 11 Seconds, 267 rows

Table...