why did it error out using the full path? I have several packages that run using a full UNC name. That I beleive is your best bet....

Here is one way to do it

select t.CarReg,t.orderNo,t.orderDate

from

(

select CarReg,orderNo,orderDate,row_number() OVER(PARTITION BY CarReg ORDER BY orderDate desc) as rowID

from #carRentals

)t

where t.rowID=1

Here is another thread that might shed some light.

http://www.sqlservercentral.com/Forums/Topic342925-149-1.aspx#bm343219

crookj (4/12/2011)

And the "vision"...

I beleive they are refferring to two different things.

The Unified Programming Model of course should be easy enough to find information on whether you can get any two programmers to...

Microsoft has a free lab you can donwload at the following link that you may find helpful.

http://www.microsoft.com/downloads/en/details.aspx?familyid=b1145e7a-a4e3-4d14-b1e7-d1d823b6a447&displaylang=en

To quote a movie The wonderful thing about creation is it is such a distructive force. We will never fully be able to weigh the damage or gain that...

will every sale be unique based on Client ID?

do you have a transaction ID that is a common link between the cancel and the sale. If so than this is rather easy. IF not then it...

What I have done in this type of case is use the Row_number function. group by you ID and sort the function by the cutoff date in desc order....

can you post the whole SP?

I was already with an answer when I got towards the end and you said "It's not stored in the table"

Are you saying the previous cutoff date is not stored...

Use the ROW_NUMBER function for this. HEre is a link to the BOL page.

http://msdn.microsoft.com/en-us/library/ms186734.aspx

Not sure if this is what you are encountering but I ran into a problem similiar to yours and this was the cause.

The package we where dealing with...

I don't know how recommended this would be in large but I have even used the follwoing to mass update every job to have the owner set to sa.

update sysjobs...