C11/System/OPTIMA/SQL/schema/GC/procedures/SP_FILL_GC_ACTIVITY.sql

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[SP_FILL_GC_ACTIVITY]

AS
BEGIN
INSERT INTO [GC].[data].[GC_Activity_Codes] ([Client_DB]
      ,[Activity_Code]
      ,[Activity_Desc]
      ,[Activity_Category]
      ,[Present])
	  SELECT 
	  [CLIENT_DB]
	  ,[ACTIVITY_CODE]
	  ,[ACTIVITY_DESCRIPTION]
	  ,[ACTIVITY_CATEGORY]
      ,[PRESENT]
       FROM [OPTIMA].[import].[ACTIVITY]
END
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

GO