Samrat Bhatnagar (4/28/2012)
These two part series were really useful. Thanks.Any suggestions on how to generate test data for following scenarios:
1. Two tables linked using PK-FK relationship e.g. Product Category and Product Subcategory
2. Self Referential Tables like the Employee table with EmployeeId, ManagerId, <Other employee details>
3. Using the master tables in 1, 2 generate a table that has ProductFK, EmployeeFK, <Some data> as in a Data warehouse.
Sure. I might be able to include some of that in part 3.
--Jeff Moden
Change is inevitable... Change for the better is not.