I just like to know the command to copy data (specific range like 10 rows) containing in a COMPANY_CODE and will be copied to another COMPANY_CODE starting with a new accounts_code which will be different from the previous accounts_code in a same dbo.ACCOUNT_INFO table.

Structure of the table like

COMPANY_CODE ACCOUNTS_CODE ACCOUNTS DESCRIPTION

0001 18-01-0001-001 AR-SALEs ASSETS

0001 18-01-0001-002 AR-X ASSETS

0002 18-01-0001-001 AR-y ASSETS

0002 18-01-0001-002 AR-y ASSETS

last two record should be coppied to the company code 0001 starting from a defined account code and continue to add with by incremented by in the accounts code.