            where transactid = @transid            return 0        end         if @status = 0        begin           return 0        end         if @status=0        begin           return 0        end         if @status=0        begin           return 0        end         if @status = 0        begin           return 0        end         if @status = 0        begin           return 0        end     