Hi ,
check this
Create PROCEDURE usp_test
(@name nvarchar(50))
AS
BEGIN
IF NOT EXISTS(select name from dbo.Table_2 where name=@name)
Begin
INSERT INTO dbo.Table_2 (name)
SELECT name FROM dbo.Table_1 WHERE name =@name
END
ELSE
BEGIN
select -1
END
END
Best Regards
M.Miotwalli