Hi Marina,

If you want to insert records from one table into another, you would use INSERT INTO commnad

INSERT INTO TRANSACTIONS (fac_id, rcpfeedt,trans_id)
  SELECT fac_id, date_issue, corp_id FROM FACILITY

If it's not what you're after, please provide more details.

>Dear Sergey !
>Could you please help me ?
>I write this little code in SQL Query Analyzer:

>BEGIN
>
>DECLARE @oldFacID char(9) ,
>	@oldDate datetime,
>	@TransId char(9)
>SELECT @oldFacID= fac_id, @oldDate=date_issue, @TransId=corp_id
>FROM FACILITY
>INSERT TRANSACTIONS (fac_id, rcpfeedt,trans_id)
>VALUES (@oldFacID,@oldDate,@TransId)	
>END

>But it runs only for one record in table FACILITY.
>after that I've got a message:
>"Violation of PRIMARY KEY constraint 'PK_transactions'. Cannot insert duplicate key in object 'transactions'.
>The statement has been terminated."
>
>What i'm doing wrong ?
>Thank you in advance
>