same table data to different schema

To insert data from one schema's table into another schema's table in Microsoft SQL Server, you can use a simple INSERT INTO...SELECT statement. Here's the basic syntax:

INSERT INTO TargetSchema.TargetTable (Column1, Column2, ...)

SELECT Column1, Column2, ...

FROM SourceSchema.SourceTable;