Yes agree that LAG LEAD cannot add rows. I've managed to amend the CTE suggestion to work how I need it, a long with the outer join approach. Basically I've used a little bit of everyone's help! 🙂
Yes agree that LAG LEAD cannot add rows. I've managed to amend the CTE suggestion to work how I need it, a long with the outer join approach. Basically I've used a little bit of everyone's help! 🙂
Thank you so much guys 🙂
care to share your solution please...that way we can all learn.
________________________________________________________________ you can lead a user to data....but you cannot make them think and remember....every day is a school day
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply