Copying data between tables

How do we copy the data from one table to another in one go???

I mean, not by record by record. I want to copy some or all of the records of table1 to table2 with a single statement.

Hi Chiranjeevi, welcome to Dynamics User Group. Could you please use more descriptive topic names than “Hi” and add appropriate tags (which should include your version of AX)? Thank you.

Also, please provide as much information as possible next time - I’m not sure what exactly you need.

If you want to copy data for several records from one table to another, use insert_recordset. If you want to copy data between two buffers of the same table, use data() or buf2buf() methods.

Thanks a lot Martin…

I got what I wanted and I will take ur point for next posts.