Red Gate forums :: View topic - Multiple Discrete Sections of Data to Generate
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Generator 1
SQL Data Generator 1 forum

Multiple Discrete Sections of Data to Generate

Search in SQL Data Generator 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
AdamChurvis



Joined: 09 Jan 2008
Posts: 4
Location: Atlanta

PostPosted: Mon Aug 04, 2008 8:40 pm    Post subject: Multiple Discrete Sections of Data to Generate Reply with quote

There are many times that we need to generate multiple discrete "clusters" of data within a single table, where each cluster may be defined by multiple columns having discrete combinations between them. For example, one cluster where Tablename.Status = Active and Tablename.InceptionDate is within one year of the current system date; another cluster where Tablename.Status = Invalidated and Tablename.DateOfReview is between a specified range; and third cluster where another set of conditions are met, etc.

If there was only a way to create multiple clusters like this using SQL Data Generator, and give a familiar name to each cluster, then I would be the happiest guy on the planet.

I'm serious. Take the supermodel guy who's boinking Halle Berry, add 15% more happiness, and that would be me. You could do that very thing for me -- *IF* you add this feature.
Back to top
View user's profile Send private message
SloopJohnB



Joined: 22 Jul 2006
Posts: 17

PostPosted: Wed Sep 24, 2008 9:19 pm    Post subject: Me Too Reply with quote

I'm wondering about forcing certain columns of fields together in a Null or not situation. Examples are:

    Address
    Name parts
    CC Info (date/num/name)

I'm trying, but the info doesn't make much sense if I have a 80% null scenario (for example), and trying to make sure that the values line up in some sort of logical sense.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group