Options
can SQL DG calculate a column value?
icecurtain
Posts: 15
Just evaluting SQL data generator and if anyone can tell me if this is possible.
Circa 10,000,000 row need to be created.
COL A (Qty) = Random number 1-50
COL B (Qty_Delivered) must be lower than COL A
COL C (Qty_Outstanding) = A-B
COL D (Inv Total Price) = A*E
COL E (Price)= Random cost £1.00-£500.00
Col A and E are easy to produce.
Do I need to create a temp table or can this be done by script?
Circa 10,000,000 row need to be created.
COL A (Qty) = Random number 1-50
COL B (Qty_Delivered) must be lower than COL A
COL C (Qty_Outstanding) = A-B
COL D (Inv Total Price) = A*E
COL E (Price)= Random cost £1.00-£500.00
Col A and E are easy to produce.
Do I need to create a temp table or can this be done by script?
Comments
Thanks for your post. Unfortunately, it isn't possible to populate data for columns based on the sum of other columns, i.e. dictate a column relationship other than PK > FK.
We do however have this as an existing feature request in place of which I will add your request to, however I sorry to say that we don't have a timescale at the moment for if / when this feature is likely be implemented.
HTH!
Pete
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
It actually IS possible - you need to add a script creating trigger ON INSERT before the data generation. To do this Edit project and open Scripts tab.