Reread number 1 and it is an agree/strongly disagree: SET NOCOUNT ON and TRANSATION ISOLATION LEVEL READ UNCOMMITED should be there at the beginning of Stored Procedure.

You do know the problems that you can experience when using transaction isolation level READ UNCOMMITTED don't you?  This allows dirty reads, phantom reads.  If the data MUST BE RIGHT you don't want this.