Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Return most-recent cost

Status
Not open for further replies.

Ofina

Technical User
Feb 25, 2004
156
US
I have a table that has items, prices and the dates the prices were from. How can I build a query that will give me each item, the most recent cost and the date it was used? There should only be one instance of each item.
 
What version of SQL Server are you using?

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top