Update Category name from the name in HQ , with Script

SELECT A.[ID]
      ,A.[Name]
      ,A.[Code],
      'Update Category Set Name = ' + B.Name +'  WHERE Code = ' + A.Code +'' As script

  FROM [AS].[dbo].[Category] AS A, [HQSTOCK].[dbo].[Category] AS B WHERE A.[Code] = B.[Code]
  AND A.Name != B.Name
GO

87	Ready Framed Batik (M Hussin)	01005028	Update Category Set Name = Ready Framed Batik (Alim)  WHERE Code = 01005028
88	Ready Framed Batik (Zabid)	01005029	Update Category Set Name = Ready Framed Batik (Chin)  WHERE Code = 01005029
93	01001029	01001029	Update Category Set Name = Batik Paintings (Topo)  WHERE Code = 01001029
94	01001030	01001030	Update Category Set Name = Batik Paintings (Al-Kusuma)  WHERE Code = 01001030
95	01001031	01001031	Update Category Set Name = Batik Paintings (Haryati)  WHERE Code = 01001031
96	01001032	01001032	Update Category Set Name = Batik Paintings (Andre)  WHERE Code = 01001032
97	01005030	01005030	Update Category Set Name = Ready Framed Batik (Acholik)  WHERE Code = 01005030
98	01001033	01001033	Update Category Set Name = Batik Paintings (Chin)  WHERE Code = 01001033
SELECT C.[ID]
      ,C.[Name]
      ,C.[Code],
      'Update Category Set Name = ''' + C.Name +'''  WHERE Code = ' + C.Code +'' As script

  FROM [HQSTOCK].[dbo].[Category] AS C

Advertisement