Steve,
I Submitted the 2nd one with The OUTPUT Clause for UPDATE Statements. i followed the similar format as the 1st one . i will be working on the MERGE now.