Choose a random value from another table column

Hi,

Is it possible to populate a field from a table in another table column?

i.e. if I have a table tbl_companydetails which contains a field clientname that I would like the table I would like to populate to get the value from?

Regards

Sanjay Shah January 10, 2019 19:42

Comments

2 comments

It should be possible using the Generic>SQL Statement generator
https://documentation.red-gate.com/sdg4/using-generators/generic-generators#Genericgenerators-SQLStatementgenerator

squigley January 12, 2019 01:50

0
Yes, you can do it using Python. Here are some example scripts to solve similar sorts of problems:

https://documentation.red-gate.com/display/SDG4/Example+Python+scripts

sam.blackburn January 14, 2019 17:16

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Choose a random value from another table column

Comments

Add comment