i have a table that is pulled from a foxpro database, the table shows line items that have been ordered and the date that they are due (it_due), what i need to be able to do is keep a record of the first it_due date that was entered and any changes that are made to it after i would assume in seperate columns. There would never be more than 15 changes i am not sure if that is relevant.
below is the view i have at the moment
SELECT it_doc, it_quan, it_due
Microsoft SQL Server 2008
8/22/2022 - Mon
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!