thanks for suggestions @jeff Moden, @Jeffrey Williams. i'll take a look. am new to the whole DBA thing and learning as i go.
Thanks for the feedback and welcome to the "DBA thing". I can't speak for anyone else but I also started out as an "accidental DBA". I believe you'll find a whole lot of people that started out that way.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row. First step towards the paradigm shift of writing Set Based code: ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.