>>
>>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!
>
>
>Thanks! Good enough to get the brain going again :)
:-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
