I have a db with 2 tables. they are related by a specific column.
They each have an id row that corresponds to each other. The one table holds the company info and then the other table holds pricing info. I need to run through all the rows in the pricing table for a specifc date or date range. And then for the max date for the specific id then I have to update that date in the company table in a last date column that is also assoc with that id. Any ideas on a sp to do this?