MS SQL Server 2012
My database has a UsersProfile table that is related to a Property Definitions table.
Assume property definitions are just for users' contact info such as street, city. email, etc.
So the UsersProfile table looks as follows...
I want a query that will add a row for PropertyDefinition =31 and PropertyValue = 'United States' to each user that does not have such data.
Attached is sample data of the UserProfile table in an xl file.