Copy Stored Procedure

[joshp1217]

I need to write a stored procedure that will copy rows from one table and insert them an another table based on a unique id. Any Ideas? I am very new to writing stored procedures so any help would be greatly appreciated. Thank You

[Elina Blank]

To create stored procedure write following

CREATE PROCEDURE [procedureName]

After that, just write your query. Example: CREATE PROCEDURE copyData @selectID int AS SELECT ID, Name INTO newTable FROM origTable WHERE origTable.ID = @selectID

Sincerely, Elina Life is great!!! Enjoy every moment of it! :-O

[Navi15]

Try this Copying a Table into an Existing Table insert into originaltable select * from mytablecopy where [Condition] Navi