Insert after running Select query in Stored Procedure

[DotNetDanjo]

I want a stored procedure to run a select query on it's own like this:
Select *, user_id As UserId FROM CC_host.dbo.usr_table Where(email LIKE N'%@%usa.com')

But from these results I want the same stored procedure to INSERT any new records (user_id as primary key) into the next table..

If Not Exists (Select [user_id] As UserId2 From Usr_Type_Data WHERE UserId2 = UserId)
INSERT INTO Usr_Type_Data (user_id, CustomerTypeId) VALUES(t1.UserId, 7)

How do I do this?

[azimmer]

I want a stored procedure to run a select query on it's own like this:
Select *, user_id As UserId FROM CC_host.dbo.usr_table Where(email LIKE N'%@%usa.com')

But from these results I want the same stored procedure to INSERT any new records (user_id as primary key) into the next table..

If Not Exists (Select [user_id] As UserId2 From Usr_Type_Data WHERE UserId2 = UserId)
INSERT INTO Usr_Type_Data (user_id, CustomerTypeId) VALUES(t1.UserId, 7)

How do I do this?

There are two ways I can think of: you either create a cursor and iterate it, or - better yet - do it in one go:

INSERT INTO Usr_Type_Data
SELECT user_id, 7
FROM CC_host.dbo.usr_table usr
WHERE (usr.email LIKE N'%@%usa.com')
AND usr.user_id not in (SELECT user_id from Usr_Type_Data)
 

[DotNetDanjo]

There are two ways I can think of: you either create a cursor and iterate it, or - better yet - do it in one go:

INSERT INTO Usr_Type_Data
SELECT user_id, 7
FROM CC_host.dbo.usr_table usr
WHERE (usr.email LIKE N'%@%usa.com')
AND usr.user_id not in (SELECT user_id from Usr_Type_Data)
 

WOW!!! Awesome skills dude!! :) Let me give it a try. :)