>INSERT INTO [Rates] > ([rat_pk] > ,[rat_name] > ,[rat_type]) > (SELECT newid() > ,[SpecialRate] > ,[rat_type] > FROM (SELECT DISTINCT SpecialRate > ,case when SpecialRate like 'Mail%' > then 2 > case when SpecialRate like 'ZipX%' > then 3 > else 1 end AS [rat_type] > FROM [Weight Rates-Special Rates]) Test) >>NOT TESTED!