So that would be 5 years?

The list of possible added cost is long enough to give me a headache. I'll leave him to figure this one out

I'm already dispensable. Nothing new here.

You've seen too much Noeld...

How long have you been a dba?

Finally, here's a version where you can search for all occurances, or 1, or any number you want. The list of wanted items is passed as a string so...

Yup, and we'll always need to move files or other simple stuff like that. So I don't predict and early retirement for dos .

I don't need to test it to know it's gonna run faster. .

OK, TIA.

Possible... keeps us posted.

How about a sample of a current record, with any of its deleted versions?

Is there a DOS.NET too?

Can it be permission problems?

Much neater. Should be faster too .

I used this formula because I didn't want to do :

BasePrice * Case when SomeCol is not null then SomeCol Else 1 end + Case when Col2 is not...