How can we help you today? How can we help you today?

How do I get 2 columns from a table

Hi,

Struggling a bit with the data generator. What I want to do is use 2 columns from a SQL Server table to populate 2 columns in an empty table

I want the 2 columns to keep there relationship to each other ie

PropertyRef1 and PropertyRef2 are related and need to populate in the new table the same.

I have tried setting the seed to 0 and changing the population but with no luck. Any suggestions
Andrew Hodge
0

Comments

1 comment

Sort by
  • tilo23
    As far as I know you won't be able to do it in a simple way - but you can apply some workaround. I have this issue quite often, the MERGE script after generation works perfect for me. Details:
    http://technet.microsoft.com/en-us/libr ... 10625.aspx

    Seed is useful when you want to set NULLs in the same places; you may also use it if you want some columns to be identical, but doesn't work for the particular order on referencing other tables.
    tilo23
    0

Add comment

Please sign in to leave a comment.