I'm working in Crystal Reports 2008 and SQL Server 2008 R2. I need to find the original date an order was placed when the parent (original) record isn't carried throughout the updated records.
Order_ID Order_Written Prev_Ord_ID
10847685 3/15/2013 NULL
10847686 4/12/2013 10847685
10847689 8/16/2013 10847686
11981012 8/21/2013 10847689
So I basically need to be able to say that Order #11981012 was originally written on 3/15/2013. There could be any number of updates for a particular order.
Any thoughts? Is this possible? Do you need more information to make that type of determination?
Order_ID Order_Written Prev_Ord_ID
10847685 3/15/2013 NULL
10847686 4/12/2013 10847685
10847689 8/16/2013 10847686
11981012 8/21/2013 10847689
So I basically need to be able to say that Order #11981012 was originally written on 3/15/2013. There could be any number of updates for a particular order.
Any thoughts? Is this possible? Do you need more information to make that type of determination?