Never mind. I ended up going retro and using a couple of views (using case statement for the merge) and a stored procedure which I'll schedule in stead.
Hi John - I could, but would that really be useful here? Useful enough to warrant creating a table full of fake data? Or do you think that the example...