Red Gate forums :: View topic - Extraction after generation of data
Return to www.red-gate.com RSS Feed Available

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

Extraction after generation of data

Search in SQL Data Generator 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Praveen



Joined: 02 Nov 2011
Posts: 6

PostPosted: Fri Nov 04, 2011 5:08 am    Post subject: Extraction after generation of data Reply with quote

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..?
Back to top
View user's profile Send private message Send e-mail
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Mon Nov 07, 2011 6:34 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Praveen



Joined: 02 Nov 2011
Posts: 6

PostPosted: Tue Nov 08, 2011 5:04 am    Post subject: Reply with quote

thank you..
Back to top
View user's profile Send private message Send e-mail
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