CREATE PROCEDURE [dbo].[Copy_To_Temp] 
		@Table_Name varchar(40),
		@Primary_Field varchar(20),
		@Primary_Value int, 
		@Tis float
AS
	BEGIN
		Declare @ColumnName nvarchar(128)
		Declare @FieldString_To nvarchar(MAX)
		Declare @FieldString_Fr nvarchar(MAX)
 
		SET @ColumnName = ''
		SET @FieldString_To = ''
		SET @FieldString_Fr = ''
 
		Declare curColumnNames cursor For
					SELECT  Column_Name
					FROM  INFORMATION_SCHEMA.COLUMNS 
					WHERE Table_Name LIKE @Table_Name
 
		Open curColumnNames
		FETCH NEXT FROM curColumnNames INTO @ColumnName
			WHILE @@FETCH_STATUS = 0
			Begin
 
				If @ColumnName is not null AND @ColumnName <> ''
				Begin
					Set @FieldString_To = @FieldString_To + @ColumnName + ', '
					Set @FieldString_Fr = @FieldString_Fr + @Table_Name + '.' + @ColumnName + _
  ', '
				End
				FETCH NEXT FROM curColumnNames INTO @ColumnName
 
			End
		SET @FieldString_To = @FieldString_To + 'LUT_Add, LUT_Edit, LUT_Del, LUT_Tis'
		SET @FieldString_Fr = @FieldString_Fr + '@LUT_Add, @LUT_Edit, @LUT_Del, 
' @LUT_Tis'
 
		Close curColumnNames
		Deallocate curColumnNames
 
		DECLARE @SQLString as nvarchar(max)
		SET @SQLString = 'INSERT INTO ' +
						'Temp_' + @Table_Name + 
							'(' + @FieldString_To + ') ' +
						'SELECT ' + 
							@FieldString_Fr + ' ' +
						'FROM ' + 
							@Table_Name + ' ' +
						'WHERE ' 
							+ @Primary_Field + ' = ' + CAST(@Primary_Value AS varchar)
 
		DECLARE @ParamDefinition nvarchar(60)
		SET @ParamDefinition = N'@LUT_Add bit,@LUT_Edit bit,@LUT_Del bit,@LUT_Tis 
' float'
 
		EXECUTE sp_executesql @SQLString, @ParamDefinition, 
							  @LUT_Add=0,@LUT_Edit=0,@LUT_Del=0,@LUT_Tis=@Tis
	END