• dwain.c (11/6/2013)


    There may very well be an easier way to do this, but this is what I came up with:

    Thanks!

    I had played around with a derived table and a cross join, but cross apply is probably better. It's something I rarely use