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

JozefJozef New memberPosts: 1 New member
edited February 22, 2018 12:01PM in SQL Data Generator
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.
Tagged:

Answers

  • RichardLRichardL Gold 4 Posts: 418 Gold 4
    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 [email protected], 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
    Customer Support
    Redgate Software
Sign In or Register to comment.