Jeff Moden (9/10/2012)
The test data setup you provided is great. Could you also describe what you want done with it? The result set doesn' give many hints as to what you're trying to do. Thanks
Hi Jeff,
By using my data in these tables, I want to create a final destination table that would look like the Select Statement I have used at the end.
Basically it should capture the changes in data based on the details table but the dates come from created_dt field from Jrn Table based on status change. which means Accepted Date column should be populated only if the details table has an entry for that change otherwise NULL should be populated.
I hope you got my question.
Good Luck 🙂 .. Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles.