Choose a random value from another table column

Sanjshah

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

It should be possible using the Generic>SQL Statement generator

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

sam.blackburn

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