Extraction after generation of data

The simplest way to populate your database with test data.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Michelle Taylor, Lionel, Emma A, sherr

Extraction after generation of data

Postby Praveen » Fri Nov 04, 2011 5:08 am

Hi,
I need to create a table with follwing columns as ID,name,subject_1,subject_2.
And I have created the table, also generated the data in RED GATE SQL Generator.
After generating data, The column "name" will have values of both MALE and FEMALE.
My question is that, IS THERE ANY POSSIBILITY TO Extract only MALE/FEMALE names from the column and store in separate column..?
Praveen
 
Posts: 6
Joined: Wed Nov 02, 2011 1:31 pm

Postby Chris Auckland » Mon Nov 07, 2011 6:34 pm

Thanks for your post.

This should be fairly straight forward if you add some way to identify if a name is male or female.

If there isn't a column for gender, then there isn't any way to know which sex the name is.

I would probably suggest adding another column (probably gender) that you can record if the name is male or female, and then filter on WHERE gender = 'male'/'female'.
Chris
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.

Postby Praveen » Tue Nov 08, 2011 5:04 am

thank you..
Praveen
 
Posts: 6
Joined: Wed Nov 02, 2011 1:31 pm


Return to SQL Data Generator 2

Who is online

Users browsing this forum: No registered users and 0 guests