Luv SQL (8/24/2016)

---

This seems fairly simple, yet I've never been able to do this without multiple steps. I'm creating a sp to check to see if a field exists in Table A for any value in Table B. If there is a field in Table B that is not in Table A then I want to take that field and insert it, along with some constants, an incremental value (based on Max in Table A) for a specific record in Table A.

Basically the purpose of this is for any new user created in Table B, I want this job to run the sp to insert this new User's ID into this other Table, with a sequence field in Table A (non-identity) and the value of another field in Table A is based on a specific user (mine).

I can achieve what I want if I manually type in the UserName but then I have to do this for 50 other users, then it's manual for all new users. Here is the code for the manual insert:

insert into TableA

(UserName,Sequence,Title,Signature,IsDefault)

select '<insertUserID>',(select Max(Sequence+1) from TableA),Title,Signature,'Y'

from TableA

where UserName='me'

I've created a sp and have temp table that grabs all the new UserNames that I need to do this for (#TempNewUsers).

1. How do I add all of these UserNames from #TempNewUsers into this select statement?

2. Will the Sequence+1 put the same value for all items or will it +1 per each UserName ie do I have to declare a variable first then add 1 for each UserName?