Database

ALTER PROCEDURE [dbo].[sp_CopyFileScorerChanges] 
	-- Add the parameters for the stored procedure here
	@SourceTable NVARCHAR(100),
	@TargetTable NVARCHAR(100)
AS
BEGIN
    SET NOCOUNT ON;
	
    DECLARE @zSQL NVARCHAR(4000)

	SET @zSQL = N'INSERT INTO ' + @SourceTable  + '(
					[FilePath],
					[CurrentCategory],
					[CurrentSubCategory],
					[CurrentBpm],
					[OldCategory],
					[OldSubCategory],
					[OldBpm]
					) 
					SELECT 
						@FilePath,
						@CurrentCategory,
						@CurrentSubCategory,
						@CurrentBpm,
						@OldCategory,
						@OldSubCategory,
						@OldBpm
					FROM  ' + @TargetTable +
					'WHERE CurrentCategory <> OldCategory'
					
				
	EXEC( sp_ExecuteSQL @zSQL, N'@FilePath NVARCHAR(4000),	
								 @CurrentCategory NVARCHAR(100),
								 @CurrentSubCategory NVARCHAR(100),
								 @CurrentBpm INT,
								 @OldCategory NVARCHAR(100),
								 @OldSubCategory NVARCHAR(100),
								 @OldBpm INT',
								 @FilePath,	
								 @CurrentCategory, 
								 @CurrentSubCategory, 
								 @CurrentBpm, 
								 @OldCategory, 
								 @OldSubCategory, 
								 @OldBpm
		)
END