when you put your mind to it, anything is possible
Copying rows from one table to another in MSSQL
To copy specific rows from one table to another in MSSQL you will want to run something like:
insert into destinationtable select * from sourcetable where column = ”
So for example, if you wanted to restored rows from your sourcetable where userid has DOMAIN.COM in it, your query would look like:
insert into destinationtable select * from sourcetable where userid like ‘%DOMAIN.COM’
