Wow, this is wonderful but I need time to digest it.  🙂  Thanks everyone for your input.  Special thanks for Michael Du Bois for your thorough and well documented solution. ...

Thank you.  I ended up writing a stored proc to use cursor to iterate thru the rows and process some logic.  I think even if  it can be done in 1...