Sorry guys for the trouble ... just figured out some crazy method :hehe:

UPDATEtvLRF

SETHasMultiple = 1

FROM@tv_LicenseRenewalFee tvLRF

INNER JOIN (SELECTGroupCode, MIN(SUBSTRING(ClassificationCode,3, LEN(ClassificationCode))) AS Number

FROM@tv_LicenseRenewalFee

WHEREGroupCode <> (

SELECTGroupCode

FROM@tv_LicenseRenewalFee

WHEREHasMultiple = 1

)

GROUP BY GroupCode

HAVING COUNT(GroupCode) > 1) A

ON(A.GroupCode+''+CAST(A.Number AS VARCHAR(2))) = tvLRF.ClassificationCode