what is the some processing select stuff?

Depending on what it is you may not need a cursor

well other than the fact that you missing half the BETWEEN statement I would say yes almost there.

c.Date > = DATEDIFF(yy,-5,GETDATE())

Please not the this will take into account time as...

Ok cool.

My question is why do you need a table, I'm going to assume that you want to work with the data set from the proc.

I assume this because otherwise...

Are you doing a pivot in your proc call?

What is it that you want to achieve here it might help us help you.

Thanks

Chris

Is the plan the same or different?

Could you post the plan for sum of us to look at?

Have you had any recent data changes as in large amounts of updates or inserts?

I would check the stats on the indexes in that query

HI there,

OK this is still not clear to me.

Please could you read this:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Then re-post your data samples for input and output

thanks

Chris

ok based on your first post I wrote up a query.

Does that query work?

Ok without a table structure or sample data and a sample of what you want to output this is hard.

but this is what I have so far:

[font="Courier New"]

DECLARE @imports TABLE

(

qty...

what are the possible years?

yes read up about the partitioning it's sort of like a "GRouping"

Try this:

[font="Courier New"]

DECLARE @MyTable TABLE

(

[Id] INT,  

[User] VARCHAR(10),        

[Item] CHAR(3),      

[EventTime] DATETIME

)

INSERT INTO @MyTable

SELECT 1,'Bob','AAA','2008-02-02 11:02:51.000' UNION ALL

SELECT 2,'Bob','BBB','2008-02-04 09:10:52.000' UNION ALL

SELECT 3,'Sue','CCC','2008-02-04 15:00:13.000' UNION ALL

SELECT 4,'Bob','DDD','2008-02-04 16:02:05.000' UNION ALL

SELECT 5,'Peter','EEE','2008-02-07 16:03:43.000'...

Hi there,

I'm sure there is a set based solution to this which I will try and find.

But for now here is my solution.

I left the last part out which is...

HI there,

I'm not sure I understand how you are getting your result?

Please could you explain a bit more how to construct the new row?

e.g

Show distinct start_dates + All End dates...

Lynn yours would work if you LTRIM RTRIM the status first.