troubleshooting Question

SQL Server Stamping date Trail

Avatar of pepps11976
pepps11976 asked on
Microsoft SQL Server 2008
45 Comments1 Solution236 ViewsLast Modified:
Hi All again

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
FROM         dbo.itran

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 45 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 45 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros