MS SQL SERVER - ISSUES with stored procedure

GlobaLevel
GlobaLevel used Ask the Experts™
on
I am trying to create this stored procedure...but getting some errors....I cant create the sproc till I get past these issues...

Msg 911, Level 16, State 1, Line 18
Could not locate entry in sysdatabases for database 'WIT_ID'. No entry found with that name. Make sure that the name is entered correctly.
Msg 156, Level 15, State 1, Procedure sp_test_Product_Change_To_Product, Line 17
Incorrect syntax near the keyword 'DECLARE'.
Msg 137, Level 15, State 2, Procedure sp_test_Product_Change_To_Product, Line 157
Must declare the scalar variable "@WIT_ID".
Msg 137, Level 15, State 2, Procedure sp_test_Product_Change_To_Product, Line 516
Must declare the scalar variable "@temp_report_table".
Msg 137, Level 15, State 2, Procedure sp_test_Product_Change_To_Product, Line 521
Must declare the scalar variable "@wit_id".
Msg 102, Level 15, State 1, Procedure sp_test_Product_Change_To_Product, Line 549
Incorrect syntax near ','.
Msg 137, Level 15, State 2, Procedure sp_test_Product_Change_To_Product, Line 914
Must declare the scalar variable "@SPELL_CHECK".
Msg 102, Level 15, State 1, Procedure sp_test_Product_Change_To_Product, Line 1954
Incorrect syntax near '60'.
Msg 102, Level 15, State 1, Procedure sp_test_Product_Change_To_Product, Line 1961
Incorrect syntax near '60'.
Msg 102, Level 15, State 1, Procedure sp_test_Product_Change_To_Product, Line 1968
Incorrect syntax near '60'.
Msg 102, Level 15, State 1, Procedure sp_test_Product_Change_To_Product, Line 1975
Incorrect syntax near '60'.
Msg 102, Level 15, State 1, Procedure sp_test_Product_Change_To_Product, Line 1982
Incorrect syntax near '60'.
Msg 102, Level 15, State 1, Procedure sp_test_Product_Change_To_Product, Line 1989
Incorrect syntax near '60'.
Msg 102, Level 15, State 1, Procedure sp_test_Product_Change_To_Product, Line 1996
Incorrect syntax near '60'.
Msg 102, Level 15, State 1, Procedure sp_test_Product_Change_To_Product, Line 2004
Incorrect syntax near '60'.
Msg 102, Level 15, State 1, Procedure sp_test_Product_Change_To_Product, Line 2011
Incorrect syntax near '60'.
Msg 102, Level 15, State 1, Procedure sp_test_Product_Change_To_Product, Line 2018
Incorrect syntax near '60'.
Msg 102, Level 15, State 1, Procedure sp_test_Product_Change_To_Product, Line 2025
Incorrect syntax near '60'.
Msg 102, Level 15, State 1, Procedure sp_test_Product_Change_To_Product, Line 2032
Incorrect syntax near '60'.
Msg 102, Level 15, State 1, Procedure sp_test_Product_Change_To_Product, Line 2039
Incorrect syntax near '60'.
Msg 102, Level 15, State 1, Procedure sp_test_Product_Change_To_Product, Line 2047
Incorrect syntax near '60'.
Msg 102, Level 15, State 1, Procedure sp_test_Product_Change_To_Product, Line 2054
Incorrect syntax near '60'.
Msg 102, Level 15, State 1, Procedure sp_test_Product_Change_To_Product, Line 2062
Incorrect syntax near '60'.
Msg 102, Level 15, State 1, Procedure sp_test_Product_Change_To_Product, Line 2069
Incorrect syntax near '60'.
Msg 102, Level 15, State 1, Procedure sp_test_Product_Change_To_Product, Line 2076
Incorrect syntax near '60'.
Msg 102, Level 15, State 1, Procedure sp_test_Product_Change_To_Product, Line 2083
Incorrect syntax near '60'.
Msg 102, Level 15, State 1, Procedure sp_test_Product_Change_To_Product, Line 2090
Incorrect syntax near '60'.
Msg 102, Level 15, State 1, Procedure sp_test_Product_Change_To_Product, Line 2322
Incorrect syntax near 'END'.













-------------------------------------------------------------------------------------------------

 

/*****************

---------

--   BEGIN --

          --------

******************/

 

USE [WIT_ID]

GO

/****** Object:   ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

 
 

-- _+_+_+_+_+

-- 

-- WE ARE READING PARAMETERS INTO SPROC

 

 

CREATE PROCEDURE [dbo].[sp_test_Product_Change_To_Product]    

DECLARE(    
   @wit_id nvarchar(max) 
 , @SPELL_CHECK varchar(10)
 , @html_compliant varchar(10) 
 , @HOME_PAGE  nvarchar(max)   
 , @CONTACT_PAGEnvarchar(max) 
 , @PRODUCT_PAGEnvarchar(max)  
 , @COMPARE_CHART nvarchar(max) 
 , @PRODUCT_1 nvarchar(max) 
 , @PRODUCT_2 nvarchar(max) 				 ,
 , @PRODUCT_3 nvarchar(max) 
 , @PRODUCT_TRIAL nvarchar(max) 
 , @OVERVIEW nvarchar(max) 
 , @SUPPORT_CENTER nvarchar(max) 
 , @USER_FORUM nvarchar(max) 
 , @UNINSTALL_UTILITY nvarchar(max) 
 , @BLOG nvarchar(max) 
 , @LICENSE_CENTER nvarchar(max) 
 , @ABOUT nvarchar(max) 	
 , @BLOG nvarchar(max) 	
 , @FAQ nvarchar(max)			
 , @CAREERS  nvarchar(max) 	
 , @PRODUCT_ITEM_1 nvarchar(max)
 , @PRODUCT_ITEM_2 nvarchar(max)	
 , @PRODUCT_ITEM_3 nvarchar(max) 	
 , @CATEGORY_ID nvarchar(max)
)    

    
AS    

 SET NOCOUNT ON  

 
/*****************

---------

--   REPORT --

          --------

******************/

 
 DECLARE @date smalldatetime
 SET  @date = ISNULL(@date, getdate())
 

--THROW ALL THE JUNK INTO A REPORT TABLE...  

DECLARE @temp_report_table TABLE(
   DATE smalldatetime
 , WIT_ID nvarchar(max) 
 , HOME_PAGE  nvarchar(max)    
 , CONTACT_PAGE nvarchar(max)     
 , PRODUCT_PAGE nvarchar(max)   
 , COMPARE_CHART nvarchar(max)   
 , PRODUCT_1 nvarchar(max) 
 , PRODUCT_2 nvarchar(max) 
 , PRODUCT_3 nvarchar(max) 
 , PRODUCT_TRIAL nvarchar(max) 
 , OVERVIEW nvarchar(max) 
 , SUPPORT_CENTER nvarchar(max) 
 , USER_FORUM nvarchar(max) 
 , UNINSTALL_UTILITY nvarchar(max) 
 , BLOG nvarchar(max) 
 , LICENSE_CENTER   nvarchar(max)
 , ABOUT nvarchar(max) 	
 , BLOG nvarchar(max) 	
 , FAQ nvarchar(max)			
 , CAREERS  nvarchar(max) 	
 , PRODUCT_ITEM_1 nvarchar(max)
 , PRODUCT_ITEM_2 nvarchar(max)	
 , PRODUCT_ITEM_3 nvarchar(max) 	
 , CATEGORY_ID nvarchar(max)
  
 ) 
 
 
DECLARE @temp_prod_table TABLE(
   DATE smalldatetime
 , WIT_ID nvarchar(max) 
 , HOME_PAGE  nvarchar(max)    
 , CONTACT_PAGE nvarchar(max)     
 , PRODUCT_PAGE nvarchar(max)   
 , COMPARE_CHART nvarchar(max)   
 , PRODUCT_1 nvarchar(max) 
 , PRODUCT_2 nvarchar(max) 
 , PRODUCT_3 nvarchar(max) 
 , PRODUCT_TRIAL nvarchar(max) 
 , OVERVIEW nvarchar(max) 
 , SUPPORT_CENTER nvarchar(max) 
 , USER_FORUM nvarchar(max) 
 , UNINSTALL_UTILITY nvarchar(max) 
 , BLOG nvarchar(max) 
 , LICENSE_CENTER   nvarchar(max)
 , ABOUT nvarchar(max) 	
 , BLOG nvarchar(max) 	
 , FAQ nvarchar(max)			
 , CAREERS  nvarchar(max) 	
 , PRODUCT_ITEM_1 nvarchar(max)
 , PRODUCT_ITEM_2 nvarchar(max)	
 , PRODUCT_ITEM_3 nvarchar(max) 	
 , CATEGORY_ID nvarchar(max)
  
 ) 

 
  INSERT INTO @temp_prod_table (
   DATE
 , WIT_ID 
 , HOME_PAGE      
 , CONTACT_PAGE     
 , PRODUCT_PAGE   
 , COMPARE_CHART  
 , PRODUCT_1 
 , PRODUCT_2 
 , PRODUCT_3 
 , PRODUCT_TRIAL 
 , OVERVIEW 
 , SUPPORT_CENTER 
 , USER_FORUM 
 , UNINSTALL_UTILITY 
 , BLOG 
 , LICENSE_CENTER
 , ABOUT 	
 , BLOG 	
 , FAQ 			
 , CAREERS  	
 , PRODUCT_ITEM_1 
 , PRODUCT_ITEM_2 	
 , PRODUCT_ITEM_3 	
 , CATEGORY_ID 
  
 )
 
 VALUES
(    
   @DATE
 , @WIT_ID
 , @HOME_PAGE  
 , @CONTACT_PAGE
 , @PRODUCT_PAGE 
 , @COMPARE_CHART 
 , @PRODUCT_1 
 , @PRODUCT_2 
 , @PRODUCT_3 
 , @PRODUCT_TRIAL 
 , @OVERVIEW 
 , @SUPPORT_CENTER 
 , @USER_FORUM 
 , @UNINSTALL_UTILITY 
 , @BLOG 
 , @LICENSE_CENTER  
 , @ABOUT 	
 , @BLOG 	
 , @FAQ 			
 , @CAREERS  	
 , @PRODUCT_ITEM_1 
 , @PRODUCT_ITEM_2 	
 , @PRODUCT_ITEM_3 	
 , @CATEGORY_ID 
   
) 
 
 
 
 ---SORT DATA---



INSERT INTO @temp_report_table (HOME_PAGE)
SELECT CASE 
      WHEN HOME_PAGE  like '%shooter%' THEN 'red' 
      WHEN HOME_PAGE  like '%fruit%' THEN 'blue' 
      WHEN HOME_PAGE  like '%block%' THEN 'green'
      WHEN HOME_PAGE  like '%cannot%' THEN 'violet'
      WHEN HOME_PAGE  like '%dack%' THEN 'pink'
      WHEN HOME_PAGE  like '%believing%' THEN 'envy'
      WHEN HOME_PAGE  like '%always%' THEN 'grey'
      WHEN HOME_PAGE  like '%fruiter%' THEN 'blueer' 
      WHEN HOME_PAGE  like '%also%' THEN 'grey'
      WHEN HOME_PAGE  like '%dungess%' THEN 'red' END                         

FROM @temp_prod_table 

 

INSERT INTO @temp_report_table (CONTACT_PAGE)
SELECT CASE 
      WHEN CONTACT_PAGE like '%shooter%' THEN 'red' 
      WHEN CONTACT_PAGE like '%fruit%' THEN 'blue' 
      WHEN CONTACT_PAGE like '%block%' THEN 'green'
      WHEN CONTACT_PAGE like '%cannot%' THEN 'violet'
      WHEN CONTACT_PAGE like '%dack%' THEN 'pink'
      WHEN CONTACT_PAGE like '%believing%' THEN 'envy'
      WHEN CONTACT_PAGE like '%always%' THEN 'grey'
      WHEN CONTACT_PAGE like '%fruiter%' THEN 'blueer' 
      WHEN CONTACT_PAGE like '%also%' THEN 'grey'
      WHEN CONTACT_PAGE like '%dungess%' THEN 'red' END                        

FROM @temp_prod_table 

 

INSERT INTO @temp_report_table (PRODUCT_PAGE)

SELECT CASE 
      WHEN PRODUCT_PAGE like '%shooter%' THEN 'red' 
      WHEN PRODUCT_PAGE like '%fruit%' THEN 'blue' 
      WHEN PRODUCT_PAGE like '%block%' THEN 'green'
      WHEN PRODUCT_PAGE like '%cannot%' THEN 'violet'
      WHEN PRODUCT_PAGE like '%dack%' THEN 'pink'
      WHEN PRODUCT_PAGE like '%believing%' THEN 'envy'
      WHEN PRODUCT_PAGE like '%always%' THEN 'grey'
      WHEN PRODUCT_PAGE like '%fruiter%' THEN 'blueer' 
      WHEN PRODUCT_PAGE like '%also%' THEN 'grey'
      WHEN PRODUCT_PAGE like '%dungess%' THEN 'red' END                      

FROM @temp_prod_table 

 

INSERT INTO @temp_report_table (COMPARE_CHART)

SELECT CASE 
      WHEN COMPARE_CHART like  '%shooter%' THEN 'red' 
      WHEN COMPARE_CHART like  '%fruit%' THEN 'blue' 
      WHEN COMPARE_CHART like  '%block%' THEN 'green'
      WHEN COMPARE_CHART like  '%cannot%' THEN 'violet'
      WHEN COMPARE_CHART like  '%dack%' THEN 'pink'
      WHEN COMPARE_CHART like  '%believing%' THEN 'envy'
      WHEN COMPARE_CHART like  '%always%' THEN 'grey'
      WHEN COMPARE_CHART like  '%fruiter%' THEN 'blueer' 
      WHEN COMPARE_CHART like  '%also%' THEN 'grey'
      WHEN COMPARE_CHART like  '%dungess%' THEN 'red' END                      

FROM @temp_prod_table 

 

INSERT INTO @temp_report_table (PRODUCT_1)

SELECT CASE 
      WHEN PRODUCT_1 like  '%shooter%' THEN 'red' 
      WHEN PRODUCT_1 like  '%fruit%' THEN 'blue' 
      WHEN PRODUCT_1 like  '%block%' THEN 'green'
      WHEN PRODUCT_1 like  '%cannot%' THEN 'violet'
      WHEN PRODUCT_1 like  '%dack%' THEN 'pink'
      WHEN PRODUCT_1 like  '%believing%' THEN 'envy'
      WHEN PRODUCT_1 like  '%always%' THEN 'grey'
      WHEN PRODUCT_1 like  '%fruiter%' THEN 'blueer' 
      WHEN PRODUCT_1 like  '%also%' THEN 'grey'
      WHEN PRODUCT_1 like  '%dungess%' THEN 'red' END                       

FROM @temp_prod_table 

 

INSERT INTO @temp_report_table (PRODUCT_2)

SELECT CASE 
      WHEN PRODUCT_2 like  '%shooter%' THEN 'red' 
      WHEN PRODUCT_2 like  '%fruit%' THEN 'blue' 
      WHEN PRODUCT_2 like  '%block%' THEN 'green'
      WHEN PRODUCT_2 like  '%cannot%' THEN 'violet'
      WHEN PRODUCT_2 like  '%dack%' THEN 'pink'
      WHEN PRODUCT_2 like  '%believing%' THEN 'envy'
      WHEN PRODUCT_2 like  '%always%' THEN 'grey'
      WHEN PRODUCT_2 like  '%fruiter%' THEN 'blueer' 
      WHEN PRODUCT_2 like  '%also%' THEN 'grey'
      WHEN PRODUCT_2 like  '%dungess%' THEN 'red' END                         

FROM @temp_prod_table 

 

INSERT INTO @temp_report_table (PRODUCT_3)

SELECT CASE 
      WHEN PRODUCT_3 like  '%shooter%' THEN 'red' 
      WHEN PRODUCT_3 like  '%fruit%' THEN 'blue' 
      WHEN PRODUCT_3 like  '%block%' THEN 'green'
      WHEN PRODUCT_3 like  '%cannot%' THEN 'violet'
      WHEN PRODUCT_3 like  '%dack%' THEN 'pink'
      WHEN PRODUCT_3 like  '%believing%' THEN 'envy'
      WHEN PRODUCT_3 like  '%always%' THEN 'grey'
      WHEN PRODUCT_3 like  '%fruiter%' THEN 'blueer' 
      WHEN PRODUCT_3 like  '%also%' THEN 'grey'
      WHEN PRODUCT_3 like  '%dungess%' THEN 'red' END                   

FROM @temp_prod_table 

 

INSERT INTO @temp_report_table (PRODUCT_TRIAL)

SELECT CASE 
      WHEN PRODUCT_TRIAL like  '%shooter%' THEN 'red' 
      WHEN PRODUCT_TRIAL like  '%fruit%' THEN 'blue' 
      WHEN PRODUCT_TRIAL like  '%block%' THEN 'green'
      WHEN PRODUCT_TRIAL like  '%cannot%' THEN 'violet'
      WHEN PRODUCT_TRIAL like  '%dack%' THEN 'pink'
      WHEN PRODUCT_TRIAL like  '%believing%' THEN 'envy'
      WHEN PRODUCT_TRIAL like  '%always%' THEN 'grey'
      WHEN PRODUCT_TRIAL like  '%fruiter%' THEN 'blueer' 
      WHEN PRODUCT_TRIAL like  '%also%' THEN 'grey'
      WHEN PRODUCT_TRIAL like  '%dungess%' THEN 'red' END                         

FROM @temp_prod_table 

 

INSERT INTO @temp_report_table (OVERVIEW)

SELECT CASE 
      WHEN OVERVIEW like  '%shooter%' THEN 'red' 
      WHEN OVERVIEW like  '%fruit%' THEN 'blue' 
      WHEN OVERVIEW like  '%block%' THEN 'green'
      WHEN OVERVIEW like  '%cannot%' THEN 'violet'
      WHEN OVERVIEW like  '%dack%' THEN 'pink'
      WHEN OVERVIEW like  '%believing%' THEN 'envy'
      WHEN OVERVIEW like  '%always%' THEN 'grey'
      WHEN OVERVIEW like  '%fruiter%' THEN 'blueer' 
      WHEN OVERVIEW like  '%also%' THEN 'grey'
      WHEN OVERVIEW like  '%dungess%' THEN 'red' END                      

FROM @temp_prod_table 

 

INSERT INTO @temp_report_table (SUPPORT_CENTER)

SELECT CASE 
      WHEN SUPPORT_CENTER like  '%shooter%' THEN 'red' 
      WHEN SUPPORT_CENTER like  '%fruit%' THEN 'blue' 
      WHEN SUPPORT_CENTER like  '%block%' THEN 'green'
      WHEN SUPPORT_CENTER like  '%cannot%' THEN 'violet'
      WHEN SUPPORT_CENTER like  '%dack%' THEN 'pink'
      WHEN SUPPORT_CENTER like  '%believing%' THEN 'envy'
      WHEN SUPPORT_CENTER like  '%always%' THEN 'grey'
      WHEN SUPPORT_CENTER like  '%fruiter%' THEN 'blueer' 
      WHEN SUPPORT_CENTER like  '%also%' THEN 'grey'
      WHEN SUPPORT_CENTER like  '%dungess%' THEN 'red' END                      

FROM @temp_prod_table 

 

INSERT INTO @temp_report_table (USER_FORUM)

SELECT CASE 

      WHEN USER_FORUM like  '%shooter%' THEN 'red' 
      WHEN USER_FORUM like  '%fruit%' THEN 'blue' 
      WHEN USER_FORUM like  '%block%' THEN 'green'
      WHEN USER_FORUM like  '%cannot%' THEN 'violet'
      WHEN USER_FORUM like  '%dack%' THEN 'pink'
      WHEN USER_FORUM like  '%believing%' THEN 'envy'
      WHEN USER_FORUM like  '%always%' THEN 'grey'
      WHEN USER_FORUM like  '%fruiter%' THEN 'blueer' 
      WHEN USER_FORUM like  '%also%' THEN 'grey'
      WHEN USER_FORUM like  '%dungess%' THEN 'red' END                    

FROM @temp_prod_table 

 

INSERT INTO @temp_report_table (UNINSTALL_UTILITY)

SELECT CASE 
      WHEN UNINSTALL_UTILITY like  '%shooter%' THEN 'red' 
      WHEN UNINSTALL_UTILITY like  '%fruit%' THEN 'blue' 
      WHEN UNINSTALL_UTILITY like  '%block%' THEN 'green'
      WHEN UNINSTALL_UTILITY like  '%cannot%' THEN 'violet'
      WHEN UNINSTALL_UTILITY like  '%dack%' THEN 'pink'
      WHEN UNINSTALL_UTILITY like  '%believing%' THEN 'envy'
      WHEN UNINSTALL_UTILITY like  '%always%' THEN 'grey'
      WHEN UNINSTALL_UTILITY like  '%fruiter%' THEN 'blueer' 
      WHEN UNINSTALL_UTILITY like  '%also%' THEN 'grey'
      WHEN UNINSTALL_UTILITY like  '%dungess%' THEN 'red' END                       

FROM @temp_prod_table

 

INSERT INTO @temp_report_table (BLOG)

SELECT CASE 
      WHEN BLOG like  '%shooter%' THEN 'red' 
      WHEN BLOG like  '%fruit%' THEN 'blue' 
      WHEN BLOG like  '%block%' THEN 'green'
      WHEN BLOG like  '%cannot%' THEN 'violet'
      WHEN BLOG like  '%dack%' THEN 'pink'
      WHEN BLOG like  '%believing%' THEN 'envy'
      WHEN BLOG like  '%always%' THEN 'grey'
      WHEN BLOG like  '%fruiter%' THEN 'blueer' 
      WHEN BLOG like  '%also%' THEN 'grey'
      WHEN BLOG like  '%dungess%' THEN 'red' END                     

FROM @temp_prod_table

 

INSERT INTO @temp_report_table (FAQ)

SELECT CASE 

      WHEN FAQ like  '%shooter%' THEN 'red' 
      WHEN FAQ like  '%fruit%' THEN 'blue' 
      WHEN FAQ like  '%block%' THEN 'green'
      WHEN FAQ like  '%cannot%' THEN 'violet'
      WHEN FAQ like  '%dack%' THEN 'pink'
      WHEN FAQ like  '%believing%' THEN 'envy'
      WHEN FAQ like  '%always%' THEN 'grey'
      WHEN FAQ like  '%fruiter%' THEN 'blueer' 
      WHEN FAQ like  '%also%' THEN 'grey'
      WHEN FAQ like  '%dungess%' THEN 'red' END                       

FROM @temp_prod_table 


INSERT INTO @temp_report_table (CAREERS)

SELECT CASE 

      WHEN CAREERS like  '%shooter%' THEN 'red' 
      WHEN CAREERS like  '%fruit%' THEN 'blue' 
      WHEN CAREERS like  '%block%' THEN 'green'
      WHEN CAREERS like  '%cannot%' THEN 'violet'
      WHEN CAREERS like  '%dack%' THEN 'pink'
      WHEN CAREERS like  '%believing%' THEN 'envy'
      WHEN CAREERS like  '%always%' THEN 'grey'
      WHEN CAREERS like  '%fruiter%' THEN 'blueer' 
      WHEN CAREERS like  '%also%' THEN 'grey'
      WHEN CAREERS like  '%dungess%' THEN 'red' END                       

FROM @temp_prod_table 


INSERT INTO @temp_report_table (PRODUCT_ITEM_1)

SELECT CASE 

      WHEN PRODUCT_ITEM_1 like  '%shooter%' THEN 'red' 
      WHEN PRODUCT_ITEM_1 like  '%fruit%' THEN 'blue' 
      WHEN PRODUCT_ITEM_1 like  '%block%' THEN 'green'
      WHEN PRODUCT_ITEM_1 like  '%cannot%' THEN 'violet'
      WHEN PRODUCT_ITEM_1 like  '%dack%' THEN 'pink'
      WHEN PRODUCT_ITEM_1 like  '%believing%' THEN 'envy'
      WHEN PRODUCT_ITEM_1 like  '%always%' THEN 'grey'
      WHEN PRODUCT_ITEM_1 like  '%fruiter%' THEN 'blueer' 
      WHEN PRODUCT_ITEM_1 like  '%also%' THEN 'grey'
      WHEN PRODUCT_ITEM_1 like  '%dungess%' THEN 'red' END                       

FROM @temp_prod_table 



INSERT INTO @temp_report_table (PRODUCT_ITEM_2)

SELECT CASE 

      WHEN PRODUCT_ITEM_2 like  '%shooter%' THEN 'red' 
      WHEN PRODUCT_ITEM_2 like  '%fruit%' THEN 'blue' 
      WHEN PRODUCT_ITEM_2 like  '%block%' THEN 'green'
      WHEN PRODUCT_ITEM_2 like  '%cannot%' THEN 'violet'
      WHEN PRODUCT_ITEM_2 like  '%dack%' THEN 'pink'
      WHEN PRODUCT_ITEM_2 like  '%believing%' THEN 'envy'
      WHEN PRODUCT_ITEM_2 like  '%always%' THEN 'grey'
      WHEN PRODUCT_ITEM_2 like  '%fruiter%' THEN 'blueer' 
      WHEN PRODUCT_ITEM_2 like  '%also%' THEN 'grey'
      WHEN PRODUCT_ITEM_2 like  '%dungess%' THEN 'red' END                       

FROM @temp_prod_table 


INSERT INTO @temp_report_table (PRODUCT_ITEM_3)

SELECT CASE 

      WHEN PRODUCT_ITEM_3 like  '%shooter%' THEN 'red' 
      WHEN PRODUCT_ITEM_3 like  '%fruit%' THEN 'blue' 
      WHEN PRODUCT_ITEM_3 like  '%block%' THEN 'green'
      WHEN PRODUCT_ITEM_3 like  '%cannot%' THEN 'violet'
      WHEN PRODUCT_ITEM_3 like  '%dack%' THEN 'pink'
      WHEN PRODUCT_ITEM_3 like  '%believing%' THEN 'envy'
      WHEN PRODUCT_ITEM_3 like  '%always%' THEN 'grey'
      WHEN PRODUCT_ITEM_3 like  '%fruiter%' THEN 'blueer' 
      WHEN PRODUCT_ITEM_3 like  '%also%' THEN 'grey'
      WHEN PRODUCT_ITEM_3 like  '%dungess%' THEN 'red' END                       

FROM @temp_prod_table 



--IF THERE IS JUNK SEND TO REPORT TABLE

IF @temp_report_table not NULL
BEGIN
 INSERT INTO client_monitor_table
 SELECT * 
 FROM  @temp_report_table
 WHERE wit_id = @wit_id

END

 

 

/*****************

---------

--   PRODUCT  --

          --------

******************/

 

 

--CLEAN UP THE LANGUAGE...


 
 DECLARE @temp_prod_after_cleanup_table TABLE(
    DATE smalldatetime, 
  , WIT_ID nvarchar(max) 
  , HOME_PAGE  nvarchar(max)    
  , CONTACT_PAGE nvarchar(max)     
  , PRODUCT_PAGE nvarchar(max)   
  , COMPARE_CHART nvarchar(max)   
  , PRODUCT_1 nvarchar(max) 
  , PRODUCT_2 nvarchar(max) 
  , PRODUCT_3 nvarchar(max) 
  , PRODUCT_TRIAL nvarchar(max) 
  , OVERVIEW nvarchar(max) 
  , SUPPORT_CENTER nvarchar(max) 
  , USER_FORUM nvarchar(max) 
  , UNINSTALL_UTILITY nvarchar(max) 
  , BLOG nvarchar(max) 
  , LICENSE_CENTER   nvarchar(max)
  , ABOUT nvarchar(max)  	
  , FAQ nvarchar(max)			
  , CAREERS  nvarchar(max) 	
  , PRODUCT_ITEM_1 nvarchar(max)
  , PRODUCT_ITEM_2 nvarchar(max)	
  , PRODUCT_ITEM_3 nvarchar(max) 	
  , CATEGORY_ID nvarchar(max)
 
    

INSERT INTO @temp_prod_after_cleanup_table (HOME_PAGE )
SELECT CASE 
             WHEN HOME_PAGE  like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN HOME_PAGE  like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN HOME_PAGE  like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN HOME_PAGE  like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN HOME_PAGE  like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN HOME_PAGE  like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN HOME_PAGE  like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN HOME_PAGE  like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN HOME_PAGE  like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN HOME_PAGE  like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                        

FROM @temp_prod_table 

 

INSERT INTO @temp_prod_after_cleanup_table (CONTACT_PAGE)
SELECT CASE 
            WHEN CONTACT_PAGE like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN CONTACT_PAGE like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN CONTACT_PAGE like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN CONTACT_PAGE like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN CONTACT_PAGE like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN CONTACT_PAGE like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN CONTACT_PAGE like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN CONTACT_PAGE like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN CONTACT_PAGE like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN CONTACT_PAGE like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                         

FROM @temp_prod_table

 

INSERT INTO @temp_prod_after_cleanup_table (PRODUCT_PAGE)
SELECT CASE 
             WHEN PRODUCT_PAGE like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_PAGE like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_PAGE like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_PAGE like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_PAGE like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_PAGE like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_PAGE like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_PAGE like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_PAGE like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_PAGE like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                    

FROM @temp_prod_table 

 

INSERT INTO @temp_prod_after_cleanup_table (COMPARE_CHART)
SELECT CASE 
             WHEN COMPARE_CHART like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN COMPARE_CHART like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN COMPARE_CHART like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN COMPARE_CHART like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN COMPARE_CHART like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN COMPARE_CHART like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN COMPARE_CHART like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN COMPARE_CHART like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN COMPARE_CHART like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN COMPARE_CHART like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                      

FROM @temp_prod_table 

 

INSERT INTO @temp_prod_after_cleanup_table (PRODUCT_1)
SELECT CASE 
             WHEN PRODUCT_1 like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_1 like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_1 like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_1 like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_1 like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_1 like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_1 like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_1 like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_1 like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_1 like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                     

FROM @temp_prod_table 

 

INSERT INTO @temp_prod_after_cleanup_table (PRODUCT_2)
SELECT CASE 
             WHEN PRODUCT_2 like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_2 like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_2 like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_2 like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_2 like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_2 like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_2 like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_2 like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_2 like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_2 like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                     

FROM @temp_prod_table 

 

INSERT INTO @temp_prod_after_cleanup_table (PRODUCT_3)
SELECT CASE 
             WHEN PRODUCT_3 like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_3 like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_3 like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_3 like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_3 like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_3 like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_3 like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_3 like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_3 like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_3 like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                          

FROM @temp_prod_table

 

INSERT INTO @temp_prod_after_cleanup_table (PRODUCT_TRIAL)
SELECT CASE 
             WHEN PRODUCT_TRIAL like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_TRIAL like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_TRIAL like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_TRIAL like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_TRIAL like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_TRIAL like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_TRIAL like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_TRIAL like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_TRIAL like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_TRIAL like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                     

FROM @temp_prod_table 

 

INSERT INTO @temp_prod_after_cleanup_table (OVERVIEW)
SELECT CASE 
           WHEN OVERVIEW like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN OVERVIEW like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN OVERVIEW like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN OVERVIEW like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN OVERVIEW like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN OVERVIEW like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN OVERVIEW like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN OVERVIEW like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN OVERVIEW like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN OVERVIEW like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                    

FROM @temp_prod_table 

 

INSERT INTO @temp_prod_after_cleanup_table (SUPPORT_CENTER)
SELECT CASE 
            WHEN SUPPORT_CENTER like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN SUPPORT_CENTER like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN SUPPORT_CENTER like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN SUPPORT_CENTER like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN SUPPORT_CENTER like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN SUPPORT_CENTER like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN SUPPORT_CENTER like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN SUPPORT_CENTER like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN SUPPORT_CENTER like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN SUPPORT_CENTER like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                       

FROM @temp_prod_table 

 

INSERT INTO @temp_prod_after_cleanup_table (USER_FORUM)
SELECT CASE 
             WHEN USER_FORUM like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN USER_FORUM like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN USER_FORUM like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN USER_FORUM like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN USER_FORUM like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN USER_FORUM like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN USER_FORUM like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN USER_FORUM like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN USER_FORUM like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN USER_FORUM like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                    

FROM @temp_prod_table

 

INSERT INTO @temp_prod_after_cleanup_table (UNINSTALL_UTILITY)
SELECT CASE 
             WHEN UNINSTALL_UTILITY like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN UNINSTALL_UTILITY like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN UNINSTALL_UTILITY like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN UNINSTALL_UTILITY like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN UNINSTALL_UTILITY like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN UNINSTALL_UTILITY like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN UNINSTALL_UTILITY like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN UNINSTALL_UTILITY like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN UNINSTALL_UTILITY like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN UNINSTALL_UTILITY like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                       

FROM @temp_prod_table
 

INSERT INTO @temp_prod_after_cleanup_table (BLOG)
SELECT CASE 
             WHEN BLOG like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN BLOG like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN BLOG like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN BLOG like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN BLOG like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN BLOG like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN BLOG like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN BLOG like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN BLOG like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN BLOG like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                    

FROM @temp_prod_table
 

INSERT INTO @temp_prod_after_cleanup_table (LICENSE_CENTER)
SELECT CASE 
            WHEN LICENSE_CENTER like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN LICENSE_CENTER like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN LICENSE_CENTER like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN LICENSE_CENTER like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN LICENSE_CENTER like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN LICENSE_CENTER like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN LICENSE_CENTER like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN LICENSE_CENTER like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN LICENSE_CENTER like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN LICENSE_CENTER like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                       

FROM @temp_prod_table

 
INSERT INTO @temp_prod_after_cleanup_table (FAQ)
SELECT CASE 
            WHEN FAQ like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN FAQ like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN FAQ like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN FAQ like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN FAQ like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN FAQ like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN FAQ like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN FAQ like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN FAQ like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN FAQ like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                   

FROM @temp_prod_table


INSERT INTO @temp_prod_after_cleanup_table (CAREERS)
SELECT CASE 
            WHEN CAREERS like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN CAREERS like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN CAREERS like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN CAREERS like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN CAREERS like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN CAREERS like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN CAREERS like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN CAREERS like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN CAREERS like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN CAREERS like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                     

FROM @temp_prod_table


INSERT INTO @temp_prod_after_cleanup_table (PRODUCT_ITEM_1)
SELECT CASE 
            WHEN PRODUCT_ITEM_1 like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_ITEM_1 like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_ITEM_1 like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_1 like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_1 like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_1 like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_1 like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_1 like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_1 like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_1 like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                     

FROM @temp_prod_table

INSERT INTO @temp_prod_after_cleanup_table (PRODUCT_ITEM_2)
SELECT CASE 
             WHEN PRODUCT_ITEM_2 like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_ITEM_2 like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_ITEM_2 like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_2 like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_2 like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_2 like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_2 like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_2 like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_2 like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_2 like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                    

FROM @temp_prod_table

INSERT INTO @temp_prod_after_cleanup_table (PRODUCT_ITEM_3)
SELECT CASE 
         WHEN PRODUCT_ITEM_3 like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_ITEM_3 like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_ITEM_3 like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_3 like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_3 like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_3 like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_3 like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_3 like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_3 like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_3 like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                       

FROM @temp_prod_table


/*****************

---------

--   SPELL CHECK  --

          --------

******************/

 

-- IF SPELL CHECK COLUMN IS CHECKED THEN PROCEED ELSE GET OUT OF SPROC

-- TURN:

-- 'Wlcome! Yu are now loged into this ste. So glad you are here. 
--   We have a lot of great paes to vist: emil, abut, hme, fq, contct us, 
--   prducts, spport, cstomer srvice, sles team, stff.'


-- INTO:
-- 'Welcome! You are now logged into this site. So glad you are here. 
--   We have a lot of great pages to visit: email, about, home, faq, contact us, 
--   products, support, customer service, sales team, staff.'
 

if @SPELL_CHECK = 'y' 

BEGIN 

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'stff', 'staff')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'sles team', 'sales team')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'cstomer srvice', 'customer service')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'spport', 'support')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'prducts', 'products')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'contct us', 'contact us')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'fq', 'FAQ')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'hme', 'home')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'abut', 'about')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'emil', 'email')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'vist', 'visit')  
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'paes', 'pages') 
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'Wlcome!', 'Welcome!') 
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'Yu', 'You')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'loged', 'logged')

 

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'stff', 'staff')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'sles team', 'sales team')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'cstomer srvice', 'customer service')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'spport', 'support')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'prducts', 'products')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'contct us', 'contact us')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'fq', 'FAQ')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'hme', 'home')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'abut', 'about')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'emil', 'email')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'vist', 'visit')  
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'paes', 'pages') 

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'Wlcome!', 'Welcome!')    
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'Yu', 'You')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'loged', 'logged') 

 

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'stff', 'staff')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'sles team', 'sales team')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'cstomer srvice', 'customer service')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'spport', 'support')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'prducts', 'products')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'contct us', 'contact us')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'fq', 'FAQ')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'hme', 'home')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'abut', 'about')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'emil', 'email')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'vist', 'visit')  
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'paes', 'pages')     

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'Wlcome!', 'Welcome!')  
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'Yu', 'You')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'loged', 'logged')

 

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'stff', 'staff')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'sles team', 'sales team')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'cstomer srvice', 'customer service')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'spport', 'support')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'prducts', 'products')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'contct us', 'contact us')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'fq', 'FAQ')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'hme', 'home')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'abut', 'about')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'emil', 'email')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'vist', 'visit')    

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'paes', 'pages')        

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'Wlcome!', 'Welcome!')    

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'Yu', 'You')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'loged', 'logged')

 
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'stff', 'staff')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'sles team', 'sales team')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'cstomer srvice', 'customer service')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'spport', 'support')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'prducts', 'products')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'contct us', 'contact us')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'fq', 'FAQ')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'hme', 'home')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'abut', 'about')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'emil', 'email')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'vist', 'visit')  

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'paes', 'pages')        

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'Wlcome!', 'Welcome!')   

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'Yu', 'You')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'loged', 'logged')

 

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'stff', 'staff')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'sles team', 'sales team')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'cstomer srvice', 'customer service')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'spport', 'support')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'prducts', 'products')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'contct us', 'contact us')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'fq', 'FAQ')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'hme', 'home')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'abut', 'about')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'emil', 'email')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'vist', 'visit')  
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'paes', 'pages')      

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'Wlcome!', 'Welcome!')  
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'Yu', 'You')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'loged', 'logged')

 

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'stff', 'staff')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'sles team', 'sales team')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'cstomer srvice', 'customer service')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'spport', 'support')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'prducts', 'products')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'contct us', 'contact us')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'fq', 'FAQ')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'hme', 'home')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'abut', 'about')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'emil', 'email')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'vist', 'visit')  
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'paes', 'pages')       

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'Wlcome!', 'Welcome!')  
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'Yu', 'You')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'loged', 'logged')
 


                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'stff', 'staff')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'sles team', 'sales team')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'cstomer srvice', 'customer service')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'spport', 'support')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'prducts', 'products')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'contct us', 'contact us')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'fq', 'FAQ')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'hme', 'home')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'abut', 'about')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'emil', 'email')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'vist', 'visit')      
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'paes', 'pages')          

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'Wlcome!', 'Welcome!')    

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'Yu', 'You')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'loged', 'logged')
 

 

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   OVERVIEW = REPLACE(OVERVIEW, 'stff', 'staff')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   OVERVIEW = REPLACE(OVERVIEW, 'sles team', 'sales team')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   OVERVIEW = REPLACE(OVERVIEW, 'cstomer srvice', 'customer service')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   OVERVIEW = REPLACE(OVERVIEW, 'spport', 'support')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   OVERVIEW = REPLACE(OVERVIEW, 'prducts', 'products')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   OVERVIEW = REPLACE(OVERVIEW, 'contct us', 'contact us')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   OVERVIEW = REPLACE(OVERVIEW, 'fq', 'FAQ')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   OVERVIEW = REPLACE(OVERVIEW, 'hme', 'home')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   OVERVIEW = REPLACE(OVERVIEW, 'abut', 'about')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   OVERVIEW = REPLACE(OVERVIEW, 'emil', 'email')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   OVERVIEW = REPLACE(OVERVIEW, 'vist', 'visit')     

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   OVERVIEW = REPLACE(OVERVIEW, 'paes', 'pages')          

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   OVERVIEW = REPLACE(OVERVIEW, 'Wlcome!', 'Welcome!')      
                  UPDATE  @temp_prod_after_cleanup_table

                  SET   OVERVIEW = REPLACE(OVERVIEW, 'Yu', 'You')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   OVERVIEW = REPLACE(OVERVIEW, 'loged', 'logged')
 

 

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'stff', 'staff')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'sles team', 'sales team')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'cstomer srvice', 'customer service')

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'spport', 'support')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'prducts', 'products')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'contct us', 'contact us')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'fq', 'FAQ')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'hme', 'home')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'abut', 'about')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'emil', 'email')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'vist', 'visit')    
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'paes', 'pages')         

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'Wlcome!', 'Welcome!')    
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'Yu', 'You')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'loged', 'logged')

 
 

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'stff', 'staff')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'sles team', 'sales team')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'cstomer srvice', 'customer service')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'spport', 'support')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'prducts', 'products')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'contct us', 'contact us')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'fq', 'FAQ')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'hme', 'home')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'abut', 'about')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'emil', 'email')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'vist', 'visit')  
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'paes', 'pages')       

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'Wlcome!', 'Welcome!')  
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'Yu', 'You')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'loged', 'logged')
 

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'stff', 'staff')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'sles team', 'sales team')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'cstomer srvice', 'customer service')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'spport', 'support')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'prducts', 'products')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'contct us', 'contact us')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'fq', 'FAQ')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'hme', 'home')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'abut', 'about')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'emil', 'email')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'vist', 'visit')  
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'paes', 'pages')       

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'Wlcome!', 'Welcome!')  
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'Yu', 'You')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'loged', 'logged')

 

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'stff', 'staff')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'sles team', 'sales team')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'cstomer srvice', 'customer service')

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'spport', 'support')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'prducts', 'products')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'contct us', 'contact us')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'fq', 'FAQ')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'hme', 'home')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'abut', 'about')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'emil', 'email')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'vist', 'visit')   

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'paes', 'pages')         

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'Wlcome!', 'Welcome!')   

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'Yu', 'You')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'loged', 'logged') 

 

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'stff', 'staff')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'sles team', 'sales team')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'cstomer srvice', 'customer service')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'spport', 'support')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'prducts', 'products')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'contct us', 'contact us')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'fq', 'FAQ')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'hme', 'home')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'abut', 'about')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'emil', 'email')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'vist', 'visit')  
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'paes', 'pages')       

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'Wlcome!', 'Welcome!')  
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'Yu', 'You')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'loged', 'logged')

 
 
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   BLOG  = REPLACE(BLOG , 'stff', 'staff')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   BLOG  = REPLACE(BLOG , 'sles team', 'sales team')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   BLOG  = REPLACE(BLOG , 'cstomer srvice', 'customer service')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   BLOG  = REPLACE(BLOG , 'spport', 'support')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   BLOG  = REPLACE(BLOG , 'prducts', 'products')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   BLOG  = REPLACE(BLOG , 'contct us', 'contact us')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   BLOG  = REPLACE(BLOG , 'fq', 'FAQ')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   BLOG  = REPLACE(BLOG , 'hme', 'home')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   BLOG  = REPLACE(BLOG , 'abut', 'about')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   BLOG  = REPLACE(BLOG , 'emil', 'email')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   BLOG  = REPLACE(BLOG , 'vist', 'visit')  
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   BLOG  = REPLACE(BLOG , 'paes', 'pages') 
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   BLOG  = REPLACE(BLOG , 'Wlcome!', 'Welcome!') 
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   BLOG  = REPLACE(BLOG , 'Yu', 'You')
                   UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG  = REPLACE(BLOG , 'loged', 'logged')
 
 
 
 
 
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   FAQ  = REPLACE(FAQ , 'stff', 'staff')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   FAQ  = REPLACE(FAQ , 'sles team', 'sales team')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   FAQ  = REPLACE(FAQ , 'cstomer srvice', 'customer service')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   FAQ  = REPLACE(FAQ , 'spport', 'support')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   FAQ  = REPLACE(FAQ , 'prducts', 'products')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   FAQ  = REPLACE(FAQ , 'contct us', 'contact us')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   FAQ  = REPLACE(FAQ , 'fq', 'FAQ')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   FAQ  = REPLACE(FAQ , 'hme', 'home')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   FAQ  = REPLACE(FAQ , 'abut', 'about')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   FAQ  = REPLACE(FAQ , 'emil', 'email')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   FAQ  = REPLACE(FAQ , 'vist', 'visit')  
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   FAQ  = REPLACE(FAQ , 'paes', 'pages') 
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   FAQ  = REPLACE(FAQ , 'Wlcome!', 'Welcome!') 
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   FAQ  = REPLACE(FAQ , 'Yu', 'You')
                   UPDATE  @temp_prod_after_cleanup_table
                  SET   FAQ  = REPLACE(FAQ , 'loged', 'logged')
 
 
 
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   CAREERS  = REPLACE(CAREERS , 'stff', 'staff')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   CAREERS  = REPLACE(CAREERS , 'sles team', 'sales team')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   CAREERS  = REPLACE(CAREERS , 'cstomer srvice', 'customer service')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   CAREERS  = REPLACE(CAREERS , 'spport', 'support')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   CAREERS  = REPLACE(CAREERS , 'prducts', 'products')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   CAREERS  = REPLACE(CAREERS , 'contct us', 'contact us')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   CAREERS  = REPLACE(CAREERS , 'fq', 'FAQ')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   CAREERS  = REPLACE(CAREERS , 'hme', 'home')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   CAREERS  = REPLACE(CAREERS , 'abut', 'about')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   CAREERS  = REPLACE(CAREERS , 'emil', 'email')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   CAREERS  = REPLACE(CAREERS , 'vist', 'visit')  
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   CAREERS  = REPLACE(CAREERS , 'paes', 'pages') 
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   CAREERS  = REPLACE(CAREERS , 'Wlcome!', 'Welcome!') 
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   CAREERS  = REPLACE(CAREERS , 'Yu', 'You')
                   UPDATE  @temp_prod_after_cleanup_table
                  SET   CAREERS  = REPLACE(CAREERS , 'loged', 'logged')
 
 
 
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'stff', 'staff')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'sles team', 'sales team')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'cstomer srvice', 'customer service')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'spport', 'support')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'prducts', 'products')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'contct us', 'contact us')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'fq', 'FAQ')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'hme', 'home')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'abut', 'about')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'emil', 'email')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'vist', 'visit')  
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'paes', 'pages') 
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'Wlcome!', 'Welcome!') 
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'Yu', 'You')
                   UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'loged', 'logged')
 
 
 
   		UPDATE  @temp_prod_after_cleanup_table
                    SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'stff', 'staff')
                    UPDATE  @temp_prod_after_cleanup_table
                    SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'sles team', 'sales team')
                    UPDATE  @temp_prod_after_cleanup_table
                    SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'cstomer srvice', 'customer service')
                    UPDATE  @temp_prod_after_cleanup_table
                    SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'spport', 'support')
                    UPDATE  @temp_prod_after_cleanup_table
                    SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'prducts', 'products')
                    UPDATE  @temp_prod_after_cleanup_table
                    SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'contct us', 'contact us')
                    UPDATE  @temp_prod_after_cleanup_table
                    SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'fq', 'FAQ')
                    UPDATE  @temp_prod_after_cleanup_table
                    SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'hme', 'home')
                    UPDATE  @temp_prod_after_cleanup_table
                    SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'abut', 'about')
                    UPDATE  @temp_prod_after_cleanup_table
                    SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'emil', 'email')
                    UPDATE  @temp_prod_after_cleanup_table
                    SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'vist', 'visit')  
                    UPDATE  @temp_prod_after_cleanup_table
                    SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'paes', 'pages') 
                    UPDATE  @temp_prod_after_cleanup_table
                    SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'Wlcome!', 'Welcome!') 
                    UPDATE  @temp_prod_after_cleanup_table
                    SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'Yu', 'You')
                    UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'loged', 'logged')
 
 
 
    		UPDATE  @temp_prod_after_cleanup_table
                     SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'stff', 'staff')
                     UPDATE  @temp_prod_after_cleanup_table
                     SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'sles team', 'sales team')
                     UPDATE  @temp_prod_after_cleanup_table
                     SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'cstomer srvice', 'customer service')
                     UPDATE  @temp_prod_after_cleanup_table
                     SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'spport', 'support')
                     UPDATE  @temp_prod_after_cleanup_table
                     SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'prducts', 'products')
                     UPDATE  @temp_prod_after_cleanup_table
                     SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'contct us', 'contact us')
                     UPDATE  @temp_prod_after_cleanup_table
                     SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'fq', 'FAQ')
                     UPDATE  @temp_prod_after_cleanup_table
                     SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'hme', 'home')
                     UPDATE  @temp_prod_after_cleanup_table
                     SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'abut', 'about')
                     UPDATE  @temp_prod_after_cleanup_table
                     SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'emil', 'email')
                     UPDATE  @temp_prod_after_cleanup_table
                     SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'vist', 'visit')  
                     UPDATE  @temp_prod_after_cleanup_table
                     SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'paes', 'pages') 
                     UPDATE  @temp_prod_after_cleanup_table
                     SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'Wlcome!', 'Welcome!') 
                     UPDATE  @temp_prod_after_cleanup_table
                     SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'Yu', 'You')
                     UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'loged', 'logged')
 
 
 

END

 

/*****************

---------

--  INSERT INTO PERM TABLE YES CAPS--

          --------

******************/

--very good

--http://vyaskn.tripod.com/code/propercase.txt

  
 

if SPELL_CHECK = 'y' AND HTML_FORMAT = 'n'
begin
  

Update tc
Set HOME_PAGE  = dbo.ProperCase(ts.HOME_PAGE )
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id


Update tc
Set CONTACT_PAGE= dbo.ProperCase(ts.CONTACT_PAGE)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id


Update tc
Set PRODUCT_PAGE= dbo.ProperCase(ts.pants)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id


Update tc
Set COMPARE_CHART = dbo.ProperCase(ts.COMPARE_CHART)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

 
Update tc
Set PRODUCT_1 = dbo.ProperCase(ts.PRODUCT_1)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id


Update tc
Set PRODUCT_2 = dbo.ProperCase(ts.PRODUCT_2)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

Update tc
Set PRODUCT_3 = dbo.ProperCase(ts.PRODUCT_3)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id
 

Update tc
Set PRODUCT_TRIAL = dbo.ProperCase(ts.PRODUCT_TRIAL)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id
 

Update tc
Set OVERVIEW = dbo.ProperCase(ts.OVERVIEW)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id
 

Update tc
Set SUPPORT_CENTER = dbo.ProperCase(ts.SUPPORT_CENTER)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id
 

Update tc
Set USER_FORUM = dbo.ProperCase(ts.USER_FORUM)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id


Update tc
Set USER_FORUM = dbo.ProperCase(ts.USER_FORUM)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

 
Update tc
Set UNINSTALL_UTILITY = dbo.ProperCase(ts.UNINSTALL_UTILITY)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id
 

Update tc
Set BLOG = dbo.ProperCase(ts.BLOG)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id


Update tc
Set LICENSE_CENTER = dbo.ProperCase(ts.LICENSE_CENTER)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

  
 Update tc 
 Set FAQ = dbo.ProperCase(ts.FAQ) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id

Update tc
Set CAREERS = dbo.ProperCase(ts.CAREERS)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id


Update tc
Set PRODUCT_ITEM_1 = dbo.ProperCase(ts.PRODUCT_ITEM_1)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id


Update tc
Set PRODUCT_ITEM_2 = dbo.ProperCase(ts.PRODUCT_ITEM_2)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id


Update tc
Set PRODUCT_ITEM_3 = dbo.ProperCase(ts.PRODUCT_ITEM_3)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id


end 

 

 

 

/*****************

---------

--  INSERT INTO PERM TABLE NO CAPITALS, NO HTML_FORMAT--

          --------

******************/

 
IF SPELL_CHECK = 'n' and HTML_FORMAT = 'n'
BEGIN
 

Update tc
Set HOME_PAGE  = ts.HOME_PAGE 
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

 

Update tc
Set CONTACT_PAGE= ts.CONTACT_PAGE
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

 
Update tc
Set PRODUCT_PAGE= ts.pants
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

 
Update tc
Set COMPARE_CHART = ts.COMPARE_CHART
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id


Update tc
Set PRODUCT_1 = ts.PRODUCT_1
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id
 

Update tc
Set PRODUCT_2 = ts.PRODUCT_2
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

 
Update tc
Set PRODUCT_3 = ts.PRODUCT_3
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id
 

Update tc
Set PRODUCT_TRIAL = ts.PRODUCT_TRIAL
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

 
Update tc
Set OVERVIEW = ts.OVERVIEW
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id
 

Update tc
Set SUPPORT_CENTER = ts.SUPPORT_CENTER
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id
 

Update tc
Set USER_FORUM = ts.USER_FORUM
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

 
Update tc
Set USER_FORUM = ts.USER_FORUM
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

 

Update tc
Set UNINSTALL_UTILITY = ts.UNINSTALL_UTILITY
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

 
Update tc
Set BLOG = ts.BLOG
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id
 

Update tc
Set LICENSE_CENTER = ts.LICENSE_CENTER
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

  
 Update tc 
 Set FAQ = ts.FAQ 
 FROM product tc
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id


Update tc
Set CAREERS = ts.CAREERS
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

Update tc
Set PRODUCT_ITEM_1 = ts.PRODUCT_ITEM_1
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id


Update tc
Set PRODUCT_ITEM_2 = ts.PRODUCT_ITEM_2
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id


Update tc
Set PRODUCT_ITEM_3 = ts.PRODUCT_ITEM_3
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

END



/*****************

---------

--   INSERT INTO PERM TABLE  CAPITALS & HTML FORMAT --

          --------

******************/




IF SPELL_CHECK = 'y' and HTML_FORMAT = 'y'
 BEGIN
 
  
  Update tc  
  Set HOME_PAGE  = dbo.InsertBr(dbo.ProperCase(ts.HOME_PAGE )),60)  
  FROM product tc  
   Join @temp_prod_after_cleanup_table ts  
  ON tc.wit_id = ts.wit_id  
   
 
 Update tc 
 Set CONTACT_PAGE= dbo.InsertBr(dbo.ProperCase(ts.CONTACT_PAGE)),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
   
 Update tc 
 Set PRODUCT_PAGE= dbo.InsertBr(dbo.ProperCase(ts.pants)),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
   
 
 Update tc 
 Set COMPARE_CHART = dbo.InsertBr(dbo.ProperCase(ts.COMPARE_CHART)),60)
  FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
   
 Update tc 
 Set PRODUCT_1 = dbo.InsertBr(dbo.ProperCase(ts.PRODUCT_1)),60) 
 FROM product tc
   Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
   
 
 Update tc 
 Set PRODUCT_2 = dbo.InsertBr(dbo.ProperCase(ts.PRODUCT_2)),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
   
 Update tc 
 Set PRODUCT_3 = dbo.InsertBr(dbo.ProperCase(ts.PRODUCT_3)),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
   
 
 Update tc 
 Set PRODUCT_TRIAL = dbo.InsertBr(dbo.ProperCase(ts.PRODUCT_TRIAL)),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
   
 Update tc 
 Set OVERVIEW = dbo.InsertBr(dbo.ProperCase(ts.OVERVIEW)),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
   
 Update tc 
 Set SUPPORT_CENTER = dbo.InsertBr(dbo.ProperCase(ts.SUPPORT_CENTER)),60) 
 FROM product tc
   Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
  
 
 Update tc 
 Set USER_FORUM = dbo.InsertBr(dbo.ProperCase(ts.USER_FORUM)),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
   
 
 Update tc 
 Set USER_FORUM = dbo.InsertBr(dbo.ProperCase(ts.USER_FORUM)),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
   
 
 Update tc 
 Set UNINSTALL_UTILITY = dbo.InsertBr(dbo.ProperCase(ts.UNINSTALL_UTILITY)),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
  
 
 Update tc 
 Set BLOG = dbo.InsertBr(dbo.ProperCase(ts.BLOG)),60) 
 FROM product tc
   Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
   
 Update tc 
 Set LICENSE_CENTER = dbo.InsertBr(dbo.ProperCase(ts.LICENSE_CENTER)),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
    
  
  Update tc  
  Set FAQ = dbo.InsertBr(dbo.ProperCase(ts.FAQ)),60)  
  FROM product tc  
   Join @temp_prod_after_cleanup_table ts  
   ON tc.wit_id = ts.wit_id
 
 
 Update tc 
 Set CAREERS = dbo.InsertBr(dbo.ProperCase(ts.CAREERS)),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
 
 Update tc 
 Set PRODUCT_ITEM_1 = dbo.InsertBr(dbo.ProperCase(ts.PRODUCT_ITEM_1)),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
 
 Update tc 
 Set PRODUCT_ITEM_2 = dbo.InsertBr(dbo.ProperCase(ts.PRODUCT_ITEM_2)),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
 
 Update tc 
 Set PRODUCT_ITEM_3 = dbo.InsertBr(dbo.ProperCase(ts.PRODUCT_ITEM_3)),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
 ON tc.wit_id = ts.wit_id
 

 
 END



/*****************

---------

--   INSERT INTO PERM TABLE  JUST HTML FORMAT --

          --------

******************/




IF SPELL_CHECK = 'n' AND HTML_FORMAT = 'y'
 BEGIN
 
 begin
 
   
 
 Update tc
 
 Set HOME_PAGE  = dbo.InsertBr((ts.HOME_PAGE ),60)
 
 FROM product tc
 
  Join @temp_prod_after_cleanup_table ts
 
  ON tc.wit_id = ts.wit_id
 
  
 
 Update tc
 
 Set CONTACT_PAGE= dbo.InsertBr((ts.CONTACT_PAGE),60)
 
 FROM product tc
 
  Join @temp_prod_after_cleanup_table ts
 
  ON tc.wit_id = ts.wit_id
 
  
 
 Update tc
 
 Set PRODUCT_PAGE= dbo.InsertBr((ts.pants),60)
 
 FROM product tc
 
  Join @temp_prod_after_cleanup_table ts
 
  ON tc.wit_id = ts.wit_id
 
  
 
 Update tc
 
 Set COMPARE_CHART = dbo.InsertBr((ts.COMPARE_CHART),60)
 
 FROM product tc
 
  Join @temp_prod_after_cleanup_table ts
 
  ON tc.wit_id = ts.wit_id
 
  
 
 Update tc
 
 Set PRODUCT_1 = dbo.InsertBr((ts.PRODUCT_1),60)
 
 FROM product tc
 
  Join @temp_prod_after_cleanup_table ts
 
  ON tc.wit_id = ts.wit_id
 
  
 
 Update tc
 
 Set PRODUCT_2 = dbo.InsertBr((ts.PRODUCT_2),60)
 
 FROM product tc
 
  Join @temp_prod_after_cleanup_table ts
 
  ON tc.wit_id = ts.wit_id
 
  
 
 Update tc
 
 Set PRODUCT_3 = dbo.InsertBr((ts.PRODUCT_3),60)
 
 FROM product tc
 
  Join @temp_prod_after_cleanup_table ts
 
  ON tc.wit_id = ts.wit_id
 
  
  
 
 Update tc
 
 Set PRODUCT_TRIAL = dbo.InsertBr((ts.PRODUCT_TRIAL),60)
 
 FROM product tc
 
  Join @temp_prod_after_cleanup_table ts
 
  ON tc.wit_id = ts.wit_id
 
  
 
 Update tc
 
 Set OVERVIEW = dbo.InsertBr((ts.OVERVIEW),60)
 
 FROM product tc
 
  Join @temp_prod_after_cleanup_table ts
 
  ON tc.wit_id = ts.wit_id
 
  
 
 Update tc
 
 Set SUPPORT_CENTER = dbo.InsertBr((ts.SUPPORT_CENTER),60)
 
 FROM product tc
 
  Join @temp_prod_after_cleanup_table ts
 
  ON tc.wit_id = ts.wit_id
 
  
 
 Update tc
 
 Set USER_FORUM = dbo.InsertBr((ts.USER_FORUM),60)
 
 FROM product tc
 
  Join @temp_prod_after_cleanup_table ts
 
  ON tc.wit_id = ts.wit_id
 
  
 
 Update tc 
 Set USER_FORUM = dbo.InsertBr((ts.USER_FORUM),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
  
 
 Update tc 
 Set UNINSTALL_UTILITY = dbo.InsertBr((ts.UNINSTALL_UTILITY),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
  
 
 Update tc 
 Set BLOG = dbo.InsertBr((ts.BLOG),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
  
 Update tc 
 Set LICENSE_CENTER = dbo.InsertBr((ts.LICENSE_CENTER),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
  
  
  
  
  Update tc  
  Set FAQ = dbo.InsertBr((ts.FAQ),60)  
  FROM product tc  
   Join @temp_prod_after_cleanup_table ts  
   ON tc.wit_id = ts.wit_id
 
 
 Update tc 
 Set CAREERS = dbo.InsertBr((ts.CAREERS),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
 
 Update tc 
 Set PRODUCT_ITEM_1 = dbo.InsertBr((ts.PRODUCT_ITEM_1),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
 
 Update tc 
 Set PRODUCT_ITEM_2 = dbo.InsertBr((ts.PRODUCT_ITEM_2),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
 
 Update tc 
 Set PRODUCT_ITEM_3 = dbo.InsertBr((ts.PRODUCT_ITEM_3),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
  
 END

 

/*****************

---------

--   CLEAN-UP  --

          --------

******************/

 

 


 

 

--WERE DONE!



 

 

 

/*****************

---------

--   NOTES  --

          --------

******************/

--TRIGGERS

--http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/A_3079-Writing-SQL-Server-Triggers-Part-1-After-Triggers.html?sfQueryTermInfo=1+10+30+function+sql+updat

--http://sqlservernation.com/blogs/tipweek/archive/2010/02/28/handling-trigger-logic.aspx

 

--PROPERCASE

--http://vyaskn.tripod.com/code/propercase.txt

 

-- UPDATE THE HOME_PAGE  FIELD IN PRODUCT

--Update p

--Set CONTACT_PAGE= f.CONTACT_PAGE

--FROM product p

--- Join temp_capital_table f 

--- ON f.CONTACT_PAGE= p.CONTACT_PAGE

--WHERE f.CONTACT_PAGE= (SELECT dbo.ProperCase(CONTACT_PAGE) from dbo.temp_capital_table)

 

-- UPDATE THE HOME_PAGE  FIELD IN PRODUCT

--Update p

--Set PRODUCT_2 = t.PRODUCT_2

--FROM product p

---JOIN @temp_prod_after_cleanup_table t

--- ON t.PRODUCT_2 = p.PRODUCT_2

 

 

/*********

END 

********/

Open in new window

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
GlobaLevelProgrammer

Author

Commented:
If you have some ideas to speed up performance that would be great...it does run thru 2 functions....and it is already add to the sql...
Lead Analyst
Top Expert 2010
Commented:
check this one.


-------------------------------------------------------------------------------------------------

 

/*****************

---------

--   BEGIN --

          --------

******************/

 


GO

/****** Object:   ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

 
 

-- _+_+_+_+_+

-- 

-- WE ARE READING PARAMETERS INTO SPROC

 

 

CREATE PROCEDURE [dbo].[sp_test_Product_Change_To_Product]    

DECLARE    
   @wit_id nvarchar(max) 
 , @SPELL_CHECK varchar(10)
 , @html_compliant varchar(10) 
 , @HOME_PAGE  nvarchar(max)   
 , @CONTACT_PAGEnvarchar(max) 
 , @PRODUCT_PAGEnvarchar(max)  
 , @COMPARE_CHART nvarchar(max) 
 , @PRODUCT_1 nvarchar(max) 
 , @PRODUCT_2 nvarchar(max) 				 ,
 , @PRODUCT_3 nvarchar(max) 
 , @PRODUCT_TRIAL nvarchar(max) 
 , @OVERVIEW nvarchar(max) 
 , @SUPPORT_CENTER nvarchar(max) 
 , @USER_FORUM nvarchar(max) 
 , @UNINSTALL_UTILITY nvarchar(max) 
 , @BLOG nvarchar(max) 
 , @LICENSE_CENTER nvarchar(max) 
 , @ABOUT nvarchar(max) 	
 , @BLOG nvarchar(max) 	
 , @FAQ nvarchar(max)			
 , @CAREERS  nvarchar(max) 	
 , @PRODUCT_ITEM_1 nvarchar(max)
 , @PRODUCT_ITEM_2 nvarchar(max)	
 , @PRODUCT_ITEM_3 nvarchar(max) 	
 , @CATEGORY_ID nvarchar(max)
)    

    
AS    

 SET NOCOUNT ON  

 
/*****************

---------

--   REPORT --

          --------

******************/

 
 DECLARE @date smalldatetime
 SET  @date = ISNULL(@date, getdate())
 

--THROW ALL THE JUNK INTO A REPORT TABLE...  

DECLARE @temp_report_table TABLE(
   DATE smalldatetime
 , WIT_ID nvarchar(max) 
 , HOME_PAGE  nvarchar(max)    
 , CONTACT_PAGE nvarchar(max)     
 , PRODUCT_PAGE nvarchar(max)   
 , COMPARE_CHART nvarchar(max)   
 , PRODUCT_1 nvarchar(max) 
 , PRODUCT_2 nvarchar(max) 
 , PRODUCT_3 nvarchar(max) 
 , PRODUCT_TRIAL nvarchar(max) 
 , OVERVIEW nvarchar(max) 
 , SUPPORT_CENTER nvarchar(max) 
 , USER_FORUM nvarchar(max) 
 , UNINSTALL_UTILITY nvarchar(max) 
 , BLOG nvarchar(max) 
 , LICENSE_CENTER   nvarchar(max)
 , ABOUT nvarchar(max) 	
 , BLOG nvarchar(max) 	
 , FAQ nvarchar(max)			
 , CAREERS  nvarchar(max) 	
 , PRODUCT_ITEM_1 nvarchar(max)
 , PRODUCT_ITEM_2 nvarchar(max)	
 , PRODUCT_ITEM_3 nvarchar(max) 	
 , CATEGORY_ID nvarchar(max)
  
 ) 
 
 
DECLARE @temp_prod_table TABLE(
   DATE smalldatetime
 , WIT_ID nvarchar(max) 
 , HOME_PAGE  nvarchar(max)    
 , CONTACT_PAGE nvarchar(max)     
 , PRODUCT_PAGE nvarchar(max)   
 , COMPARE_CHART nvarchar(max)   
 , PRODUCT_1 nvarchar(max) 
 , PRODUCT_2 nvarchar(max) 
 , PRODUCT_3 nvarchar(max) 
 , PRODUCT_TRIAL nvarchar(max) 
 , OVERVIEW nvarchar(max) 
 , SUPPORT_CENTER nvarchar(max) 
 , USER_FORUM nvarchar(max) 
 , UNINSTALL_UTILITY nvarchar(max) 
 , BLOG nvarchar(max) 
 , LICENSE_CENTER   nvarchar(max)
 , ABOUT nvarchar(max) 	
 , BLOG nvarchar(max) 	
 , FAQ nvarchar(max)			
 , CAREERS  nvarchar(max) 	
 , PRODUCT_ITEM_1 nvarchar(max)
 , PRODUCT_ITEM_2 nvarchar(max)	
 , PRODUCT_ITEM_3 nvarchar(max) 	
 , CATEGORY_ID nvarchar(max)
  
 ) 

 
  INSERT INTO @temp_prod_table (
   DATE
 , WIT_ID 
 , HOME_PAGE      
 , CONTACT_PAGE     
 , PRODUCT_PAGE   
 , COMPARE_CHART  
 , PRODUCT_1 
 , PRODUCT_2 
 , PRODUCT_3 
 , PRODUCT_TRIAL 
 , OVERVIEW 
 , SUPPORT_CENTER 
 , USER_FORUM 
 , UNINSTALL_UTILITY 
 , BLOG 
 , LICENSE_CENTER
 , ABOUT 	
 , BLOG 	
 , FAQ 			
 , CAREERS  	
 , PRODUCT_ITEM_1 
 , PRODUCT_ITEM_2 	
 , PRODUCT_ITEM_3 	
 , CATEGORY_ID 
  
 )
 
 VALUES
(    
   @DATE
 , @WIT_ID
 , @HOME_PAGE  
 , @CONTACT_PAGE
 , @PRODUCT_PAGE 
 , @COMPARE_CHART 
 , @PRODUCT_1 
 , @PRODUCT_2 
 , @PRODUCT_3 
 , @PRODUCT_TRIAL 
 , @OVERVIEW 
 , @SUPPORT_CENTER 
 , @USER_FORUM 
 , @UNINSTALL_UTILITY 
 , @BLOG 
 , @LICENSE_CENTER  
 , @ABOUT 	
 , @BLOG 	
 , @FAQ 			
 , @CAREERS  	
 , @PRODUCT_ITEM_1 
 , @PRODUCT_ITEM_2 	
 , @PRODUCT_ITEM_3 	
 , @CATEGORY_ID 
   
) 
 
 
 
 ---SORT DATA---



INSERT INTO @temp_report_table (HOME_PAGE)
SELECT CASE 
      WHEN HOME_PAGE  like '%shooter%' THEN 'red' 
      WHEN HOME_PAGE  like '%fruit%' THEN 'blue' 
      WHEN HOME_PAGE  like '%block%' THEN 'green'
      WHEN HOME_PAGE  like '%cannot%' THEN 'violet'
      WHEN HOME_PAGE  like '%dack%' THEN 'pink'
      WHEN HOME_PAGE  like '%believing%' THEN 'envy'
      WHEN HOME_PAGE  like '%always%' THEN 'grey'
      WHEN HOME_PAGE  like '%fruiter%' THEN 'blueer' 
      WHEN HOME_PAGE  like '%also%' THEN 'grey'
      WHEN HOME_PAGE  like '%dungess%' THEN 'red' END                         

FROM @temp_prod_table 

 

INSERT INTO @temp_report_table (CONTACT_PAGE)
SELECT CASE 
      WHEN CONTACT_PAGE like '%shooter%' THEN 'red' 
      WHEN CONTACT_PAGE like '%fruit%' THEN 'blue' 
      WHEN CONTACT_PAGE like '%block%' THEN 'green'
      WHEN CONTACT_PAGE like '%cannot%' THEN 'violet'
      WHEN CONTACT_PAGE like '%dack%' THEN 'pink'
      WHEN CONTACT_PAGE like '%believing%' THEN 'envy'
      WHEN CONTACT_PAGE like '%always%' THEN 'grey'
      WHEN CONTACT_PAGE like '%fruiter%' THEN 'blueer' 
      WHEN CONTACT_PAGE like '%also%' THEN 'grey'
      WHEN CONTACT_PAGE like '%dungess%' THEN 'red' END                        

FROM @temp_prod_table 

 

INSERT INTO @temp_report_table (PRODUCT_PAGE)

SELECT CASE 
      WHEN PRODUCT_PAGE like '%shooter%' THEN 'red' 
      WHEN PRODUCT_PAGE like '%fruit%' THEN 'blue' 
      WHEN PRODUCT_PAGE like '%block%' THEN 'green'
      WHEN PRODUCT_PAGE like '%cannot%' THEN 'violet'
      WHEN PRODUCT_PAGE like '%dack%' THEN 'pink'
      WHEN PRODUCT_PAGE like '%believing%' THEN 'envy'
      WHEN PRODUCT_PAGE like '%always%' THEN 'grey'
      WHEN PRODUCT_PAGE like '%fruiter%' THEN 'blueer' 
      WHEN PRODUCT_PAGE like '%also%' THEN 'grey'
      WHEN PRODUCT_PAGE like '%dungess%' THEN 'red' END                      

FROM @temp_prod_table 

 

INSERT INTO @temp_report_table (COMPARE_CHART)

SELECT CASE 
      WHEN COMPARE_CHART like  '%shooter%' THEN 'red' 
      WHEN COMPARE_CHART like  '%fruit%' THEN 'blue' 
      WHEN COMPARE_CHART like  '%block%' THEN 'green'
      WHEN COMPARE_CHART like  '%cannot%' THEN 'violet'
      WHEN COMPARE_CHART like  '%dack%' THEN 'pink'
      WHEN COMPARE_CHART like  '%believing%' THEN 'envy'
      WHEN COMPARE_CHART like  '%always%' THEN 'grey'
      WHEN COMPARE_CHART like  '%fruiter%' THEN 'blueer' 
      WHEN COMPARE_CHART like  '%also%' THEN 'grey'
      WHEN COMPARE_CHART like  '%dungess%' THEN 'red' END                      

FROM @temp_prod_table 

 

INSERT INTO @temp_report_table (PRODUCT_1)

SELECT CASE 
      WHEN PRODUCT_1 like  '%shooter%' THEN 'red' 
      WHEN PRODUCT_1 like  '%fruit%' THEN 'blue' 
      WHEN PRODUCT_1 like  '%block%' THEN 'green'
      WHEN PRODUCT_1 like  '%cannot%' THEN 'violet'
      WHEN PRODUCT_1 like  '%dack%' THEN 'pink'
      WHEN PRODUCT_1 like  '%believing%' THEN 'envy'
      WHEN PRODUCT_1 like  '%always%' THEN 'grey'
      WHEN PRODUCT_1 like  '%fruiter%' THEN 'blueer' 
      WHEN PRODUCT_1 like  '%also%' THEN 'grey'
      WHEN PRODUCT_1 like  '%dungess%' THEN 'red' END                       

FROM @temp_prod_table 

 

INSERT INTO @temp_report_table (PRODUCT_2)

SELECT CASE 
      WHEN PRODUCT_2 like  '%shooter%' THEN 'red' 
      WHEN PRODUCT_2 like  '%fruit%' THEN 'blue' 
      WHEN PRODUCT_2 like  '%block%' THEN 'green'
      WHEN PRODUCT_2 like  '%cannot%' THEN 'violet'
      WHEN PRODUCT_2 like  '%dack%' THEN 'pink'
      WHEN PRODUCT_2 like  '%believing%' THEN 'envy'
      WHEN PRODUCT_2 like  '%always%' THEN 'grey'
      WHEN PRODUCT_2 like  '%fruiter%' THEN 'blueer' 
      WHEN PRODUCT_2 like  '%also%' THEN 'grey'
      WHEN PRODUCT_2 like  '%dungess%' THEN 'red' END                         

FROM @temp_prod_table 

 

INSERT INTO @temp_report_table (PRODUCT_3)

SELECT CASE 
      WHEN PRODUCT_3 like  '%shooter%' THEN 'red' 
      WHEN PRODUCT_3 like  '%fruit%' THEN 'blue' 
      WHEN PRODUCT_3 like  '%block%' THEN 'green'
      WHEN PRODUCT_3 like  '%cannot%' THEN 'violet'
      WHEN PRODUCT_3 like  '%dack%' THEN 'pink'
      WHEN PRODUCT_3 like  '%believing%' THEN 'envy'
      WHEN PRODUCT_3 like  '%always%' THEN 'grey'
      WHEN PRODUCT_3 like  '%fruiter%' THEN 'blueer' 
      WHEN PRODUCT_3 like  '%also%' THEN 'grey'
      WHEN PRODUCT_3 like  '%dungess%' THEN 'red' END                   

FROM @temp_prod_table 

 

INSERT INTO @temp_report_table (PRODUCT_TRIAL)

SELECT CASE 
      WHEN PRODUCT_TRIAL like  '%shooter%' THEN 'red' 
      WHEN PRODUCT_TRIAL like  '%fruit%' THEN 'blue' 
      WHEN PRODUCT_TRIAL like  '%block%' THEN 'green'
      WHEN PRODUCT_TRIAL like  '%cannot%' THEN 'violet'
      WHEN PRODUCT_TRIAL like  '%dack%' THEN 'pink'
      WHEN PRODUCT_TRIAL like  '%believing%' THEN 'envy'
      WHEN PRODUCT_TRIAL like  '%always%' THEN 'grey'
      WHEN PRODUCT_TRIAL like  '%fruiter%' THEN 'blueer' 
      WHEN PRODUCT_TRIAL like  '%also%' THEN 'grey'
      WHEN PRODUCT_TRIAL like  '%dungess%' THEN 'red' END                         

FROM @temp_prod_table 

 

INSERT INTO @temp_report_table (OVERVIEW)

SELECT CASE 
      WHEN OVERVIEW like  '%shooter%' THEN 'red' 
      WHEN OVERVIEW like  '%fruit%' THEN 'blue' 
      WHEN OVERVIEW like  '%block%' THEN 'green'
      WHEN OVERVIEW like  '%cannot%' THEN 'violet'
      WHEN OVERVIEW like  '%dack%' THEN 'pink'
      WHEN OVERVIEW like  '%believing%' THEN 'envy'
      WHEN OVERVIEW like  '%always%' THEN 'grey'
      WHEN OVERVIEW like  '%fruiter%' THEN 'blueer' 
      WHEN OVERVIEW like  '%also%' THEN 'grey'
      WHEN OVERVIEW like  '%dungess%' THEN 'red' END                      

FROM @temp_prod_table 

 

INSERT INTO @temp_report_table (SUPPORT_CENTER)

SELECT CASE 
      WHEN SUPPORT_CENTER like  '%shooter%' THEN 'red' 
      WHEN SUPPORT_CENTER like  '%fruit%' THEN 'blue' 
      WHEN SUPPORT_CENTER like  '%block%' THEN 'green'
      WHEN SUPPORT_CENTER like  '%cannot%' THEN 'violet'
      WHEN SUPPORT_CENTER like  '%dack%' THEN 'pink'
      WHEN SUPPORT_CENTER like  '%believing%' THEN 'envy'
      WHEN SUPPORT_CENTER like  '%always%' THEN 'grey'
      WHEN SUPPORT_CENTER like  '%fruiter%' THEN 'blueer' 
      WHEN SUPPORT_CENTER like  '%also%' THEN 'grey'
      WHEN SUPPORT_CENTER like  '%dungess%' THEN 'red' END                      

FROM @temp_prod_table 

 

INSERT INTO @temp_report_table (USER_FORUM)

SELECT CASE 

      WHEN USER_FORUM like  '%shooter%' THEN 'red' 
      WHEN USER_FORUM like  '%fruit%' THEN 'blue' 
      WHEN USER_FORUM like  '%block%' THEN 'green'
      WHEN USER_FORUM like  '%cannot%' THEN 'violet'
      WHEN USER_FORUM like  '%dack%' THEN 'pink'
      WHEN USER_FORUM like  '%believing%' THEN 'envy'
      WHEN USER_FORUM like  '%always%' THEN 'grey'
      WHEN USER_FORUM like  '%fruiter%' THEN 'blueer' 
      WHEN USER_FORUM like  '%also%' THEN 'grey'
      WHEN USER_FORUM like  '%dungess%' THEN 'red' END                    

FROM @temp_prod_table 

 

INSERT INTO @temp_report_table (UNINSTALL_UTILITY)

SELECT CASE 
      WHEN UNINSTALL_UTILITY like  '%shooter%' THEN 'red' 
      WHEN UNINSTALL_UTILITY like  '%fruit%' THEN 'blue' 
      WHEN UNINSTALL_UTILITY like  '%block%' THEN 'green'
      WHEN UNINSTALL_UTILITY like  '%cannot%' THEN 'violet'
      WHEN UNINSTALL_UTILITY like  '%dack%' THEN 'pink'
      WHEN UNINSTALL_UTILITY like  '%believing%' THEN 'envy'
      WHEN UNINSTALL_UTILITY like  '%always%' THEN 'grey'
      WHEN UNINSTALL_UTILITY like  '%fruiter%' THEN 'blueer' 
      WHEN UNINSTALL_UTILITY like  '%also%' THEN 'grey'
      WHEN UNINSTALL_UTILITY like  '%dungess%' THEN 'red' END                       

FROM @temp_prod_table

 

INSERT INTO @temp_report_table (BLOG)

SELECT CASE 
      WHEN BLOG like  '%shooter%' THEN 'red' 
      WHEN BLOG like  '%fruit%' THEN 'blue' 
      WHEN BLOG like  '%block%' THEN 'green'
      WHEN BLOG like  '%cannot%' THEN 'violet'
      WHEN BLOG like  '%dack%' THEN 'pink'
      WHEN BLOG like  '%believing%' THEN 'envy'
      WHEN BLOG like  '%always%' THEN 'grey'
      WHEN BLOG like  '%fruiter%' THEN 'blueer' 
      WHEN BLOG like  '%also%' THEN 'grey'
      WHEN BLOG like  '%dungess%' THEN 'red' END                     

FROM @temp_prod_table

 

INSERT INTO @temp_report_table (FAQ)

SELECT CASE 

      WHEN FAQ like  '%shooter%' THEN 'red' 
      WHEN FAQ like  '%fruit%' THEN 'blue' 
      WHEN FAQ like  '%block%' THEN 'green'
      WHEN FAQ like  '%cannot%' THEN 'violet'
      WHEN FAQ like  '%dack%' THEN 'pink'
      WHEN FAQ like  '%believing%' THEN 'envy'
      WHEN FAQ like  '%always%' THEN 'grey'
      WHEN FAQ like  '%fruiter%' THEN 'blueer' 
      WHEN FAQ like  '%also%' THEN 'grey'
      WHEN FAQ like  '%dungess%' THEN 'red' END                       

FROM @temp_prod_table 


INSERT INTO @temp_report_table (CAREERS)

SELECT CASE 

      WHEN CAREERS like  '%shooter%' THEN 'red' 
      WHEN CAREERS like  '%fruit%' THEN 'blue' 
      WHEN CAREERS like  '%block%' THEN 'green'
      WHEN CAREERS like  '%cannot%' THEN 'violet'
      WHEN CAREERS like  '%dack%' THEN 'pink'
      WHEN CAREERS like  '%believing%' THEN 'envy'
      WHEN CAREERS like  '%always%' THEN 'grey'
      WHEN CAREERS like  '%fruiter%' THEN 'blueer' 
      WHEN CAREERS like  '%also%' THEN 'grey'
      WHEN CAREERS like  '%dungess%' THEN 'red' END                       

FROM @temp_prod_table 


INSERT INTO @temp_report_table (PRODUCT_ITEM_1)

SELECT CASE 

      WHEN PRODUCT_ITEM_1 like  '%shooter%' THEN 'red' 
      WHEN PRODUCT_ITEM_1 like  '%fruit%' THEN 'blue' 
      WHEN PRODUCT_ITEM_1 like  '%block%' THEN 'green'
      WHEN PRODUCT_ITEM_1 like  '%cannot%' THEN 'violet'
      WHEN PRODUCT_ITEM_1 like  '%dack%' THEN 'pink'
      WHEN PRODUCT_ITEM_1 like  '%believing%' THEN 'envy'
      WHEN PRODUCT_ITEM_1 like  '%always%' THEN 'grey'
      WHEN PRODUCT_ITEM_1 like  '%fruiter%' THEN 'blueer' 
      WHEN PRODUCT_ITEM_1 like  '%also%' THEN 'grey'
      WHEN PRODUCT_ITEM_1 like  '%dungess%' THEN 'red' END                       

FROM @temp_prod_table 



INSERT INTO @temp_report_table (PRODUCT_ITEM_2)

SELECT CASE 

      WHEN PRODUCT_ITEM_2 like  '%shooter%' THEN 'red' 
      WHEN PRODUCT_ITEM_2 like  '%fruit%' THEN 'blue' 
      WHEN PRODUCT_ITEM_2 like  '%block%' THEN 'green'
      WHEN PRODUCT_ITEM_2 like  '%cannot%' THEN 'violet'
      WHEN PRODUCT_ITEM_2 like  '%dack%' THEN 'pink'
      WHEN PRODUCT_ITEM_2 like  '%believing%' THEN 'envy'
      WHEN PRODUCT_ITEM_2 like  '%always%' THEN 'grey'
      WHEN PRODUCT_ITEM_2 like  '%fruiter%' THEN 'blueer' 
      WHEN PRODUCT_ITEM_2 like  '%also%' THEN 'grey'
      WHEN PRODUCT_ITEM_2 like  '%dungess%' THEN 'red' END                       

FROM @temp_prod_table 


INSERT INTO @temp_report_table (PRODUCT_ITEM_3)

SELECT CASE 

      WHEN PRODUCT_ITEM_3 like  '%shooter%' THEN 'red' 
      WHEN PRODUCT_ITEM_3 like  '%fruit%' THEN 'blue' 
      WHEN PRODUCT_ITEM_3 like  '%block%' THEN 'green'
      WHEN PRODUCT_ITEM_3 like  '%cannot%' THEN 'violet'
      WHEN PRODUCT_ITEM_3 like  '%dack%' THEN 'pink'
      WHEN PRODUCT_ITEM_3 like  '%believing%' THEN 'envy'
      WHEN PRODUCT_ITEM_3 like  '%always%' THEN 'grey'
      WHEN PRODUCT_ITEM_3 like  '%fruiter%' THEN 'blueer' 
      WHEN PRODUCT_ITEM_3 like  '%also%' THEN 'grey'
      WHEN PRODUCT_ITEM_3 like  '%dungess%' THEN 'red' END                       

FROM @temp_prod_table 



--IF THERE IS JUNK SEND TO REPORT TABLE

IF @temp_report_table not NULL
BEGIN
 INSERT INTO client_monitor_table
 SELECT * 
 FROM  @temp_report_table
 WHERE wit_id = @wit_id

END

 

 

/*****************

---------

--   PRODUCT  --

          --------

******************/

 

 

--CLEAN UP THE LANGUAGE...


 
 DECLARE @temp_prod_after_cleanup_table TABLE(
    DATE smalldatetime, 
  , WIT_ID nvarchar(max) 
  , HOME_PAGE  nvarchar(max)    
  , CONTACT_PAGE nvarchar(max)     
  , PRODUCT_PAGE nvarchar(max)   
  , COMPARE_CHART nvarchar(max)   
  , PRODUCT_1 nvarchar(max) 
  , PRODUCT_2 nvarchar(max) 
  , PRODUCT_3 nvarchar(max) 
  , PRODUCT_TRIAL nvarchar(max) 
  , OVERVIEW nvarchar(max) 
  , SUPPORT_CENTER nvarchar(max) 
  , USER_FORUM nvarchar(max) 
  , UNINSTALL_UTILITY nvarchar(max) 
  , BLOG nvarchar(max) 
  , LICENSE_CENTER   nvarchar(max)
  , ABOUT nvarchar(max)  	
  , FAQ nvarchar(max)			
  , CAREERS  nvarchar(max) 	
  , PRODUCT_ITEM_1 nvarchar(max)
  , PRODUCT_ITEM_2 nvarchar(max)	
  , PRODUCT_ITEM_3 nvarchar(max) 	
  , CATEGORY_ID nvarchar(max)
 
    

INSERT INTO @temp_prod_after_cleanup_table (HOME_PAGE )
SELECT CASE 
             WHEN HOME_PAGE  like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN HOME_PAGE  like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN HOME_PAGE  like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN HOME_PAGE  like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN HOME_PAGE  like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN HOME_PAGE  like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN HOME_PAGE  like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN HOME_PAGE  like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN HOME_PAGE  like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN HOME_PAGE  like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                        

FROM @temp_prod_table 

 

INSERT INTO @temp_prod_after_cleanup_table (CONTACT_PAGE)
SELECT CASE 
            WHEN CONTACT_PAGE like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN CONTACT_PAGE like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN CONTACT_PAGE like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN CONTACT_PAGE like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN CONTACT_PAGE like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN CONTACT_PAGE like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN CONTACT_PAGE like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN CONTACT_PAGE like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN CONTACT_PAGE like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN CONTACT_PAGE like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                         

FROM @temp_prod_table

 

INSERT INTO @temp_prod_after_cleanup_table (PRODUCT_PAGE)
SELECT CASE 
             WHEN PRODUCT_PAGE like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_PAGE like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_PAGE like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_PAGE like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_PAGE like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_PAGE like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_PAGE like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_PAGE like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_PAGE like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_PAGE like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                    

FROM @temp_prod_table 

 

INSERT INTO @temp_prod_after_cleanup_table (COMPARE_CHART)
SELECT CASE 
             WHEN COMPARE_CHART like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN COMPARE_CHART like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN COMPARE_CHART like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN COMPARE_CHART like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN COMPARE_CHART like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN COMPARE_CHART like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN COMPARE_CHART like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN COMPARE_CHART like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN COMPARE_CHART like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN COMPARE_CHART like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                      

FROM @temp_prod_table 

 

INSERT INTO @temp_prod_after_cleanup_table (PRODUCT_1)
SELECT CASE 
             WHEN PRODUCT_1 like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_1 like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_1 like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_1 like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_1 like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_1 like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_1 like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_1 like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_1 like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_1 like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                     

FROM @temp_prod_table 

 

INSERT INTO @temp_prod_after_cleanup_table (PRODUCT_2)
SELECT CASE 
             WHEN PRODUCT_2 like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_2 like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_2 like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_2 like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_2 like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_2 like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_2 like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_2 like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_2 like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_2 like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                     

FROM @temp_prod_table 

 

INSERT INTO @temp_prod_after_cleanup_table (PRODUCT_3)
SELECT CASE 
             WHEN PRODUCT_3 like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_3 like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_3 like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_3 like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_3 like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_3 like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_3 like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_3 like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_3 like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_3 like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                          

FROM @temp_prod_table

 

INSERT INTO @temp_prod_after_cleanup_table (PRODUCT_TRIAL)
SELECT CASE 
             WHEN PRODUCT_TRIAL like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_TRIAL like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_TRIAL like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_TRIAL like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_TRIAL like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_TRIAL like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_TRIAL like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_TRIAL like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_TRIAL like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_TRIAL like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                     

FROM @temp_prod_table 

 

INSERT INTO @temp_prod_after_cleanup_table (OVERVIEW)
SELECT CASE 
           WHEN OVERVIEW like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN OVERVIEW like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN OVERVIEW like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN OVERVIEW like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN OVERVIEW like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN OVERVIEW like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN OVERVIEW like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN OVERVIEW like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN OVERVIEW like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN OVERVIEW like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                    

FROM @temp_prod_table 

 

INSERT INTO @temp_prod_after_cleanup_table (SUPPORT_CENTER)
SELECT CASE 
            WHEN SUPPORT_CENTER like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN SUPPORT_CENTER like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN SUPPORT_CENTER like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN SUPPORT_CENTER like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN SUPPORT_CENTER like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN SUPPORT_CENTER like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN SUPPORT_CENTER like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN SUPPORT_CENTER like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN SUPPORT_CENTER like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN SUPPORT_CENTER like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                       

FROM @temp_prod_table 

 

INSERT INTO @temp_prod_after_cleanup_table (USER_FORUM)
SELECT CASE 
             WHEN USER_FORUM like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN USER_FORUM like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN USER_FORUM like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN USER_FORUM like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN USER_FORUM like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN USER_FORUM like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN USER_FORUM like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN USER_FORUM like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN USER_FORUM like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN USER_FORUM like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                    

FROM @temp_prod_table

 

INSERT INTO @temp_prod_after_cleanup_table (UNINSTALL_UTILITY)
SELECT CASE 
             WHEN UNINSTALL_UTILITY like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN UNINSTALL_UTILITY like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN UNINSTALL_UTILITY like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN UNINSTALL_UTILITY like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN UNINSTALL_UTILITY like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN UNINSTALL_UTILITY like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN UNINSTALL_UTILITY like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN UNINSTALL_UTILITY like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN UNINSTALL_UTILITY like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN UNINSTALL_UTILITY like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                       

FROM @temp_prod_table
 

INSERT INTO @temp_prod_after_cleanup_table (BLOG)
SELECT CASE 
             WHEN BLOG like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN BLOG like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN BLOG like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN BLOG like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN BLOG like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN BLOG like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN BLOG like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN BLOG like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN BLOG like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN BLOG like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                    

FROM @temp_prod_table
 

INSERT INTO @temp_prod_after_cleanup_table (LICENSE_CENTER)
SELECT CASE 
            WHEN LICENSE_CENTER like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN LICENSE_CENTER like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN LICENSE_CENTER like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN LICENSE_CENTER like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN LICENSE_CENTER like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN LICENSE_CENTER like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN LICENSE_CENTER like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN LICENSE_CENTER like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN LICENSE_CENTER like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN LICENSE_CENTER like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                       

FROM @temp_prod_table

 
INSERT INTO @temp_prod_after_cleanup_table (FAQ)
SELECT CASE 
            WHEN FAQ like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN FAQ like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN FAQ like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN FAQ like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN FAQ like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN FAQ like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN FAQ like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN FAQ like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN FAQ like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN FAQ like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                   

FROM @temp_prod_table


INSERT INTO @temp_prod_after_cleanup_table (CAREERS)
SELECT CASE 
            WHEN CAREERS like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN CAREERS like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN CAREERS like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN CAREERS like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN CAREERS like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN CAREERS like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN CAREERS like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN CAREERS like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN CAREERS like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN CAREERS like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                     

FROM @temp_prod_table


INSERT INTO @temp_prod_after_cleanup_table (PRODUCT_ITEM_1)
SELECT CASE 
            WHEN PRODUCT_ITEM_1 like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_ITEM_1 like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_ITEM_1 like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_1 like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_1 like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_1 like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_1 like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_1 like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_1 like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_1 like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                     

FROM @temp_prod_table

INSERT INTO @temp_prod_after_cleanup_table (PRODUCT_ITEM_2)
SELECT CASE 
             WHEN PRODUCT_ITEM_2 like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_ITEM_2 like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_ITEM_2 like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_2 like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_2 like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_2 like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_2 like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_2 like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_2 like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_2 like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                    

FROM @temp_prod_table

INSERT INTO @temp_prod_after_cleanup_table (PRODUCT_ITEM_3)
SELECT CASE 
         WHEN PRODUCT_ITEM_3 like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_ITEM_3 like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_ITEM_3 like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_3 like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_3 like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_3 like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_3 like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_3 like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_3 like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_3 like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                       

FROM @temp_prod_table


/*****************

---------

--   SPELL CHECK  --

          --------

******************/

 

-- IF SPELL CHECK COLUMN IS CHECKED THEN PROCEED ELSE GET OUT OF SPROC

-- TURN:

-- 'Wlcome! Yu are now loged into this ste. So glad you are here. 
--   We have a lot of great paes to vist: emil, abut, hme, fq, contct us, 
--   prducts, spport, cstomer srvice, sles team, stff.'


-- INTO:
-- 'Welcome! You are now logged into this site. So glad you are here. 
--   We have a lot of great pages to visit: email, about, home, faq, contact us, 
--   products, support, customer service, sales team, staff.'
 

if @SPELL_CHECK = 'y' 

BEGIN 

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'stff', 'staff')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'sles team', 'sales team')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'cstomer srvice', 'customer service')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'spport', 'support')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'prducts', 'products')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'contct us', 'contact us')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'fq', 'FAQ')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'hme', 'home')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'abut', 'about')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'emil', 'email')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'vist', 'visit')  
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'paes', 'pages') 
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'Wlcome!', 'Welcome!') 
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'Yu', 'You')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'loged', 'logged')

 

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'stff', 'staff')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'sles team', 'sales team')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'cstomer srvice', 'customer service')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'spport', 'support')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'prducts', 'products')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'contct us', 'contact us')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'fq', 'FAQ')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'hme', 'home')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'abut', 'about')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'emil', 'email')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'vist', 'visit')  
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'paes', 'pages') 

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'Wlcome!', 'Welcome!')    
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'Yu', 'You')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'loged', 'logged') 

 

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'stff', 'staff')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'sles team', 'sales team')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'cstomer srvice', 'customer service')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'spport', 'support')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'prducts', 'products')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'contct us', 'contact us')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'fq', 'FAQ')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'hme', 'home')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'abut', 'about')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'emil', 'email')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'vist', 'visit')  
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'paes', 'pages')     

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'Wlcome!', 'Welcome!')  
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'Yu', 'You')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'loged', 'logged')

 

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'stff', 'staff')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'sles team', 'sales team')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'cstomer srvice', 'customer service')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'spport', 'support')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'prducts', 'products')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'contct us', 'contact us')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'fq', 'FAQ')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'hme', 'home')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'abut', 'about')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'emil', 'email')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'vist', 'visit')    

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'paes', 'pages')        

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'Wlcome!', 'Welcome!')    

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'Yu', 'You')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'loged', 'logged')

 
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'stff', 'staff')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'sles team', 'sales team')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'cstomer srvice', 'customer service')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'spport', 'support')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'prducts', 'products')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'contct us', 'contact us')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'fq', 'FAQ')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'hme', 'home')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'abut', 'about')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'emil', 'email')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'vist', 'visit')  

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'paes', 'pages')        

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'Wlcome!', 'Welcome!')   

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'Yu', 'You')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'loged', 'logged')

 

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'stff', 'staff')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'sles team', 'sales team')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'cstomer srvice', 'customer service')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'spport', 'support')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'prducts', 'products')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'contct us', 'contact us')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'fq', 'FAQ')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'hme', 'home')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'abut', 'about')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'emil', 'email')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'vist', 'visit')  
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'paes', 'pages')      

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'Wlcome!', 'Welcome!')  
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'Yu', 'You')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'loged', 'logged')

 

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'stff', 'staff')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'sles team', 'sales team')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'cstomer srvice', 'customer service')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'spport', 'support')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'prducts', 'products')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'contct us', 'contact us')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'fq', 'FAQ')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'hme', 'home')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'abut', 'about')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'emil', 'email')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'vist', 'visit')  
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'paes', 'pages')       

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'Wlcome!', 'Welcome!')  
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'Yu', 'You')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'loged', 'logged')
 


                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'stff', 'staff')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'sles team', 'sales team')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'cstomer srvice', 'customer service')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'spport', 'support')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'prducts', 'products')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'contct us', 'contact us')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'fq', 'FAQ')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'hme', 'home')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'abut', 'about')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'emil', 'email')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'vist', 'visit')      
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'paes', 'pages')          

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'Wlcome!', 'Welcome!')    

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'Yu', 'You')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'loged', 'logged')
 

 

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   OVERVIEW = REPLACE(OVERVIEW, 'stff', 'staff')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   OVERVIEW = REPLACE(OVERVIEW, 'sles team', 'sales team')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   OVERVIEW = REPLACE(OVERVIEW, 'cstomer srvice', 'customer service')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   OVERVIEW = REPLACE(OVERVIEW, 'spport', 'support')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   OVERVIEW = REPLACE(OVERVIEW, 'prducts', 'products')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   OVERVIEW = REPLACE(OVERVIEW, 'contct us', 'contact us')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   OVERVIEW = REPLACE(OVERVIEW, 'fq', 'FAQ')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   OVERVIEW = REPLACE(OVERVIEW, 'hme', 'home')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   OVERVIEW = REPLACE(OVERVIEW, 'abut', 'about')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   OVERVIEW = REPLACE(OVERVIEW, 'emil', 'email')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   OVERVIEW = REPLACE(OVERVIEW, 'vist', 'visit')     

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   OVERVIEW = REPLACE(OVERVIEW, 'paes', 'pages')          

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   OVERVIEW = REPLACE(OVERVIEW, 'Wlcome!', 'Welcome!')      
                  UPDATE  @temp_prod_after_cleanup_table

                  SET   OVERVIEW = REPLACE(OVERVIEW, 'Yu', 'You')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   OVERVIEW = REPLACE(OVERVIEW, 'loged', 'logged')
 

 

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'stff', 'staff')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'sles team', 'sales team')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'cstomer srvice', 'customer service')

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'spport', 'support')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'prducts', 'products')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'contct us', 'contact us')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'fq', 'FAQ')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'hme', 'home')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'abut', 'about')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'emil', 'email')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'vist', 'visit')    
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'paes', 'pages')         

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'Wlcome!', 'Welcome!')    
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'Yu', 'You')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'loged', 'logged')

 
 

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'stff', 'staff')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'sles team', 'sales team')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'cstomer srvice', 'customer service')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'spport', 'support')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'prducts', 'products')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'contct us', 'contact us')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'fq', 'FAQ')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'hme', 'home')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'abut', 'about')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'emil', 'email')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'vist', 'visit')  
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'paes', 'pages')       

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'Wlcome!', 'Welcome!')  
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'Yu', 'You')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'loged', 'logged')
 

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'stff', 'staff')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'sles team', 'sales team')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'cstomer srvice', 'customer service')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'spport', 'support')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'prducts', 'products')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'contct us', 'contact us')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'fq', 'FAQ')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'hme', 'home')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'abut', 'about')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'emil', 'email')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'vist', 'visit')  
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'paes', 'pages')       

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'Wlcome!', 'Welcome!')  
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'Yu', 'You')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'loged', 'logged')

 

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'stff', 'staff')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'sles team', 'sales team')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'cstomer srvice', 'customer service')

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'spport', 'support')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'prducts', 'products')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'contct us', 'contact us')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'fq', 'FAQ')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'hme', 'home')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'abut', 'about')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'emil', 'email')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'vist', 'visit')   

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'paes', 'pages')         

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'Wlcome!', 'Welcome!')   

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'Yu', 'You')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'loged', 'logged') 

 

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'stff', 'staff')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'sles team', 'sales team')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'cstomer srvice', 'customer service')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'spport', 'support')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'prducts', 'products')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'contct us', 'contact us')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'fq', 'FAQ')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'hme', 'home')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'abut', 'about')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'emil', 'email')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'vist', 'visit')  
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'paes', 'pages')       

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'Wlcome!', 'Welcome!')  
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'Yu', 'You')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'loged', 'logged')

 
 
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   BLOG  = REPLACE(BLOG , 'stff', 'staff')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   BLOG  = REPLACE(BLOG , 'sles team', 'sales team')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   BLOG  = REPLACE(BLOG , 'cstomer srvice', 'customer service')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   BLOG  = REPLACE(BLOG , 'spport', 'support')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   BLOG  = REPLACE(BLOG , 'prducts', 'products')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   BLOG  = REPLACE(BLOG , 'contct us', 'contact us')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   BLOG  = REPLACE(BLOG , 'fq', 'FAQ')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   BLOG  = REPLACE(BLOG , 'hme', 'home')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   BLOG  = REPLACE(BLOG , 'abut', 'about')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   BLOG  = REPLACE(BLOG , 'emil', 'email')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   BLOG  = REPLACE(BLOG , 'vist', 'visit')  
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   BLOG  = REPLACE(BLOG , 'paes', 'pages') 
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   BLOG  = REPLACE(BLOG , 'Wlcome!', 'Welcome!') 
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   BLOG  = REPLACE(BLOG , 'Yu', 'You')
                   UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG  = REPLACE(BLOG , 'loged', 'logged')
 
 
 
 
 
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   FAQ  = REPLACE(FAQ , 'stff', 'staff')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   FAQ  = REPLACE(FAQ , 'sles team', 'sales team')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   FAQ  = REPLACE(FAQ , 'cstomer srvice', 'customer service')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   FAQ  = REPLACE(FAQ , 'spport', 'support')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   FAQ  = REPLACE(FAQ , 'prducts', 'products')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   FAQ  = REPLACE(FAQ , 'contct us', 'contact us')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   FAQ  = REPLACE(FAQ , 'fq', 'FAQ')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   FAQ  = REPLACE(FAQ , 'hme', 'home')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   FAQ  = REPLACE(FAQ , 'abut', 'about')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   FAQ  = REPLACE(FAQ , 'emil', 'email')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   FAQ  = REPLACE(FAQ , 'vist', 'visit')  
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   FAQ  = REPLACE(FAQ , 'paes', 'pages') 
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   FAQ  = REPLACE(FAQ , 'Wlcome!', 'Welcome!') 
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   FAQ  = REPLACE(FAQ , 'Yu', 'You')
                   UPDATE  @temp_prod_after_cleanup_table
                  SET   FAQ  = REPLACE(FAQ , 'loged', 'logged')
 
 
 
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   CAREERS  = REPLACE(CAREERS , 'stff', 'staff')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   CAREERS  = REPLACE(CAREERS , 'sles team', 'sales team')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   CAREERS  = REPLACE(CAREERS , 'cstomer srvice', 'customer service')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   CAREERS  = REPLACE(CAREERS , 'spport', 'support')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   CAREERS  = REPLACE(CAREERS , 'prducts', 'products')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   CAREERS  = REPLACE(CAREERS , 'contct us', 'contact us')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   CAREERS  = REPLACE(CAREERS , 'fq', 'FAQ')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   CAREERS  = REPLACE(CAREERS , 'hme', 'home')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   CAREERS  = REPLACE(CAREERS , 'abut', 'about')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   CAREERS  = REPLACE(CAREERS , 'emil', 'email')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   CAREERS  = REPLACE(CAREERS , 'vist', 'visit')  
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   CAREERS  = REPLACE(CAREERS , 'paes', 'pages') 
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   CAREERS  = REPLACE(CAREERS , 'Wlcome!', 'Welcome!') 
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   CAREERS  = REPLACE(CAREERS , 'Yu', 'You')
                   UPDATE  @temp_prod_after_cleanup_table
                  SET   CAREERS  = REPLACE(CAREERS , 'loged', 'logged')
 
 
 
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'stff', 'staff')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'sles team', 'sales team')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'cstomer srvice', 'customer service')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'spport', 'support')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'prducts', 'products')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'contct us', 'contact us')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'fq', 'FAQ')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'hme', 'home')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'abut', 'about')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'emil', 'email')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'vist', 'visit')  
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'paes', 'pages') 
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'Wlcome!', 'Welcome!') 
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'Yu', 'You')
                   UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'loged', 'logged')
 
 
 
   		UPDATE  @temp_prod_after_cleanup_table
                    SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'stff', 'staff')
                    UPDATE  @temp_prod_after_cleanup_table
                    SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'sles team', 'sales team')
                    UPDATE  @temp_prod_after_cleanup_table
                    SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'cstomer srvice', 'customer service')
                    UPDATE  @temp_prod_after_cleanup_table
                    SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'spport', 'support')
                    UPDATE  @temp_prod_after_cleanup_table
                    SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'prducts', 'products')
                    UPDATE  @temp_prod_after_cleanup_table
                    SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'contct us', 'contact us')
                    UPDATE  @temp_prod_after_cleanup_table
                    SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'fq', 'FAQ')
                    UPDATE  @temp_prod_after_cleanup_table
                    SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'hme', 'home')
                    UPDATE  @temp_prod_after_cleanup_table
                    SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'abut', 'about')
                    UPDATE  @temp_prod_after_cleanup_table
                    SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'emil', 'email')
                    UPDATE  @temp_prod_after_cleanup_table
                    SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'vist', 'visit')  
                    UPDATE  @temp_prod_after_cleanup_table
                    SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'paes', 'pages') 
                    UPDATE  @temp_prod_after_cleanup_table
                    SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'Wlcome!', 'Welcome!') 
                    UPDATE  @temp_prod_after_cleanup_table
                    SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'Yu', 'You')
                    UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'loged', 'logged')
 
 
 
    		UPDATE  @temp_prod_after_cleanup_table
                     SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'stff', 'staff')
                     UPDATE  @temp_prod_after_cleanup_table
                     SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'sles team', 'sales team')
                     UPDATE  @temp_prod_after_cleanup_table
                     SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'cstomer srvice', 'customer service')
                     UPDATE  @temp_prod_after_cleanup_table
                     SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'spport', 'support')
                     UPDATE  @temp_prod_after_cleanup_table
                     SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'prducts', 'products')
                     UPDATE  @temp_prod_after_cleanup_table
                     SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'contct us', 'contact us')
                     UPDATE  @temp_prod_after_cleanup_table
                     SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'fq', 'FAQ')
                     UPDATE  @temp_prod_after_cleanup_table
                     SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'hme', 'home')
                     UPDATE  @temp_prod_after_cleanup_table
                     SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'abut', 'about')
                     UPDATE  @temp_prod_after_cleanup_table
                     SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'emil', 'email')
                     UPDATE  @temp_prod_after_cleanup_table
                     SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'vist', 'visit')  
                     UPDATE  @temp_prod_after_cleanup_table
                     SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'paes', 'pages') 
                     UPDATE  @temp_prod_after_cleanup_table
                     SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'Wlcome!', 'Welcome!') 
                     UPDATE  @temp_prod_after_cleanup_table
                     SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'Yu', 'You')
                     UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'loged', 'logged')
 
 
 

END

 

/*****************

---------

--  INSERT INTO PERM TABLE YES CAPS--

          --------

******************/

--very good

--http://vyaskn.tripod.com/code/propercase.txt

  
 

if SPELL_CHECK = 'y' AND HTML_FORMAT = 'n'
begin
  

Update tc
Set HOME_PAGE  = dbo.ProperCase(ts.HOME_PAGE )
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id


Update tc
Set CONTACT_PAGE= dbo.ProperCase(ts.CONTACT_PAGE)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id


Update tc
Set PRODUCT_PAGE= dbo.ProperCase(ts.pants)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id


Update tc
Set COMPARE_CHART = dbo.ProperCase(ts.COMPARE_CHART)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

 
Update tc
Set PRODUCT_1 = dbo.ProperCase(ts.PRODUCT_1)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id


Update tc
Set PRODUCT_2 = dbo.ProperCase(ts.PRODUCT_2)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

Update tc
Set PRODUCT_3 = dbo.ProperCase(ts.PRODUCT_3)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id
 

Update tc
Set PRODUCT_TRIAL = dbo.ProperCase(ts.PRODUCT_TRIAL)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id
 

Update tc
Set OVERVIEW = dbo.ProperCase(ts.OVERVIEW)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id
 

Update tc
Set SUPPORT_CENTER = dbo.ProperCase(ts.SUPPORT_CENTER)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id
 

Update tc
Set USER_FORUM = dbo.ProperCase(ts.USER_FORUM)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id


Update tc
Set USER_FORUM = dbo.ProperCase(ts.USER_FORUM)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

 
Update tc
Set UNINSTALL_UTILITY = dbo.ProperCase(ts.UNINSTALL_UTILITY)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id
 

Update tc
Set BLOG = dbo.ProperCase(ts.BLOG)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id


Update tc
Set LICENSE_CENTER = dbo.ProperCase(ts.LICENSE_CENTER)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

  
 Update tc 
 Set FAQ = dbo.ProperCase(ts.FAQ) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id

Update tc
Set CAREERS = dbo.ProperCase(ts.CAREERS)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id


Update tc
Set PRODUCT_ITEM_1 = dbo.ProperCase(ts.PRODUCT_ITEM_1)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id


Update tc
Set PRODUCT_ITEM_2 = dbo.ProperCase(ts.PRODUCT_ITEM_2)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id


Update tc
Set PRODUCT_ITEM_3 = dbo.ProperCase(ts.PRODUCT_ITEM_3)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id


end 

 

 

 

/*****************

---------

--  INSERT INTO PERM TABLE NO CAPITALS, NO HTML_FORMAT--

          --------

******************/

 
IF SPELL_CHECK = 'n' and HTML_FORMAT = 'n'
BEGIN
 

Update tc
Set HOME_PAGE  = ts.HOME_PAGE 
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

 

Update tc
Set CONTACT_PAGE= ts.CONTACT_PAGE
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

 
Update tc
Set PRODUCT_PAGE= ts.pants
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

 
Update tc
Set COMPARE_CHART = ts.COMPARE_CHART
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id


Update tc
Set PRODUCT_1 = ts.PRODUCT_1
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id
 

Update tc
Set PRODUCT_2 = ts.PRODUCT_2
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

 
Update tc
Set PRODUCT_3 = ts.PRODUCT_3
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id
 

Update tc
Set PRODUCT_TRIAL = ts.PRODUCT_TRIAL
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

 
Update tc
Set OVERVIEW = ts.OVERVIEW
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id
 

Update tc
Set SUPPORT_CENTER = ts.SUPPORT_CENTER
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id
 

Update tc
Set USER_FORUM = ts.USER_FORUM
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

 
Update tc
Set USER_FORUM = ts.USER_FORUM
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

 

Update tc
Set UNINSTALL_UTILITY = ts.UNINSTALL_UTILITY
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

 
Update tc
Set BLOG = ts.BLOG
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id
 

Update tc
Set LICENSE_CENTER = ts.LICENSE_CENTER
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

  
 Update tc 
 Set FAQ = ts.FAQ 
 FROM product tc
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id


Update tc
Set CAREERS = ts.CAREERS
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

Update tc
Set PRODUCT_ITEM_1 = ts.PRODUCT_ITEM_1
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id


Update tc
Set PRODUCT_ITEM_2 = ts.PRODUCT_ITEM_2
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id


Update tc
Set PRODUCT_ITEM_3 = ts.PRODUCT_ITEM_3
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

END



/*****************

---------

--   INSERT INTO PERM TABLE  CAPITALS & HTML FORMAT --

          --------

******************/




IF SPELL_CHECK = 'y' and HTML_FORMAT = 'y'
 BEGIN
 
  
  Update tc  
  Set HOME_PAGE  = dbo.InsertBr(dbo.ProperCase(ts.HOME_PAGE),60)  
  FROM product tc  
   Join @temp_prod_after_cleanup_table ts  
  ON tc.wit_id = ts.wit_id  
   
 
 Update tc 
 Set CONTACT_PAGE= dbo.InsertBr(dbo.ProperCase(ts.CONTACT_PAGE),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
   
 Update tc 
 Set PRODUCT_PAGE= dbo.InsertBr(dbo.ProperCase(ts.pants),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
   
 
 Update tc 
 Set COMPARE_CHART = dbo.InsertBr(dbo.ProperCase(ts.COMPARE_CHART),60)
  FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
   
 Update tc 
 Set PRODUCT_1 = dbo.InsertBr(dbo.ProperCase(ts.PRODUCT_1),60) 
 FROM product tc
   Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
   
 
 Update tc 
 Set PRODUCT_2 = dbo.InsertBr(dbo.ProperCase(ts.PRODUCT_2),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
   
 Update tc 
 Set PRODUCT_3 = dbo.InsertBr(dbo.ProperCase(ts.PRODUCT_3),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
   
 
 Update tc 
 Set PRODUCT_TRIAL = dbo.InsertBr(dbo.ProperCase(ts.PRODUCT_TRIAL),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
   
 Update tc 
 Set OVERVIEW = dbo.InsertBr(dbo.ProperCase(ts.OVERVIEW),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
   
 Update tc 
 Set SUPPORT_CENTER = dbo.InsertBr(dbo.ProperCase(ts.SUPPORT_CENTER),60) 
 FROM product tc
   Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
  
 
 Update tc 
 Set USER_FORUM = dbo.InsertBr(dbo.ProperCase(ts.USER_FORUM),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
   
 
 Update tc 
 Set USER_FORUM = dbo.InsertBr(dbo.ProperCase(ts.USER_FORUM),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
   
 
 Update tc 
 Set UNINSTALL_UTILITY = dbo.InsertBr(dbo.ProperCase(ts.UNINSTALL_UTILITY),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
  
 
 Update tc 
 Set BLOG = dbo.InsertBr(dbo.ProperCase(ts.BLOG),60) 
 FROM product tc
   Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
   
 Update tc 
 Set LICENSE_CENTER = dbo.InsertBr(dbo.ProperCase(ts.LICENSE_CENTER),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
    
  
  Update tc  
  Set FAQ = dbo.InsertBr(dbo.ProperCase(ts.FAQ),60)  
  FROM product tc  
   Join @temp_prod_after_cleanup_table ts  
   ON tc.wit_id = ts.wit_id
 
 
 Update tc 
 Set CAREERS = dbo.InsertBr(dbo.ProperCase(ts.CAREERS),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
 
 Update tc 
 Set PRODUCT_ITEM_1 = dbo.InsertBr(dbo.ProperCase(ts.PRODUCT_ITEM_1),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
 
 Update tc 
 Set PRODUCT_ITEM_2 = dbo.InsertBr(dbo.ProperCase(ts.PRODUCT_ITEM_2),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
 
 Update tc 
 Set PRODUCT_ITEM_3 = dbo.InsertBr(dbo.ProperCase(ts.PRODUCT_ITEM_3),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
 ON tc.wit_id = ts.wit_id
 

 
 END



/*****************

---------

--   INSERT INTO PERM TABLE  JUST HTML FORMAT --

          --------

******************/




IF SPELL_CHECK = 'n' AND HTML_FORMAT = 'y'
 BEGIN
 
 begin
 
   
 
 Update tc
 
 Set HOME_PAGE  = dbo.InsertBr((ts.HOME_PAGE ),60)
 
 FROM product tc
 
  Join @temp_prod_after_cleanup_table ts
 
  ON tc.wit_id = ts.wit_id
 
  
 
 Update tc
 
 Set CONTACT_PAGE= dbo.InsertBr((ts.CONTACT_PAGE),60)
 
 FROM product tc
 
  Join @temp_prod_after_cleanup_table ts
 
  ON tc.wit_id = ts.wit_id
 
  
 
 Update tc
 
 Set PRODUCT_PAGE= dbo.InsertBr((ts.pants),60)
 
 FROM product tc
 
  Join @temp_prod_after_cleanup_table ts
 
  ON tc.wit_id = ts.wit_id
 
  
 
 Update tc
 
 Set COMPARE_CHART = dbo.InsertBr((ts.COMPARE_CHART),60)
 
 FROM product tc
 
  Join @temp_prod_after_cleanup_table ts
 
  ON tc.wit_id = ts.wit_id
 
  
 
 Update tc
 
 Set PRODUCT_1 = dbo.InsertBr((ts.PRODUCT_1),60)
 
 FROM product tc
 
  Join @temp_prod_after_cleanup_table ts
 
  ON tc.wit_id = ts.wit_id
 
  
 
 Update tc
 
 Set PRODUCT_2 = dbo.InsertBr((ts.PRODUCT_2),60)
 
 FROM product tc
 
  Join @temp_prod_after_cleanup_table ts
 
  ON tc.wit_id = ts.wit_id
 
  
 
 Update tc
 
 Set PRODUCT_3 = dbo.InsertBr((ts.PRODUCT_3),60)
 
 FROM product tc
 
  Join @temp_prod_after_cleanup_table ts
 
  ON tc.wit_id = ts.wit_id
 
  
  
 
 Update tc
 
 Set PRODUCT_TRIAL = dbo.InsertBr((ts.PRODUCT_TRIAL),60)
 
 FROM product tc
 
  Join @temp_prod_after_cleanup_table ts
 
  ON tc.wit_id = ts.wit_id
 
  
 
 Update tc
 
 Set OVERVIEW = dbo.InsertBr((ts.OVERVIEW),60)
 
 FROM product tc
 
  Join @temp_prod_after_cleanup_table ts
 
  ON tc.wit_id = ts.wit_id
 
  
 
 Update tc
 
 Set SUPPORT_CENTER = dbo.InsertBr((ts.SUPPORT_CENTER),60)
 
 FROM product tc
 
  Join @temp_prod_after_cleanup_table ts
 
  ON tc.wit_id = ts.wit_id
 
  
 
 Update tc
 
 Set USER_FORUM = dbo.InsertBr((ts.USER_FORUM),60)
 
 FROM product tc
 
  Join @temp_prod_after_cleanup_table ts
 
  ON tc.wit_id = ts.wit_id
 
  
 
 Update tc 
 Set USER_FORUM = dbo.InsertBr((ts.USER_FORUM),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
  
 
 Update tc 
 Set UNINSTALL_UTILITY = dbo.InsertBr((ts.UNINSTALL_UTILITY),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
  
 
 Update tc 
 Set BLOG = dbo.InsertBr((ts.BLOG),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
  
 Update tc 
 Set LICENSE_CENTER = dbo.InsertBr((ts.LICENSE_CENTER),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
  
  
  
  
  Update tc  
  Set FAQ = dbo.InsertBr((ts.FAQ),60)  
  FROM product tc  
   Join @temp_prod_after_cleanup_table ts  
   ON tc.wit_id = ts.wit_id
 
 
 Update tc 
 Set CAREERS = dbo.InsertBr((ts.CAREERS),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
 
 Update tc 
 Set PRODUCT_ITEM_1 = dbo.InsertBr((ts.PRODUCT_ITEM_1),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
 
 Update tc 
 Set PRODUCT_ITEM_2 = dbo.InsertBr((ts.PRODUCT_ITEM_2),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
 
 Update tc 
 Set PRODUCT_ITEM_3 = dbo.InsertBr((ts.PRODUCT_ITEM_3),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
  
 END

 

/*****************

---------

--   CLEAN-UP  --

          --------

******************/

 

 


 

 

--WERE DONE!



 

 

 

/*****************

---------

--   NOTES  --

          --------

******************/

--TRIGGERS

--http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/A_3079-Writing-SQL-Server-Triggers-Part-1-After-Triggers.html?sfQueryTermInfo=1+10+30+function+sql+updat

--http://sqlservernation.com/blogs/tipweek/archive/2010/02/28/handling-trigger-logic.aspx

 

--PROPERCASE

--http://vyaskn.tripod.com/code/propercase.txt

 

-- UPDATE THE HOME_PAGE  FIELD IN PRODUCT

--Update p

--Set CONTACT_PAGE= f.CONTACT_PAGE

--FROM product p

--- Join temp_capital_table f 

--- ON f.CONTACT_PAGE= p.CONTACT_PAGE

--WHERE f.CONTACT_PAGE= (SELECT dbo.ProperCase(CONTACT_PAGE) from dbo.temp_capital_table)

 

-- UPDATE THE HOME_PAGE  FIELD IN PRODUCT

--Update p

--Set PRODUCT_2 = t.PRODUCT_2

--FROM product p

---JOIN @temp_prod_after_cleanup_table t

--- ON t.PRODUCT_2 = p.PRODUCT_2

 

 

/*********

--END 

********/

Open in new window

GlobaLevelProgrammer

Author

Commented:
tried the above...i get:

Msg 156, Level 15, State 1, Procedure sp_test_Product_Change_To_Product, Line 17
Incorrect syntax near the keyword 'DECLARE'.
Msg 102, Level 15, State 1, Procedure sp_test_Product_Change_To_Product, Line 22
Incorrect syntax near '('.
Msg 137, Level 15, State 2, Procedure sp_test_Product_Change_To_Product, Line 159
Must declare the scalar variable "@CONTACT_PAGE".
Msg 137, Level 15, State 2, Procedure sp_test_Product_Change_To_Product, Line 516
Must declare the scalar variable "@temp_report_table".
Msg 102, Level 15, State 1, Procedure sp_test_Product_Change_To_Product, Line 549
Incorrect syntax near ','.
Msg 102, Level 15, State 1, Procedure sp_test_Product_Change_To_Product, Line 2322
Incorrect syntax near 'END'.
HTML5 and CSS3 Fundamentals

Build a website from the ground up by first learning the fundamentals of HTML5 and CSS3, the two popular programming languages used to present content online. HTML deals with fonts, colors, graphics, and hyperlinks, while CSS describes how HTML elements are to be displayed.

GlobaLevelProgrammer

Author

Commented:
any body?
how are you executing the stored procedure seems to me you are executing the stored procedure under master database
put use (put database name here)
Bhavesh ShahLead Analyst
Top Expert 2010

Commented:
Hi..

Same procedure you posted in your old questions twice.
what are doing exactly

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_26549526.html?cid=1131#a33923655

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_26549547.html?cid=1573#a33923766
-------------------------------------------------------------------------------------------------

 

/*****************

---------

--   BEGIN --

          --------

******************/

 


GO

/****** Object:   ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

 
 

-- _+_+_+_+_+

-- 

-- WE ARE READING PARAMETERS INTO SPROC

 

 

CREATE PROCEDURE [dbo].[sp_test_Product_Change_To_Product]    

DECLARE    
   @wit_id nvarchar(max) 
 , @SPELL_CHECK varchar(10)
 , @html_compliant varchar(10) 
 , @HOME_PAGE  nvarchar(max)   
 , @CONTACT_PAGEnvarchar(max) 
 , @PRODUCT_PAGEnvarchar(max)  
 , @COMPARE_CHART nvarchar(max) 
 , @PRODUCT_1 nvarchar(max) 
 , @PRODUCT_2 nvarchar(max) 				 ,
 , @PRODUCT_3 nvarchar(max) 
 , @PRODUCT_TRIAL nvarchar(max) 
 , @OVERVIEW nvarchar(max) 
 , @SUPPORT_CENTER nvarchar(max) 
 , @USER_FORUM nvarchar(max) 
 , @UNINSTALL_UTILITY nvarchar(max) 
 , @BLOG nvarchar(max) 
 , @LICENSE_CENTER nvarchar(max) 
 , @ABOUT nvarchar(max) 	
 , @BLOG nvarchar(max) 	
 , @FAQ nvarchar(max)			
 , @CAREERS  nvarchar(max) 	
 , @PRODUCT_ITEM_1 nvarchar(max)
 , @PRODUCT_ITEM_2 nvarchar(max)	
 , @PRODUCT_ITEM_3 nvarchar(max) 	
 , @CATEGORY_ID nvarchar(max)
)    

    
AS    

 SET NOCOUNT ON  

 
/*****************

---------

--   REPORT --

          --------

******************/

 
 DECLARE @date smalldatetime
 SET  @date = ISNULL(@date, getdate())
 

--THROW ALL THE JUNK INTO A REPORT TABLE...  

DECLARE @temp_report_table TABLE(
   DATE smalldatetime
 , WIT_ID nvarchar(max) 
 , HOME_PAGE  nvarchar(max)    
 , CONTACT_PAGE nvarchar(max)     
 , PRODUCT_PAGE nvarchar(max)   
 , COMPARE_CHART nvarchar(max)   
 , PRODUCT_1 nvarchar(max) 
 , PRODUCT_2 nvarchar(max) 
 , PRODUCT_3 nvarchar(max) 
 , PRODUCT_TRIAL nvarchar(max) 
 , OVERVIEW nvarchar(max) 
 , SUPPORT_CENTER nvarchar(max) 
 , USER_FORUM nvarchar(max) 
 , UNINSTALL_UTILITY nvarchar(max) 
 , BLOG nvarchar(max) 
 , LICENSE_CENTER   nvarchar(max)
 , ABOUT nvarchar(max) 	
 , BLOG nvarchar(max) 	
 , FAQ nvarchar(max)			
 , CAREERS  nvarchar(max) 	
 , PRODUCT_ITEM_1 nvarchar(max)
 , PRODUCT_ITEM_2 nvarchar(max)	
 , PRODUCT_ITEM_3 nvarchar(max) 	
 , CATEGORY_ID nvarchar(max)
  
 ) 
 
 
DECLARE @temp_prod_table TABLE(
   DATE smalldatetime
 , WIT_ID nvarchar(max) 
 , HOME_PAGE  nvarchar(max)    
 , CONTACT_PAGE nvarchar(max)     
 , PRODUCT_PAGE nvarchar(max)   
 , COMPARE_CHART nvarchar(max)   
 , PRODUCT_1 nvarchar(max) 
 , PRODUCT_2 nvarchar(max) 
 , PRODUCT_3 nvarchar(max) 
 , PRODUCT_TRIAL nvarchar(max) 
 , OVERVIEW nvarchar(max) 
 , SUPPORT_CENTER nvarchar(max) 
 , USER_FORUM nvarchar(max) 
 , UNINSTALL_UTILITY nvarchar(max) 
 , BLOG nvarchar(max) 
 , LICENSE_CENTER   nvarchar(max)
 , ABOUT nvarchar(max) 	
 , BLOG nvarchar(max) 	
 , FAQ nvarchar(max)			
 , CAREERS  nvarchar(max) 	
 , PRODUCT_ITEM_1 nvarchar(max)
 , PRODUCT_ITEM_2 nvarchar(max)	
 , PRODUCT_ITEM_3 nvarchar(max) 	
 , CATEGORY_ID nvarchar(max)
  
 ) 

 
  INSERT INTO @temp_prod_table (
   DATE
 , WIT_ID 
 , HOME_PAGE      
 , CONTACT_PAGE     
 , PRODUCT_PAGE   
 , COMPARE_CHART  
 , PRODUCT_1 
 , PRODUCT_2 
 , PRODUCT_3 
 , PRODUCT_TRIAL 
 , OVERVIEW 
 , SUPPORT_CENTER 
 , USER_FORUM 
 , UNINSTALL_UTILITY 
 , BLOG 
 , LICENSE_CENTER
 , ABOUT 	
 , BLOG 	
 , FAQ 			
 , CAREERS  	
 , PRODUCT_ITEM_1 
 , PRODUCT_ITEM_2 	
 , PRODUCT_ITEM_3 	
 , CATEGORY_ID 
  
 )
 
 VALUES
(    
   @DATE
 , @WIT_ID
 , @HOME_PAGE  
 , @CONTACT_PAGE
 , @PRODUCT_PAGE 
 , @COMPARE_CHART 
 , @PRODUCT_1 
 , @PRODUCT_2 
 , @PRODUCT_3 
 , @PRODUCT_TRIAL 
 , @OVERVIEW 
 , @SUPPORT_CENTER 
 , @USER_FORUM 
 , @UNINSTALL_UTILITY 
 , @BLOG 
 , @LICENSE_CENTER  
 , @ABOUT 	
 , @BLOG 	
 , @FAQ 			
 , @CAREERS  	
 , @PRODUCT_ITEM_1 
 , @PRODUCT_ITEM_2 	
 , @PRODUCT_ITEM_3 	
 , @CATEGORY_ID 
   
) 
 
 
 
 ---SORT DATA---



INSERT INTO @temp_report_table (HOME_PAGE)
SELECT CASE 
      WHEN HOME_PAGE  like '%shooter%' THEN 'red' 
      WHEN HOME_PAGE  like '%fruit%' THEN 'blue' 
      WHEN HOME_PAGE  like '%block%' THEN 'green'
      WHEN HOME_PAGE  like '%cannot%' THEN 'violet'
      WHEN HOME_PAGE  like '%dack%' THEN 'pink'
      WHEN HOME_PAGE  like '%believing%' THEN 'envy'
      WHEN HOME_PAGE  like '%always%' THEN 'grey'
      WHEN HOME_PAGE  like '%fruiter%' THEN 'blueer' 
      WHEN HOME_PAGE  like '%also%' THEN 'grey'
      WHEN HOME_PAGE  like '%dungess%' THEN 'red' END                         

FROM @temp_prod_table 

 

INSERT INTO @temp_report_table (CONTACT_PAGE)
SELECT CASE 
      WHEN CONTACT_PAGE like '%shooter%' THEN 'red' 
      WHEN CONTACT_PAGE like '%fruit%' THEN 'blue' 
      WHEN CONTACT_PAGE like '%block%' THEN 'green'
      WHEN CONTACT_PAGE like '%cannot%' THEN 'violet'
      WHEN CONTACT_PAGE like '%dack%' THEN 'pink'
      WHEN CONTACT_PAGE like '%believing%' THEN 'envy'
      WHEN CONTACT_PAGE like '%always%' THEN 'grey'
      WHEN CONTACT_PAGE like '%fruiter%' THEN 'blueer' 
      WHEN CONTACT_PAGE like '%also%' THEN 'grey'
      WHEN CONTACT_PAGE like '%dungess%' THEN 'red' END                        

FROM @temp_prod_table 

 

INSERT INTO @temp_report_table (PRODUCT_PAGE)

SELECT CASE 
      WHEN PRODUCT_PAGE like '%shooter%' THEN 'red' 
      WHEN PRODUCT_PAGE like '%fruit%' THEN 'blue' 
      WHEN PRODUCT_PAGE like '%block%' THEN 'green'
      WHEN PRODUCT_PAGE like '%cannot%' THEN 'violet'
      WHEN PRODUCT_PAGE like '%dack%' THEN 'pink'
      WHEN PRODUCT_PAGE like '%believing%' THEN 'envy'
      WHEN PRODUCT_PAGE like '%always%' THEN 'grey'
      WHEN PRODUCT_PAGE like '%fruiter%' THEN 'blueer' 
      WHEN PRODUCT_PAGE like '%also%' THEN 'grey'
      WHEN PRODUCT_PAGE like '%dungess%' THEN 'red' END                      

FROM @temp_prod_table 

 

INSERT INTO @temp_report_table (COMPARE_CHART)

SELECT CASE 
      WHEN COMPARE_CHART like  '%shooter%' THEN 'red' 
      WHEN COMPARE_CHART like  '%fruit%' THEN 'blue' 
      WHEN COMPARE_CHART like  '%block%' THEN 'green'
      WHEN COMPARE_CHART like  '%cannot%' THEN 'violet'
      WHEN COMPARE_CHART like  '%dack%' THEN 'pink'
      WHEN COMPARE_CHART like  '%believing%' THEN 'envy'
      WHEN COMPARE_CHART like  '%always%' THEN 'grey'
      WHEN COMPARE_CHART like  '%fruiter%' THEN 'blueer' 
      WHEN COMPARE_CHART like  '%also%' THEN 'grey'
      WHEN COMPARE_CHART like  '%dungess%' THEN 'red' END                      

FROM @temp_prod_table 

 

INSERT INTO @temp_report_table (PRODUCT_1)

SELECT CASE 
      WHEN PRODUCT_1 like  '%shooter%' THEN 'red' 
      WHEN PRODUCT_1 like  '%fruit%' THEN 'blue' 
      WHEN PRODUCT_1 like  '%block%' THEN 'green'
      WHEN PRODUCT_1 like  '%cannot%' THEN 'violet'
      WHEN PRODUCT_1 like  '%dack%' THEN 'pink'
      WHEN PRODUCT_1 like  '%believing%' THEN 'envy'
      WHEN PRODUCT_1 like  '%always%' THEN 'grey'
      WHEN PRODUCT_1 like  '%fruiter%' THEN 'blueer' 
      WHEN PRODUCT_1 like  '%also%' THEN 'grey'
      WHEN PRODUCT_1 like  '%dungess%' THEN 'red' END                       

FROM @temp_prod_table 

 

INSERT INTO @temp_report_table (PRODUCT_2)

SELECT CASE 
      WHEN PRODUCT_2 like  '%shooter%' THEN 'red' 
      WHEN PRODUCT_2 like  '%fruit%' THEN 'blue' 
      WHEN PRODUCT_2 like  '%block%' THEN 'green'
      WHEN PRODUCT_2 like  '%cannot%' THEN 'violet'
      WHEN PRODUCT_2 like  '%dack%' THEN 'pink'
      WHEN PRODUCT_2 like  '%believing%' THEN 'envy'
      WHEN PRODUCT_2 like  '%always%' THEN 'grey'
      WHEN PRODUCT_2 like  '%fruiter%' THEN 'blueer' 
      WHEN PRODUCT_2 like  '%also%' THEN 'grey'
      WHEN PRODUCT_2 like  '%dungess%' THEN 'red' END                         

FROM @temp_prod_table 

 

INSERT INTO @temp_report_table (PRODUCT_3)

SELECT CASE 
      WHEN PRODUCT_3 like  '%shooter%' THEN 'red' 
      WHEN PRODUCT_3 like  '%fruit%' THEN 'blue' 
      WHEN PRODUCT_3 like  '%block%' THEN 'green'
      WHEN PRODUCT_3 like  '%cannot%' THEN 'violet'
      WHEN PRODUCT_3 like  '%dack%' THEN 'pink'
      WHEN PRODUCT_3 like  '%believing%' THEN 'envy'
      WHEN PRODUCT_3 like  '%always%' THEN 'grey'
      WHEN PRODUCT_3 like  '%fruiter%' THEN 'blueer' 
      WHEN PRODUCT_3 like  '%also%' THEN 'grey'
      WHEN PRODUCT_3 like  '%dungess%' THEN 'red' END                   

FROM @temp_prod_table 

 

INSERT INTO @temp_report_table (PRODUCT_TRIAL)

SELECT CASE 
      WHEN PRODUCT_TRIAL like  '%shooter%' THEN 'red' 
      WHEN PRODUCT_TRIAL like  '%fruit%' THEN 'blue' 
      WHEN PRODUCT_TRIAL like  '%block%' THEN 'green'
      WHEN PRODUCT_TRIAL like  '%cannot%' THEN 'violet'
      WHEN PRODUCT_TRIAL like  '%dack%' THEN 'pink'
      WHEN PRODUCT_TRIAL like  '%believing%' THEN 'envy'
      WHEN PRODUCT_TRIAL like  '%always%' THEN 'grey'
      WHEN PRODUCT_TRIAL like  '%fruiter%' THEN 'blueer' 
      WHEN PRODUCT_TRIAL like  '%also%' THEN 'grey'
      WHEN PRODUCT_TRIAL like  '%dungess%' THEN 'red' END                         

FROM @temp_prod_table 

 

INSERT INTO @temp_report_table (OVERVIEW)

SELECT CASE 
      WHEN OVERVIEW like  '%shooter%' THEN 'red' 
      WHEN OVERVIEW like  '%fruit%' THEN 'blue' 
      WHEN OVERVIEW like  '%block%' THEN 'green'
      WHEN OVERVIEW like  '%cannot%' THEN 'violet'
      WHEN OVERVIEW like  '%dack%' THEN 'pink'
      WHEN OVERVIEW like  '%believing%' THEN 'envy'
      WHEN OVERVIEW like  '%always%' THEN 'grey'
      WHEN OVERVIEW like  '%fruiter%' THEN 'blueer' 
      WHEN OVERVIEW like  '%also%' THEN 'grey'
      WHEN OVERVIEW like  '%dungess%' THEN 'red' END                      

FROM @temp_prod_table 

 

INSERT INTO @temp_report_table (SUPPORT_CENTER)

SELECT CASE 
      WHEN SUPPORT_CENTER like  '%shooter%' THEN 'red' 
      WHEN SUPPORT_CENTER like  '%fruit%' THEN 'blue' 
      WHEN SUPPORT_CENTER like  '%block%' THEN 'green'
      WHEN SUPPORT_CENTER like  '%cannot%' THEN 'violet'
      WHEN SUPPORT_CENTER like  '%dack%' THEN 'pink'
      WHEN SUPPORT_CENTER like  '%believing%' THEN 'envy'
      WHEN SUPPORT_CENTER like  '%always%' THEN 'grey'
      WHEN SUPPORT_CENTER like  '%fruiter%' THEN 'blueer' 
      WHEN SUPPORT_CENTER like  '%also%' THEN 'grey'
      WHEN SUPPORT_CENTER like  '%dungess%' THEN 'red' END                      

FROM @temp_prod_table 

 

INSERT INTO @temp_report_table (USER_FORUM)

SELECT CASE 

      WHEN USER_FORUM like  '%shooter%' THEN 'red' 
      WHEN USER_FORUM like  '%fruit%' THEN 'blue' 
      WHEN USER_FORUM like  '%block%' THEN 'green'
      WHEN USER_FORUM like  '%cannot%' THEN 'violet'
      WHEN USER_FORUM like  '%dack%' THEN 'pink'
      WHEN USER_FORUM like  '%believing%' THEN 'envy'
      WHEN USER_FORUM like  '%always%' THEN 'grey'
      WHEN USER_FORUM like  '%fruiter%' THEN 'blueer' 
      WHEN USER_FORUM like  '%also%' THEN 'grey'
      WHEN USER_FORUM like  '%dungess%' THEN 'red' END                    

FROM @temp_prod_table 

 

INSERT INTO @temp_report_table (UNINSTALL_UTILITY)

SELECT CASE 
      WHEN UNINSTALL_UTILITY like  '%shooter%' THEN 'red' 
      WHEN UNINSTALL_UTILITY like  '%fruit%' THEN 'blue' 
      WHEN UNINSTALL_UTILITY like  '%block%' THEN 'green'
      WHEN UNINSTALL_UTILITY like  '%cannot%' THEN 'violet'
      WHEN UNINSTALL_UTILITY like  '%dack%' THEN 'pink'
      WHEN UNINSTALL_UTILITY like  '%believing%' THEN 'envy'
      WHEN UNINSTALL_UTILITY like  '%always%' THEN 'grey'
      WHEN UNINSTALL_UTILITY like  '%fruiter%' THEN 'blueer' 
      WHEN UNINSTALL_UTILITY like  '%also%' THEN 'grey'
      WHEN UNINSTALL_UTILITY like  '%dungess%' THEN 'red' END                       

FROM @temp_prod_table

 

INSERT INTO @temp_report_table (BLOG)

SELECT CASE 
      WHEN BLOG like  '%shooter%' THEN 'red' 
      WHEN BLOG like  '%fruit%' THEN 'blue' 
      WHEN BLOG like  '%block%' THEN 'green'
      WHEN BLOG like  '%cannot%' THEN 'violet'
      WHEN BLOG like  '%dack%' THEN 'pink'
      WHEN BLOG like  '%believing%' THEN 'envy'
      WHEN BLOG like  '%always%' THEN 'grey'
      WHEN BLOG like  '%fruiter%' THEN 'blueer' 
      WHEN BLOG like  '%also%' THEN 'grey'
      WHEN BLOG like  '%dungess%' THEN 'red' END                     

FROM @temp_prod_table

 

INSERT INTO @temp_report_table (FAQ)

SELECT CASE 

      WHEN FAQ like  '%shooter%' THEN 'red' 
      WHEN FAQ like  '%fruit%' THEN 'blue' 
      WHEN FAQ like  '%block%' THEN 'green'
      WHEN FAQ like  '%cannot%' THEN 'violet'
      WHEN FAQ like  '%dack%' THEN 'pink'
      WHEN FAQ like  '%believing%' THEN 'envy'
      WHEN FAQ like  '%always%' THEN 'grey'
      WHEN FAQ like  '%fruiter%' THEN 'blueer' 
      WHEN FAQ like  '%also%' THEN 'grey'
      WHEN FAQ like  '%dungess%' THEN 'red' END                       

FROM @temp_prod_table 


INSERT INTO @temp_report_table (CAREERS)

SELECT CASE 

      WHEN CAREERS like  '%shooter%' THEN 'red' 
      WHEN CAREERS like  '%fruit%' THEN 'blue' 
      WHEN CAREERS like  '%block%' THEN 'green'
      WHEN CAREERS like  '%cannot%' THEN 'violet'
      WHEN CAREERS like  '%dack%' THEN 'pink'
      WHEN CAREERS like  '%believing%' THEN 'envy'
      WHEN CAREERS like  '%always%' THEN 'grey'
      WHEN CAREERS like  '%fruiter%' THEN 'blueer' 
      WHEN CAREERS like  '%also%' THEN 'grey'
      WHEN CAREERS like  '%dungess%' THEN 'red' END                       

FROM @temp_prod_table 


INSERT INTO @temp_report_table (PRODUCT_ITEM_1)

SELECT CASE 

      WHEN PRODUCT_ITEM_1 like  '%shooter%' THEN 'red' 
      WHEN PRODUCT_ITEM_1 like  '%fruit%' THEN 'blue' 
      WHEN PRODUCT_ITEM_1 like  '%block%' THEN 'green'
      WHEN PRODUCT_ITEM_1 like  '%cannot%' THEN 'violet'
      WHEN PRODUCT_ITEM_1 like  '%dack%' THEN 'pink'
      WHEN PRODUCT_ITEM_1 like  '%believing%' THEN 'envy'
      WHEN PRODUCT_ITEM_1 like  '%always%' THEN 'grey'
      WHEN PRODUCT_ITEM_1 like  '%fruiter%' THEN 'blueer' 
      WHEN PRODUCT_ITEM_1 like  '%also%' THEN 'grey'
      WHEN PRODUCT_ITEM_1 like  '%dungess%' THEN 'red' END                       

FROM @temp_prod_table 



INSERT INTO @temp_report_table (PRODUCT_ITEM_2)

SELECT CASE 

      WHEN PRODUCT_ITEM_2 like  '%shooter%' THEN 'red' 
      WHEN PRODUCT_ITEM_2 like  '%fruit%' THEN 'blue' 
      WHEN PRODUCT_ITEM_2 like  '%block%' THEN 'green'
      WHEN PRODUCT_ITEM_2 like  '%cannot%' THEN 'violet'
      WHEN PRODUCT_ITEM_2 like  '%dack%' THEN 'pink'
      WHEN PRODUCT_ITEM_2 like  '%believing%' THEN 'envy'
      WHEN PRODUCT_ITEM_2 like  '%always%' THEN 'grey'
      WHEN PRODUCT_ITEM_2 like  '%fruiter%' THEN 'blueer' 
      WHEN PRODUCT_ITEM_2 like  '%also%' THEN 'grey'
      WHEN PRODUCT_ITEM_2 like  '%dungess%' THEN 'red' END                       

FROM @temp_prod_table 


INSERT INTO @temp_report_table (PRODUCT_ITEM_3)

SELECT CASE 

      WHEN PRODUCT_ITEM_3 like  '%shooter%' THEN 'red' 
      WHEN PRODUCT_ITEM_3 like  '%fruit%' THEN 'blue' 
      WHEN PRODUCT_ITEM_3 like  '%block%' THEN 'green'
      WHEN PRODUCT_ITEM_3 like  '%cannot%' THEN 'violet'
      WHEN PRODUCT_ITEM_3 like  '%dack%' THEN 'pink'
      WHEN PRODUCT_ITEM_3 like  '%believing%' THEN 'envy'
      WHEN PRODUCT_ITEM_3 like  '%always%' THEN 'grey'
      WHEN PRODUCT_ITEM_3 like  '%fruiter%' THEN 'blueer' 
      WHEN PRODUCT_ITEM_3 like  '%also%' THEN 'grey'
      WHEN PRODUCT_ITEM_3 like  '%dungess%' THEN 'red' END                       

FROM @temp_prod_table 



--IF THERE IS JUNK SEND TO REPORT TABLE

IF @temp_report_table not NULL
BEGIN
 INSERT INTO client_monitor_table
 SELECT * 
 FROM  @temp_report_table
 WHERE wit_id = @wit_id

END

 

 

/*****************

---------

--   PRODUCT  --

          --------

******************/

 

 

--CLEAN UP THE LANGUAGE...


 
 DECLARE @temp_prod_after_cleanup_table TABLE(
    DATE smalldatetime 
  , WIT_ID nvarchar(max) 
  , HOME_PAGE  nvarchar(max)    
  , CONTACT_PAGE nvarchar(max)     
  , PRODUCT_PAGE nvarchar(max)   
  , COMPARE_CHART nvarchar(max)   
  , PRODUCT_1 nvarchar(max) 
  , PRODUCT_2 nvarchar(max) 
  , PRODUCT_3 nvarchar(max) 
  , PRODUCT_TRIAL nvarchar(max) 
  , OVERVIEW nvarchar(max) 
  , SUPPORT_CENTER nvarchar(max) 
  , USER_FORUM nvarchar(max) 
  , UNINSTALL_UTILITY nvarchar(max) 
  , BLOG nvarchar(max) 
  , LICENSE_CENTER   nvarchar(max)
  , ABOUT nvarchar(max)  	
  , FAQ nvarchar(max)			
  , CAREERS  nvarchar(max) 	
  , PRODUCT_ITEM_1 nvarchar(max)
  , PRODUCT_ITEM_2 nvarchar(max)	
  , PRODUCT_ITEM_3 nvarchar(max) 	
  , CATEGORY_ID nvarchar(max)
 
    

INSERT INTO @temp_prod_after_cleanup_table (HOME_PAGE )
SELECT CASE 
             WHEN HOME_PAGE  like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN HOME_PAGE  like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN HOME_PAGE  like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN HOME_PAGE  like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN HOME_PAGE  like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN HOME_PAGE  like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN HOME_PAGE  like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN HOME_PAGE  like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN HOME_PAGE  like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN HOME_PAGE  like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                        

FROM @temp_prod_table 

 

INSERT INTO @temp_prod_after_cleanup_table (CONTACT_PAGE)
SELECT CASE 
            WHEN CONTACT_PAGE like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN CONTACT_PAGE like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN CONTACT_PAGE like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN CONTACT_PAGE like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN CONTACT_PAGE like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN CONTACT_PAGE like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN CONTACT_PAGE like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN CONTACT_PAGE like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN CONTACT_PAGE like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN CONTACT_PAGE like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                         

FROM @temp_prod_table

 

INSERT INTO @temp_prod_after_cleanup_table (PRODUCT_PAGE)
SELECT CASE 
             WHEN PRODUCT_PAGE like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_PAGE like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_PAGE like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_PAGE like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_PAGE like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_PAGE like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_PAGE like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_PAGE like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_PAGE like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_PAGE like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                    

FROM @temp_prod_table 

 

INSERT INTO @temp_prod_after_cleanup_table (COMPARE_CHART)
SELECT CASE 
             WHEN COMPARE_CHART like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN COMPARE_CHART like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN COMPARE_CHART like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN COMPARE_CHART like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN COMPARE_CHART like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN COMPARE_CHART like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN COMPARE_CHART like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN COMPARE_CHART like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN COMPARE_CHART like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN COMPARE_CHART like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                      

FROM @temp_prod_table 

 

INSERT INTO @temp_prod_after_cleanup_table (PRODUCT_1)
SELECT CASE 
             WHEN PRODUCT_1 like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_1 like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_1 like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_1 like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_1 like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_1 like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_1 like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_1 like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_1 like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_1 like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                     

FROM @temp_prod_table 

 

INSERT INTO @temp_prod_after_cleanup_table (PRODUCT_2)
SELECT CASE 
             WHEN PRODUCT_2 like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_2 like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_2 like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_2 like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_2 like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_2 like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_2 like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_2 like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_2 like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_2 like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                     

FROM @temp_prod_table 

 

INSERT INTO @temp_prod_after_cleanup_table (PRODUCT_3)
SELECT CASE 
             WHEN PRODUCT_3 like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_3 like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_3 like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_3 like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_3 like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_3 like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_3 like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_3 like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_3 like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_3 like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                          

FROM @temp_prod_table

 

INSERT INTO @temp_prod_after_cleanup_table (PRODUCT_TRIAL)
SELECT CASE 
             WHEN PRODUCT_TRIAL like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_TRIAL like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_TRIAL like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_TRIAL like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_TRIAL like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_TRIAL like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_TRIAL like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_TRIAL like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_TRIAL like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_TRIAL like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                     

FROM @temp_prod_table 

 

INSERT INTO @temp_prod_after_cleanup_table (OVERVIEW)
SELECT CASE 
           WHEN OVERVIEW like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN OVERVIEW like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN OVERVIEW like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN OVERVIEW like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN OVERVIEW like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN OVERVIEW like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN OVERVIEW like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN OVERVIEW like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN OVERVIEW like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN OVERVIEW like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                    

FROM @temp_prod_table 

 

INSERT INTO @temp_prod_after_cleanup_table (SUPPORT_CENTER)
SELECT CASE 
            WHEN SUPPORT_CENTER like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN SUPPORT_CENTER like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN SUPPORT_CENTER like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN SUPPORT_CENTER like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN SUPPORT_CENTER like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN SUPPORT_CENTER like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN SUPPORT_CENTER like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN SUPPORT_CENTER like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN SUPPORT_CENTER like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN SUPPORT_CENTER like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                       

FROM @temp_prod_table 

 

INSERT INTO @temp_prod_after_cleanup_table (USER_FORUM)
SELECT CASE 
             WHEN USER_FORUM like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN USER_FORUM like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN USER_FORUM like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN USER_FORUM like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN USER_FORUM like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN USER_FORUM like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN USER_FORUM like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN USER_FORUM like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN USER_FORUM like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN USER_FORUM like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                    

FROM @temp_prod_table

 

INSERT INTO @temp_prod_after_cleanup_table (UNINSTALL_UTILITY)
SELECT CASE 
             WHEN UNINSTALL_UTILITY like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN UNINSTALL_UTILITY like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN UNINSTALL_UTILITY like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN UNINSTALL_UTILITY like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN UNINSTALL_UTILITY like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN UNINSTALL_UTILITY like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN UNINSTALL_UTILITY like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN UNINSTALL_UTILITY like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN UNINSTALL_UTILITY like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN UNINSTALL_UTILITY like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                       

FROM @temp_prod_table
 

INSERT INTO @temp_prod_after_cleanup_table (BLOG)
SELECT CASE 
             WHEN BLOG like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN BLOG like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN BLOG like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN BLOG like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN BLOG like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN BLOG like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN BLOG like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN BLOG like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN BLOG like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN BLOG like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                    

FROM @temp_prod_table
 

INSERT INTO @temp_prod_after_cleanup_table (LICENSE_CENTER)
SELECT CASE 
            WHEN LICENSE_CENTER like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN LICENSE_CENTER like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN LICENSE_CENTER like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN LICENSE_CENTER like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN LICENSE_CENTER like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN LICENSE_CENTER like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN LICENSE_CENTER like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN LICENSE_CENTER like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN LICENSE_CENTER like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN LICENSE_CENTER like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                       

FROM @temp_prod_table

 
INSERT INTO @temp_prod_after_cleanup_table (FAQ)
SELECT CASE 
            WHEN FAQ like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN FAQ like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN FAQ like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN FAQ like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN FAQ like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN FAQ like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN FAQ like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN FAQ like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN FAQ like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN FAQ like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                   

FROM @temp_prod_table


INSERT INTO @temp_prod_after_cleanup_table (CAREERS)
SELECT CASE 
            WHEN CAREERS like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN CAREERS like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN CAREERS like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN CAREERS like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN CAREERS like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN CAREERS like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN CAREERS like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN CAREERS like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN CAREERS like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN CAREERS like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                     

FROM @temp_prod_table


INSERT INTO @temp_prod_after_cleanup_table (PRODUCT_ITEM_1)
SELECT CASE 
            WHEN PRODUCT_ITEM_1 like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_ITEM_1 like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_ITEM_1 like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_1 like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_1 like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_1 like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_1 like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_1 like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_1 like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_1 like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                     

FROM @temp_prod_table

INSERT INTO @temp_prod_after_cleanup_table (PRODUCT_ITEM_2)
SELECT CASE 
             WHEN PRODUCT_ITEM_2 like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_ITEM_2 like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_ITEM_2 like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_2 like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_2 like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_2 like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_2 like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_2 like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_2 like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_2 like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                    

FROM @temp_prod_table

INSERT INTO @temp_prod_after_cleanup_table (PRODUCT_ITEM_3)
SELECT CASE 
         WHEN PRODUCT_ITEM_3 like  '%shooter%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_ITEM_3 like  '%fruit%' THEN 'TEXT VIOLATION ERROR' 
             WHEN PRODUCT_ITEM_3 like  '%block%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_3 like  '%cannot%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_3 like  '%dack%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_3 like  '%believing%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_3 like  '%always%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_3 like  '%fruiter%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_3 like  '%also%' THEN 'TEXT VIOLATION ERROR'
             WHEN PRODUCT_ITEM_3 like  '%dungess%' THEN 'TEXT VIOLATION ERROR' END                       

FROM @temp_prod_table


/*****************

---------

--   SPELL CHECK  --

          --------

******************/

 

-- IF SPELL CHECK COLUMN IS CHECKED THEN PROCEED ELSE GET OUT OF SPROC

-- TURN:

-- 'Wlcome! Yu are now loged into this ste. So glad you are here. 
--   We have a lot of great paes to vist: emil, abut, hme, fq, contct us, 
--   prducts, spport, cstomer srvice, sles team, stff.'


-- INTO:
-- 'Welcome! You are now logged into this site. So glad you are here. 
--   We have a lot of great pages to visit: email, about, home, faq, contact us, 
--   products, support, customer service, sales team, staff.'
 

if @SPELL_CHECK = 'y' 

BEGIN 

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'stff', 'staff')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'sles team', 'sales team')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'cstomer srvice', 'customer service')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'spport', 'support')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'prducts', 'products')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'contct us', 'contact us')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'fq', 'FAQ')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'hme', 'home')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'abut', 'about')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'emil', 'email')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'vist', 'visit')  
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'paes', 'pages') 
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'Wlcome!', 'Welcome!') 
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'Yu', 'You')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   HOME_PAGE  = REPLACE(HOME_PAGE , 'loged', 'logged')

 

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'stff', 'staff')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'sles team', 'sales team')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'cstomer srvice', 'customer service')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'spport', 'support')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'prducts', 'products')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'contct us', 'contact us')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'fq', 'FAQ')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'hme', 'home')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'abut', 'about')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'emil', 'email')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'vist', 'visit')  
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'paes', 'pages') 

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'Wlcome!', 'Welcome!')    
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'Yu', 'You')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   CONTACT_PAGE= REPLACE(CONTACT_PAGE, 'loged', 'logged') 

 

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'stff', 'staff')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'sles team', 'sales team')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'cstomer srvice', 'customer service')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'spport', 'support')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'prducts', 'products')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'contct us', 'contact us')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'fq', 'FAQ')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'hme', 'home')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'abut', 'about')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'emil', 'email')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'vist', 'visit')  
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'paes', 'pages')     

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'Wlcome!', 'Welcome!')  
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'Yu', 'You')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_PAGE= REPLACE(pants, 'loged', 'logged')

 

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'stff', 'staff')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'sles team', 'sales team')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'cstomer srvice', 'customer service')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'spport', 'support')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'prducts', 'products')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'contct us', 'contact us')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'fq', 'FAQ')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'hme', 'home')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'abut', 'about')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'emil', 'email')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'vist', 'visit')    

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'paes', 'pages')        

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'Wlcome!', 'Welcome!')    

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'Yu', 'You')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   COMPARE_CHART = REPLACE(COMPARE_CHART, 'loged', 'logged')

 
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'stff', 'staff')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'sles team', 'sales team')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'cstomer srvice', 'customer service')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'spport', 'support')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'prducts', 'products')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'contct us', 'contact us')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'fq', 'FAQ')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'hme', 'home')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'abut', 'about')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'emil', 'email')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'vist', 'visit')  

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'paes', 'pages')        

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'Wlcome!', 'Welcome!')   

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'Yu', 'You')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_1 = REPLACE(PRODUCT_1, 'loged', 'logged')

 

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'stff', 'staff')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'sles team', 'sales team')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'cstomer srvice', 'customer service')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'spport', 'support')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'prducts', 'products')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'contct us', 'contact us')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'fq', 'FAQ')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'hme', 'home')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'abut', 'about')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'emil', 'email')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'vist', 'visit')  
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'paes', 'pages')      

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'Wlcome!', 'Welcome!')  
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'Yu', 'You')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_2 = REPLACE(PRODUCT_2, 'loged', 'logged')

 

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'stff', 'staff')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'sles team', 'sales team')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'cstomer srvice', 'customer service')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'spport', 'support')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'prducts', 'products')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'contct us', 'contact us')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'fq', 'FAQ')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'hme', 'home')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'abut', 'about')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'emil', 'email')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'vist', 'visit')  
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'paes', 'pages')       

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'Wlcome!', 'Welcome!')  
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'Yu', 'You')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_3 = REPLACE(PRODUCT_3, 'loged', 'logged')
 


                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'stff', 'staff')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'sles team', 'sales team')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'cstomer srvice', 'customer service')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'spport', 'support')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'prducts', 'products')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'contct us', 'contact us')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'fq', 'FAQ')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'hme', 'home')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'abut', 'about')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'emil', 'email')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'vist', 'visit')      
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'paes', 'pages')          

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'Wlcome!', 'Welcome!')    

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'Yu', 'You')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_TRIAL = REPLACE(PRODUCT_TRIAL, 'loged', 'logged')
 

 

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   OVERVIEW = REPLACE(OVERVIEW, 'stff', 'staff')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   OVERVIEW = REPLACE(OVERVIEW, 'sles team', 'sales team')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   OVERVIEW = REPLACE(OVERVIEW, 'cstomer srvice', 'customer service')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   OVERVIEW = REPLACE(OVERVIEW, 'spport', 'support')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   OVERVIEW = REPLACE(OVERVIEW, 'prducts', 'products')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   OVERVIEW = REPLACE(OVERVIEW, 'contct us', 'contact us')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   OVERVIEW = REPLACE(OVERVIEW, 'fq', 'FAQ')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   OVERVIEW = REPLACE(OVERVIEW, 'hme', 'home')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   OVERVIEW = REPLACE(OVERVIEW, 'abut', 'about')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   OVERVIEW = REPLACE(OVERVIEW, 'emil', 'email')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   OVERVIEW = REPLACE(OVERVIEW, 'vist', 'visit')     

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   OVERVIEW = REPLACE(OVERVIEW, 'paes', 'pages')          

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   OVERVIEW = REPLACE(OVERVIEW, 'Wlcome!', 'Welcome!')      
                  UPDATE  @temp_prod_after_cleanup_table

                  SET   OVERVIEW = REPLACE(OVERVIEW, 'Yu', 'You')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   OVERVIEW = REPLACE(OVERVIEW, 'loged', 'logged')
 

 

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'stff', 'staff')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'sles team', 'sales team')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'cstomer srvice', 'customer service')

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'spport', 'support')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'prducts', 'products')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'contct us', 'contact us')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'fq', 'FAQ')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'hme', 'home')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'abut', 'about')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'emil', 'email')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'vist', 'visit')    
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'paes', 'pages')         

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'Wlcome!', 'Welcome!')    
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'Yu', 'You')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   SUPPORT_CENTER = REPLACE(SUPPORT_CENTER, 'loged', 'logged')

 
 

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'stff', 'staff')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'sles team', 'sales team')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'cstomer srvice', 'customer service')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'spport', 'support')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'prducts', 'products')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'contct us', 'contact us')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'fq', 'FAQ')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'hme', 'home')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'abut', 'about')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'emil', 'email')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'vist', 'visit')  
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'paes', 'pages')       

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'Wlcome!', 'Welcome!')  
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'Yu', 'You')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   USER_FORUM = REPLACE(USER_FORUM, 'loged', 'logged')
 

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'stff', 'staff')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'sles team', 'sales team')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'cstomer srvice', 'customer service')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'spport', 'support')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'prducts', 'products')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'contct us', 'contact us')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'fq', 'FAQ')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'hme', 'home')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'abut', 'about')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'emil', 'email')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'vist', 'visit')  
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'paes', 'pages')       

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'Wlcome!', 'Welcome!')  
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'Yu', 'You')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   UNINSTALL_UTILITY = REPLACE(UNINSTALL_UTILITY, 'loged', 'logged')

 

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'stff', 'staff')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'sles team', 'sales team')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'cstomer srvice', 'customer service')

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'spport', 'support')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'prducts', 'products')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'contct us', 'contact us')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'fq', 'FAQ')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'hme', 'home')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'abut', 'about')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'emil', 'email')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'vist', 'visit')   

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'paes', 'pages')         

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'Wlcome!', 'Welcome!')   

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'Yu', 'You')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG = REPLACE(BLOG, 'loged', 'logged') 

 

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'stff', 'staff')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'sles team', 'sales team')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'cstomer srvice', 'customer service')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'spport', 'support')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'prducts', 'products')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'contct us', 'contact us')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'fq', 'FAQ')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'hme', 'home')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'abut', 'about')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'emil', 'email')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'vist', 'visit')  
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'paes', 'pages')       

                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'Wlcome!', 'Welcome!')  
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'Yu', 'You')
                  UPDATE  @temp_prod_after_cleanup_table
                  SET   LICENSE_CENTER = REPLACE(LICENSE_CENTER, 'loged', 'logged')

 
 
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   BLOG  = REPLACE(BLOG , 'stff', 'staff')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   BLOG  = REPLACE(BLOG , 'sles team', 'sales team')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   BLOG  = REPLACE(BLOG , 'cstomer srvice', 'customer service')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   BLOG  = REPLACE(BLOG , 'spport', 'support')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   BLOG  = REPLACE(BLOG , 'prducts', 'products')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   BLOG  = REPLACE(BLOG , 'contct us', 'contact us')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   BLOG  = REPLACE(BLOG , 'fq', 'FAQ')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   BLOG  = REPLACE(BLOG , 'hme', 'home')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   BLOG  = REPLACE(BLOG , 'abut', 'about')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   BLOG  = REPLACE(BLOG , 'emil', 'email')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   BLOG  = REPLACE(BLOG , 'vist', 'visit')  
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   BLOG  = REPLACE(BLOG , 'paes', 'pages') 
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   BLOG  = REPLACE(BLOG , 'Wlcome!', 'Welcome!') 
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   BLOG  = REPLACE(BLOG , 'Yu', 'You')
                   UPDATE  @temp_prod_after_cleanup_table
                  SET   BLOG  = REPLACE(BLOG , 'loged', 'logged')
 
 
 
 
 
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   FAQ  = REPLACE(FAQ , 'stff', 'staff')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   FAQ  = REPLACE(FAQ , 'sles team', 'sales team')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   FAQ  = REPLACE(FAQ , 'cstomer srvice', 'customer service')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   FAQ  = REPLACE(FAQ , 'spport', 'support')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   FAQ  = REPLACE(FAQ , 'prducts', 'products')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   FAQ  = REPLACE(FAQ , 'contct us', 'contact us')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   FAQ  = REPLACE(FAQ , 'fq', 'FAQ')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   FAQ  = REPLACE(FAQ , 'hme', 'home')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   FAQ  = REPLACE(FAQ , 'abut', 'about')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   FAQ  = REPLACE(FAQ , 'emil', 'email')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   FAQ  = REPLACE(FAQ , 'vist', 'visit')  
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   FAQ  = REPLACE(FAQ , 'paes', 'pages') 
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   FAQ  = REPLACE(FAQ , 'Wlcome!', 'Welcome!') 
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   FAQ  = REPLACE(FAQ , 'Yu', 'You')
                   UPDATE  @temp_prod_after_cleanup_table
                  SET   FAQ  = REPLACE(FAQ , 'loged', 'logged')
 
 
 
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   CAREERS  = REPLACE(CAREERS , 'stff', 'staff')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   CAREERS  = REPLACE(CAREERS , 'sles team', 'sales team')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   CAREERS  = REPLACE(CAREERS , 'cstomer srvice', 'customer service')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   CAREERS  = REPLACE(CAREERS , 'spport', 'support')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   CAREERS  = REPLACE(CAREERS , 'prducts', 'products')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   CAREERS  = REPLACE(CAREERS , 'contct us', 'contact us')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   CAREERS  = REPLACE(CAREERS , 'fq', 'FAQ')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   CAREERS  = REPLACE(CAREERS , 'hme', 'home')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   CAREERS  = REPLACE(CAREERS , 'abut', 'about')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   CAREERS  = REPLACE(CAREERS , 'emil', 'email')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   CAREERS  = REPLACE(CAREERS , 'vist', 'visit')  
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   CAREERS  = REPLACE(CAREERS , 'paes', 'pages') 
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   CAREERS  = REPLACE(CAREERS , 'Wlcome!', 'Welcome!') 
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   CAREERS  = REPLACE(CAREERS , 'Yu', 'You')
                   UPDATE  @temp_prod_after_cleanup_table
                  SET   CAREERS  = REPLACE(CAREERS , 'loged', 'logged')
 
 
 
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'stff', 'staff')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'sles team', 'sales team')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'cstomer srvice', 'customer service')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'spport', 'support')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'prducts', 'products')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'contct us', 'contact us')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'fq', 'FAQ')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'hme', 'home')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'abut', 'about')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'emil', 'email')
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'vist', 'visit')  
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'paes', 'pages') 
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'Wlcome!', 'Welcome!') 
                   UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'Yu', 'You')
                   UPDATE  @temp_prod_after_cleanup_table
                  SET   PRODUCT_ITEM_1  = REPLACE(PRODUCT_ITEM_1 , 'loged', 'logged')
 
 
 
   		UPDATE  @temp_prod_after_cleanup_table
                    SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'stff', 'staff')
                    UPDATE  @temp_prod_after_cleanup_table
                    SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'sles team', 'sales team')
                    UPDATE  @temp_prod_after_cleanup_table
                    SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'cstomer srvice', 'customer service')
                    UPDATE  @temp_prod_after_cleanup_table
                    SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'spport', 'support')
                    UPDATE  @temp_prod_after_cleanup_table
                    SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'prducts', 'products')
                    UPDATE  @temp_prod_after_cleanup_table
                    SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'contct us', 'contact us')
                    UPDATE  @temp_prod_after_cleanup_table
                    SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'fq', 'FAQ')
                    UPDATE  @temp_prod_after_cleanup_table
                    SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'hme', 'home')
                    UPDATE  @temp_prod_after_cleanup_table
                    SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'abut', 'about')
                    UPDATE  @temp_prod_after_cleanup_table
                    SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'emil', 'email')
                    UPDATE  @temp_prod_after_cleanup_table
                    SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'vist', 'visit')  
                    UPDATE  @temp_prod_after_cleanup_table
                    SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'paes', 'pages') 
                    UPDATE  @temp_prod_after_cleanup_table
                    SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'Wlcome!', 'Welcome!') 
                    UPDATE  @temp_prod_after_cleanup_table
                    SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'Yu', 'You')
                    UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_2  = REPLACE(PRODUCT_ITEM_2 , 'loged', 'logged')
 
 
 
    		UPDATE  @temp_prod_after_cleanup_table
                     SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'stff', 'staff')
                     UPDATE  @temp_prod_after_cleanup_table
                     SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'sles team', 'sales team')
                     UPDATE  @temp_prod_after_cleanup_table
                     SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'cstomer srvice', 'customer service')
                     UPDATE  @temp_prod_after_cleanup_table
                     SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'spport', 'support')
                     UPDATE  @temp_prod_after_cleanup_table
                     SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'prducts', 'products')
                     UPDATE  @temp_prod_after_cleanup_table
                     SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'contct us', 'contact us')
                     UPDATE  @temp_prod_after_cleanup_table
                     SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'fq', 'FAQ')
                     UPDATE  @temp_prod_after_cleanup_table
                     SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'hme', 'home')
                     UPDATE  @temp_prod_after_cleanup_table
                     SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'abut', 'about')
                     UPDATE  @temp_prod_after_cleanup_table
                     SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'emil', 'email')
                     UPDATE  @temp_prod_after_cleanup_table
                     SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'vist', 'visit')  
                     UPDATE  @temp_prod_after_cleanup_table
                     SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'paes', 'pages') 
                     UPDATE  @temp_prod_after_cleanup_table
                     SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'Wlcome!', 'Welcome!') 
                     UPDATE  @temp_prod_after_cleanup_table
                     SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'Yu', 'You')
                     UPDATE  @temp_prod_after_cleanup_table
                   SET   PRODUCT_ITEM_3  = REPLACE(PRODUCT_ITEM_3 , 'loged', 'logged')
 
 
 

END

 

/*****************

---------

--  INSERT INTO PERM TABLE YES CAPS--

          --------

******************/

--very good

--http://vyaskn.tripod.com/code/propercase.txt

  
 

if SPELL_CHECK = 'y' AND HTML_FORMAT = 'n'
begin
  

Update tc
Set HOME_PAGE  = dbo.ProperCase(ts.HOME_PAGE )
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id


Update tc
Set CONTACT_PAGE= dbo.ProperCase(ts.CONTACT_PAGE)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id


Update tc
Set PRODUCT_PAGE= dbo.ProperCase(ts.pants)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id


Update tc
Set COMPARE_CHART = dbo.ProperCase(ts.COMPARE_CHART)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

 
Update tc
Set PRODUCT_1 = dbo.ProperCase(ts.PRODUCT_1)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id


Update tc
Set PRODUCT_2 = dbo.ProperCase(ts.PRODUCT_2)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

Update tc
Set PRODUCT_3 = dbo.ProperCase(ts.PRODUCT_3)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id
 

Update tc
Set PRODUCT_TRIAL = dbo.ProperCase(ts.PRODUCT_TRIAL)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id
 

Update tc
Set OVERVIEW = dbo.ProperCase(ts.OVERVIEW)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id
 

Update tc
Set SUPPORT_CENTER = dbo.ProperCase(ts.SUPPORT_CENTER)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id
 

Update tc
Set USER_FORUM = dbo.ProperCase(ts.USER_FORUM)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id


Update tc
Set USER_FORUM = dbo.ProperCase(ts.USER_FORUM)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

 
Update tc
Set UNINSTALL_UTILITY = dbo.ProperCase(ts.UNINSTALL_UTILITY)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id
 

Update tc
Set BLOG = dbo.ProperCase(ts.BLOG)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id


Update tc
Set LICENSE_CENTER = dbo.ProperCase(ts.LICENSE_CENTER)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

  
 Update tc 
 Set FAQ = dbo.ProperCase(ts.FAQ) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id

Update tc
Set CAREERS = dbo.ProperCase(ts.CAREERS)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id


Update tc
Set PRODUCT_ITEM_1 = dbo.ProperCase(ts.PRODUCT_ITEM_1)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id


Update tc
Set PRODUCT_ITEM_2 = dbo.ProperCase(ts.PRODUCT_ITEM_2)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id


Update tc
Set PRODUCT_ITEM_3 = dbo.ProperCase(ts.PRODUCT_ITEM_3)
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id


end 

 

 

 

/*****************

---------

--  INSERT INTO PERM TABLE NO CAPITALS, NO HTML_FORMAT--

          --------

******************/

 
IF SPELL_CHECK = 'n' and HTML_FORMAT = 'n'
BEGIN
 

Update tc
Set HOME_PAGE  = ts.HOME_PAGE 
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

 

Update tc
Set CONTACT_PAGE= ts.CONTACT_PAGE
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

 
Update tc
Set PRODUCT_PAGE= ts.pants
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

 
Update tc
Set COMPARE_CHART = ts.COMPARE_CHART
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id


Update tc
Set PRODUCT_1 = ts.PRODUCT_1
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id
 

Update tc
Set PRODUCT_2 = ts.PRODUCT_2
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

 
Update tc
Set PRODUCT_3 = ts.PRODUCT_3
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id
 

Update tc
Set PRODUCT_TRIAL = ts.PRODUCT_TRIAL
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

 
Update tc
Set OVERVIEW = ts.OVERVIEW
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id
 

Update tc
Set SUPPORT_CENTER = ts.SUPPORT_CENTER
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id
 

Update tc
Set USER_FORUM = ts.USER_FORUM
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

 
Update tc
Set USER_FORUM = ts.USER_FORUM
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

 

Update tc
Set UNINSTALL_UTILITY = ts.UNINSTALL_UTILITY
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

 
Update tc
Set BLOG = ts.BLOG
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id
 

Update tc
Set LICENSE_CENTER = ts.LICENSE_CENTER
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

  
 Update tc 
 Set FAQ = ts.FAQ 
 FROM product tc
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id


Update tc
Set CAREERS = ts.CAREERS
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

Update tc
Set PRODUCT_ITEM_1 = ts.PRODUCT_ITEM_1
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id


Update tc
Set PRODUCT_ITEM_2 = ts.PRODUCT_ITEM_2
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id


Update tc
Set PRODUCT_ITEM_3 = ts.PRODUCT_ITEM_3
FROM product tc
 Join @temp_prod_after_cleanup_table ts
 ON tc.wit_id = ts.wit_id

END



/*****************

---------

--   INSERT INTO PERM TABLE  CAPITALS & HTML FORMAT --

          --------

******************/




IF SPELL_CHECK = 'y' and HTML_FORMAT = 'y'
 BEGIN
 
  
  Update tc  
  Set HOME_PAGE  = dbo.InsertBr(dbo.ProperCase(ts.HOME_PAGE),60)  
  FROM product tc  
   Join @temp_prod_after_cleanup_table ts  
  ON tc.wit_id = ts.wit_id  
   
 
 Update tc 
 Set CONTACT_PAGE= dbo.InsertBr(dbo.ProperCase(ts.CONTACT_PAGE),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
   
 Update tc 
 Set PRODUCT_PAGE= dbo.InsertBr(dbo.ProperCase(ts.pants),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
   
 
 Update tc 
 Set COMPARE_CHART = dbo.InsertBr(dbo.ProperCase(ts.COMPARE_CHART),60)
  FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
   
 Update tc 
 Set PRODUCT_1 = dbo.InsertBr(dbo.ProperCase(ts.PRODUCT_1),60) 
 FROM product tc
   Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
   
 
 Update tc 
 Set PRODUCT_2 = dbo.InsertBr(dbo.ProperCase(ts.PRODUCT_2),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
   
 Update tc 
 Set PRODUCT_3 = dbo.InsertBr(dbo.ProperCase(ts.PRODUCT_3),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
   
 
 Update tc 
 Set PRODUCT_TRIAL = dbo.InsertBr(dbo.ProperCase(ts.PRODUCT_TRIAL),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
   
 Update tc 
 Set OVERVIEW = dbo.InsertBr(dbo.ProperCase(ts.OVERVIEW),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
   
 Update tc 
 Set SUPPORT_CENTER = dbo.InsertBr(dbo.ProperCase(ts.SUPPORT_CENTER),60) 
 FROM product tc
   Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
  
 
 Update tc 
 Set USER_FORUM = dbo.InsertBr(dbo.ProperCase(ts.USER_FORUM),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
   
 
 Update tc 
 Set USER_FORUM = dbo.InsertBr(dbo.ProperCase(ts.USER_FORUM),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
   
 
 Update tc 
 Set UNINSTALL_UTILITY = dbo.InsertBr(dbo.ProperCase(ts.UNINSTALL_UTILITY),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
  
 
 Update tc 
 Set BLOG = dbo.InsertBr(dbo.ProperCase(ts.BLOG),60) 
 FROM product tc
   Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
   
 Update tc 
 Set LICENSE_CENTER = dbo.InsertBr(dbo.ProperCase(ts.LICENSE_CENTER),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
    
  
  Update tc  
  Set FAQ = dbo.InsertBr(dbo.ProperCase(ts.FAQ),60)  
  FROM product tc  
   Join @temp_prod_after_cleanup_table ts  
   ON tc.wit_id = ts.wit_id
 
 
 Update tc 
 Set CAREERS = dbo.InsertBr(dbo.ProperCase(ts.CAREERS),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
 
 Update tc 
 Set PRODUCT_ITEM_1 = dbo.InsertBr(dbo.ProperCase(ts.PRODUCT_ITEM_1),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
 
 Update tc 
 Set PRODUCT_ITEM_2 = dbo.InsertBr(dbo.ProperCase(ts.PRODUCT_ITEM_2),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
 
 Update tc 
 Set PRODUCT_ITEM_3 = dbo.InsertBr(dbo.ProperCase(ts.PRODUCT_ITEM_3),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
 ON tc.wit_id = ts.wit_id
 

 
 END



/*****************

---------

--   INSERT INTO PERM TABLE  JUST HTML FORMAT --

          --------

******************/




IF SPELL_CHECK = 'n' AND HTML_FORMAT = 'y'
 BEGIN
 
 begin
 
   
 
 Update tc
 
 Set HOME_PAGE  = dbo.InsertBr((ts.HOME_PAGE ),60)
 
 FROM product tc
 
  Join @temp_prod_after_cleanup_table ts
 
  ON tc.wit_id = ts.wit_id
 
  
 
 Update tc
 
 Set CONTACT_PAGE= dbo.InsertBr((ts.CONTACT_PAGE),60)
 
 FROM product tc
 
  Join @temp_prod_after_cleanup_table ts
 
  ON tc.wit_id = ts.wit_id
 
  
 
 Update tc
 
 Set PRODUCT_PAGE= dbo.InsertBr((ts.pants),60)
 
 FROM product tc
 
  Join @temp_prod_after_cleanup_table ts
 
  ON tc.wit_id = ts.wit_id
 
  
 
 Update tc
 
 Set COMPARE_CHART = dbo.InsertBr((ts.COMPARE_CHART),60)
 
 FROM product tc
 
  Join @temp_prod_after_cleanup_table ts
 
  ON tc.wit_id = ts.wit_id
 
  
 
 Update tc
 
 Set PRODUCT_1 = dbo.InsertBr((ts.PRODUCT_1),60)
 
 FROM product tc
 
  Join @temp_prod_after_cleanup_table ts
 
  ON tc.wit_id = ts.wit_id
 
  
 
 Update tc
 
 Set PRODUCT_2 = dbo.InsertBr((ts.PRODUCT_2),60)
 
 FROM product tc
 
  Join @temp_prod_after_cleanup_table ts
 
  ON tc.wit_id = ts.wit_id
 
  
 
 Update tc
 
 Set PRODUCT_3 = dbo.InsertBr((ts.PRODUCT_3),60)
 
 FROM product tc
 
  Join @temp_prod_after_cleanup_table ts
 
  ON tc.wit_id = ts.wit_id
 
  
  
 
 Update tc
 
 Set PRODUCT_TRIAL = dbo.InsertBr((ts.PRODUCT_TRIAL),60)
 
 FROM product tc
 
  Join @temp_prod_after_cleanup_table ts
 
  ON tc.wit_id = ts.wit_id
 
  
 
 Update tc
 
 Set OVERVIEW = dbo.InsertBr((ts.OVERVIEW),60)
 
 FROM product tc
 
  Join @temp_prod_after_cleanup_table ts
 
  ON tc.wit_id = ts.wit_id
 
  
 
 Update tc
 
 Set SUPPORT_CENTER = dbo.InsertBr((ts.SUPPORT_CENTER),60)
 
 FROM product tc
 
  Join @temp_prod_after_cleanup_table ts
 
  ON tc.wit_id = ts.wit_id
 
  
 
 Update tc
 
 Set USER_FORUM = dbo.InsertBr((ts.USER_FORUM),60)
 
 FROM product tc
 
  Join @temp_prod_after_cleanup_table ts
 
  ON tc.wit_id = ts.wit_id
 
  
 
 Update tc 
 Set USER_FORUM = dbo.InsertBr((ts.USER_FORUM),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
  
 
 Update tc 
 Set UNINSTALL_UTILITY = dbo.InsertBr((ts.UNINSTALL_UTILITY),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
  
 
 Update tc 
 Set BLOG = dbo.InsertBr((ts.BLOG),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
  
 Update tc 
 Set LICENSE_CENTER = dbo.InsertBr((ts.LICENSE_CENTER),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
  
  
  
  
  Update tc  
  Set FAQ = dbo.InsertBr((ts.FAQ),60)  
  FROM product tc  
   Join @temp_prod_after_cleanup_table ts  
   ON tc.wit_id = ts.wit_id
 
 
 Update tc 
 Set CAREERS = dbo.InsertBr((ts.CAREERS),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
 
 Update tc 
 Set PRODUCT_ITEM_1 = dbo.InsertBr((ts.PRODUCT_ITEM_1),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
 
 Update tc 
 Set PRODUCT_ITEM_2 = dbo.InsertBr((ts.PRODUCT_ITEM_2),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
 
 Update tc 
 Set PRODUCT_ITEM_3 = dbo.InsertBr((ts.PRODUCT_ITEM_3),60) 
 FROM product tc 
  Join @temp_prod_after_cleanup_table ts 
  ON tc.wit_id = ts.wit_id
 
  
 END

 

/*****************

---------

--   CLEAN-UP  --

          --------

******************/

 

 


 

 

--WERE DONE!



 

 

 

/*****************

---------

--   NOTES  --

          --------

******************/

--TRIGGERS

--http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/A_3079-Writing-SQL-Server-Triggers-Part-1-After-Triggers.html?sfQueryTermInfo=1+10+30+function+sql+updat

--http://sqlservernation.com/blogs/tipweek/archive/2010/02/28/handling-trigger-logic.aspx

 

--PROPERCASE

--http://vyaskn.tripod.com/code/propercase.txt

 

-- UPDATE THE HOME_PAGE  FIELD IN PRODUCT

--Update p

--Set CONTACT_PAGE= f.CONTACT_PAGE

--FROM product p

--- Join temp_capital_table f 

--- ON f.CONTACT_PAGE= p.CONTACT_PAGE

--WHERE f.CONTACT_PAGE= (SELECT dbo.ProperCase(CONTACT_PAGE) from dbo.temp_capital_table)

 

-- UPDATE THE HOME_PAGE  FIELD IN PRODUCT

--Update p

--Set PRODUCT_2 = t.PRODUCT_2

--FROM product p

---JOIN @temp_prod_after_cleanup_table t

--- ON t.PRODUCT_2 = p.PRODUCT_2

 

 

/*********

--END 

********/

Open in new window

Bhavesh ShahLead Analyst
Top Expert 2010

Commented:
check out above one
GlobaLevelProgrammer

Author

Commented:
It is being executed under DB : webIT

Brichsoft..thanks..just trying to get it to work...I closed out those issues...with this post being the focus...since it is the most current....
Bhavesh ShahLead Analyst
Top Expert 2010

Commented:

:-)

enjoy
GlobaLevelProgrammer

Author

Commented:
Brichsoft..thanks for your help to narrow down the issue...
GlobaLevelProgrammer

Author

Commented:
Excellent!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial