Choose a random value from another table column

Sanjshah · January 10, 2019 7:42PM

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

squigley · January 12, 2019 1:50AM

It should be possible using the Generic>SQL Statement generator

https://documentation.red-gate.com/sdg4/using-generators/generic-generators#Genericgenerators-SQLStatementgenerator

sam.blackburn · January 14, 2019 5:16PM

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

Choose a random value from another table column

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk