Hi,

I would like to create a SQL Insert (for SQL Server DB) that would add records from one table to another and automatically set fields of certain values. Here is a simplified example:

The table which now has records. Name TENANT
Fields: TEN_PK, USER_ID, USER_PWRD

The table where the records should be added: Name TEN_NAME
Fields: TEN_PK, USER_ID, USER_PWRD (basically the same field names)

Example:
TENANT:
TEN_PK, USER_ID, USER_PWRD
1 "ABC" "123"
2 "CBS" "444"
3 "NBC" "9933"

After this SQL Insert the table TEN_NAMES will have the fields with the same values.

I am starting to write a SQL Insert but get lost quickly. I would appreciate any help.