Thank you for your responses!

I am using this data for 2 things.

1 is historical tracking of the price and also data auditing.

You have answered my questions Thanks!

what i am trying to do is return the price of a part from a package that is on a job that is the most recent Date ...

Wow thanks for such a fast response. how would i get the MAX Date of a partID to return?

Thanks!

Is there away to get around typing the servername.DBname.Schema in a statement like that?

Yeah i figuired it out i think the query is running right now. I had to put the servername.DBname.Schema.TableName in the statment.

Thank you very much for your help...

Thank you for your Response!

I followed your advice and i receive another error

Msg 208, Level 16, State 1, Line 10

Invalid object name 'OrderDetails'.

Thanks for your help!

Wow, Chad I typed it in and it worked. Thanks!