DP44/DataPRO/Modules/Database/DatabaseMigrationScripts/MigrationScripts/Version80/dbo.DeleteData_ChannelSettings.sql

  IF EXISTS (SELECT * FROM [DataPro].[dbo].[ChannelSettings] WHERE SettingName ='CFC')
   BEGIN 
	 UPDATE [DataPro].[dbo].[GroupChannelSettings] SET SettingValue = 'None,0' WHERE SettingId = 2 AND SettingValue = 'P'
  	 UPDATE [DataPro].[dbo].[GroupChannelSettings] SET SettingValue = 'Unfiltered,-2' WHERE SettingId = 2 AND SettingValue = '0'
 	 UPDATE [DataPro].[dbo].[GroupChannelSettings] SET SettingValue = 'CFC1000,1650' WHERE SettingId = 2 AND SettingValue = 'A'
  	 UPDATE [DataPro].[dbo].[GroupChannelSettings] SET SettingValue = 'CFC600,1000' WHERE SettingId = 2 AND SettingValue = 'B'
  	 UPDATE [DataPro].[dbo].[GroupChannelSettings] SET SettingValue = 'CFC180,300' WHERE SettingId = 2 AND SettingValue = 'C'
  	 UPDATE [DataPro].[dbo].[GroupChannelSettings] SET SettingValue = 'CFC60,100' WHERE SettingId = 2 AND SettingValue = 'D'
  	 UPDATE [DataPro].[dbo].[GroupChannelSettings] SET SettingId = '27' WHERE SettingId = 2       
     DELETE FROM [DataPro].[dbo].[ChannelSettings] WHERE SettingName ='CFC'
   END