Mulitple Updates On Table In Same Transaction

 I need to update information for a user and if the user is classified
as a primary (@blnPrimary) then I need to update information for all
users within his agency (AgencyUniqueId). The issue is that the second
UPDATE to "cdds_User_Profile" always returns a rowcount of 0 (should be
1) even though the values for "@Original_AgencyUniqueId" and
"@Original_UserId" are correct. This is just a snippet of the whole
procedure. I'm trying to implement similar logic in other parts of the
procedure and I'm observing the same behavior there as well. Any help
anyone can provide is greatly appreciated.
 
</p><pre>/*** Update User Profile ***/
UPDATE [cdds_User_Profile]
SET [FirstName] = @FirstName, [LastName] = @LastName, [Title] = @Title,
[Phone] = @Phone, [AcctType] = @AcctType, [AcctStatus] = @AcctStatus,
[LastUpdatedDate] = GETDATE()
WHERE ([FirstName] = @Original_FirstName AND [LastName] = @Original_LastName
AND [Title]=@Original_Title AND [Phone]=@Original_Phone
AND [AcctType]=@Original_AcctType AND [AcctStatus]= @Original_AcctStatus
AND [AgencyUniqueId] = @Original_AgencyUniqueId
AND [UserId] = @Original_UserId);
IF @@ROWCOUNT = 0
BEGIN
SET @err_message = 'Data has been edited by another user since you began viewing this information.'
RAISERROR (@err_message,11, 1)
ROLLBACK TRANSACTION
RETURN
END
IF @@ERROR &lt;&gt; 0
BEGIN
ROLLBACK TRANSACTION
RETURN
END

IF @blnPrimary = 1
BEGIN
IF LOWER(@AcctStatus) &lt;&gt; LOWER(@AgencyAcctStatus)
/*** Update Users Acct. Status ***/
/* update all users in same agency profile */
UPDATE [cdds_User_Profile]
SET [AcctStatus] = @AcctStatus,[LastUpdatedDate] = GETDATE()
WHERE ([AgencyUniqueId] = @Original_AgencyUniqueId
AND [UserId] = @Original_UserId);
IF @@ROWCOUNT = 0
BEGIN
SET @err_message = 'Data for this agency has been edited by another user since you began viewing this information.'
RAISERROR (@err_message,11, 1)
ROLLBACK TRANSACTION
RETURN
END
IF @@ERROR &lt;&gt; 0
BEGIN
ROLLBACK TRANSACTION
RETURN
END
END</pre><pre>