I've had this problem in the past, If I remember rightly there's no easy way of doing this through SQL Data Generator.
One thing you could try is using the FOR XML clause from flat tables. I think you have to have certain options set on the table and database level for this to work.
This work for me on Adventure works using the Person.Contact table and the AdditionalContactInfo column... (Takes a few seconds for the screen to refresh)
- Code: Select all
SELECT TOP 1
ORDER BY NEWID()
FOR XML PATH('Contact') ,
Make sure you have Loop until number... Ticked.