I have to import users from the
usersToImport table into the
usersToImport contains telephone and e-mail information in a single row for each user, but
userContact stores one kind of contact information per row.
Here's how I'm doing it currently: http://sqlfiddle.com/#!6/c9b2e/1 (for some reason, it's not outputting anything, but the code works in SSMS).
Is there a way to do this without using two different selects? Maybe self-joining
usersToImport or using