I know i posted something like this before, but check out this article over at WWWCoder on cursors in TSQL. Very cool feature. i have known about this for a while now, but never had to write cursors. but it makes life a LOT easer!