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)...

use BULKINSERT

Totally Agree..

I too had some hard time understanding the code.. in the mean while cursing the person who developed it so ....... ha ha

use this command to shrink the temp db

select * from sysfiles

-- use this to get the temp log file name

backup log tempdb with truncate_only

dbcc shrinkfile (templog, 20)

so do this instead...