Example of copy mssql rows from one table to another table12.07.18

SET IDENTITY_INSERT [SL].[dbo].[yz2_transaction_finding] ON

INSERT INTO [SL].[dbo].[yz2_transaction_finding]
(
 [yz2_document_no]
      ,[yz2_location]
      ,[yz2_krt]
      ,[yz2_style_code_finding]
      ,[yz2_color]
      ,[yz2_size]
      ,[yz2_enterence_exit_finding]
      ,[yz2_date]
      ,[yz2_hour]
      ,[yz2_wt_gross]
      ,[yz2_qty]
      ,[yz2_precent_to_fine]
      ,[yz2_wt_fine]
      ,[yz2_detail]
      ,[yz2_location_cross]
      ,[yz2_balance_temporary]
      ,[yz2_wt_gold]
      ,[yz2_wt_platina]
      ,[yz2_wt_silver]
      ,[yz2_ratio_gold_metal_other_precent]
      ,[yz2_user]
      ,[yz2_supplier]
      ,[yz2_balance_temporary_gross]
      ,[yz2_balance_temporary_fine]
      ,[F25_yz2_a]
      ,[F26_yz2_a]
      ,[F27_yz2_a]
      ,[F28_yz2_a]
      ,[yz2_code_detail]
      ,[yz2_kind_transaction]
      ,[F31_yz2_a]
      ,[F32_yz2_a]
      ,[F33_yz2_a]
      ,[F34_yz2_a]
      ,[F35_yz2_a]
      ,[F36_yz2_a]
      ,[F37_yz2_a]
      ,[yz2_transaction_big]
      ,[yz2_pass_new_file]
      ,[F40_yz2_a]
      ,[F41_yz2_a]
      ,[F42_yz2_a]
      ,[F43_yz2_a]
      ,[F44_yz2_a]
      ,[F45_4]
      ,[IDENTITY_FLD]
)

SELECT  [yz2_document_no]
      ,[yz2_location]
      ,[yz2_krt]
      ,[yz2_style_code_finding]
      ,[yz2_color]
      ,[yz2_size]
      ,[yz2_enterence_exit_finding]
      ,[yz2_date]
      ,[yz2_hour]
      ,[yz2_wt_gross]
      ,[yz2_qty]
      ,[yz2_precent_to_fine]
      ,[yz2_wt_fine]
      ,[yz2_detail]
      ,[yz2_location_cross]
      ,[yz2_balance_temporary]
      ,[yz2_wt_gold]
      ,[yz2_wt_platina]
      ,[yz2_wt_silver]
      ,[yz2_ratio_gold_metal_other_precent]
      ,[yz2_user]
      ,[yz2_supplier]
      ,[yz2_balance_temporary_gross]
      ,[yz2_balance_temporary_fine]
      ,[F25_yz2_a]
      ,[F26_yz2_a]
      ,[F27_yz2_a]
      ,[F28_yz2_a]
      ,[yz2_code_detail]
      ,[yz2_kind_transaction]
      ,[F31_yz2_a]
      ,[F32_yz2_a]
      ,[F33_yz2_a]
      ,[F34_yz2_a]
      ,[F35_yz2_a]
      ,[F36_yz2_a]
      ,[F37_yz2_a]
      ,[yz2_transaction_big]
      ,[yz2_pass_new_file]
      ,[F40_yz2_a]
      ,[F41_yz2_a]
      ,[F42_yz2_a]
      ,[F43_yz2_a]
      ,[F44_yz2_a]
      ,[F45_4]
      ,[IDENTITY_FLD]
  FROM [SL].[dbo].[yz2_transaction_finding_h]

https://stackoverflow.com/questions/74162/how-to-do-insert-into-a-table-records-extracted-from-another-table

Anonymous

Example of copy mssql rows from one table to another table12.07.18

Information Epoch 1768000389