Hi

The 2nd table will only have 1 entry for the person employment status from the first table whether it would be "Manager", "Fired" or "Enjoy Life". It will not contain...

Hi

It will be used in another table where it will be queried, I just need an example of how to insert the 3 columns into a single column. Can you...

Hi

Can you send me an example on how to add 3 columns to a single column as stated above?

Regards

Raxso

Hi

The employment status depending on the Name would be "Manager", "Fired", "Enjoying Life". I basically need to insert 3 different columns into a single column.

I just need some examples.

Regards

Raxso

Hi

The employment status depending on the Name would be "Manager", "Fired", "Enjoying Life". I basically need to insert 3 different columns into a single column.

Regards

Raxso

Hi Jeffrey

The first option would be a good example to use.

Regards

Raxso

Hi

The values will be the same for each column for example:

Employed (String) - "Manager"

Non-Employed (String) - "Fired"

Retired (String) - "Enjoying Life"

Regards

Rax

Hi Phil

Thanks for the update, worked a charm.

Regards

Hi

The SQL server can backup to the storage account and I can restore the database using T-SQL i.e.

RESTORE

Thanks for the responses.

Will look at Ola's scripts