How to generate a ColumnX in Table2 based on ColumnY from Table1

Jozef

Hi Guys,

I'm new here and I tried to find answer to my question, but without success .... I was able to find similar question, but there wasn't answer or any solution. Provided solutions are working only with already existing data, there is not (or I haven't found) solution for clean empty database.

I've got empty database and I want to generate data into it to have decent data set to work with. Partial model is:
Scheme:
ID [PK]
HomeURL

CustomerDetails:
ID [PK]
Title
SchemeID [FK]
CustomerURL -> this column should be combined from Scheme.HomeURL+CustomerDetails.Title

Example...
Scheme:
35, https://example.com/product/
55, https://example2.net/product/

CustomerDetails:
1135, Customer9875, 35, https://example.com/product/Customer9875
7515, Customer3543, 55, https://example2.net/product/Customer3543

Do you have any suggestions or solution how to achieve this, PLEASE?
Thanks in advance.

RichardL

Hi @Jozef

Welcome to the community.

You might be able to get some advice from our members.

This does look like a question that one of Support engineers might need to investigate for you though.

If you've a got support contract, please send us a ticket. Provide as much information as you can - screenshots of any errors, log files etc – so we can help you as fast as possible.
If you're not covered by a Support contract at the moment, email our Sales team at sales@red-gate.com, and they'll be able to help.

Alternatively you can check out the product documentation from my link below.

https://documentation.red-gate.com/sdg4

You can put in specific search terms in the top-right hand search bar.

Kind regards