query-insert

Question

Post reply

query-insert

satishthota

SSC Eights!

Points: 959
More actions
April 23, 2009 at 3:02 am

#208663

The separtaion must be s/o (or) w/o (fathername), wap (or) pap (or) yap (RationCardNo)
1) It had total one string means In one string more than one owner,father name, rationcardno(may be or may not be) comes
2) In a string First Ownername(Aakula Anjaiah) second one is father name(S/o Veeraiah) and third one is RationCardno(Wap 6825011205) and again follows owner name/father name/rationcardno
Table:Temp
SID OwnerName/FatherName/RationCardnO
S001 Aakula Anjaiah S/o Veeraiah Wap 6825011205 Aakula
Sada Nandam S/o Veeraiah Aakula Veeraiah S/o Bhumaiah Wap
Aakula Shivadeenam S/o Veeraiah Wap 7825011257
S002 Sayad Ajimuddin S/o Bhasumiya Wap 6825010014 Shaik
Shassina Begam W/o Moulana Wap 1883913037 Syed Alina
W/o Bhasu Wap 883910321 Syed Nabhi S/o Bhasu Syed
Mahaboob Ali S/o Bhasu Wap 3839130147 Syed Ali
S/o Bhasumiya
I had Temp Table with one column as OwnerName/FatherName/RationCardnO
I want to insert above values into 4 fields of Temp1 table
my Temp1 table as 4 columns
SID
OwnerName
FatherName
RationCardNo
Plz give me a query to insert

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

I may be mis-understanding the question, but INSERT is really well explained in Books On Line;

if the table exists, it simply

INSERT INTO TABLENAME(columnList)

select columnlist from someTable

to create thetable "on the fly", straight from the select, it's

SELECT columnlist

INTO NEWTABLENAME

FROM SOMETABLE

I'm assuming you are new to TSQL and are not yet comfortable with the INSERT command; what have you tried so far?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Kruti Kansara Hall of Fame Points: 3118 More actions · Answer 2

@satishthota

I think you have posted a topic regarding same earlier also. Please continue the same topic, as both seems related.

The separtaion must be s/o (or) w/o (fathername), wap (or) pap (or) yap (RationCardNo)
1) It had total one string means In one string more than one owner,father name, rationcardno(may be or may not be) comes
2) In a string First Ownername(Aakula Anjaiah) second one is father name(S/o Veeraiah) and third one is RationCardno(Wap 6825011205) and again follows owner name/father name/rationcardno

Your column data are still not in position to separate on any solid bases.

for example, in below line

S001 Aakula Anjaiah S/o Veeraiah Wap 6825011205 Aakula
Sada Nandam S/o Veeraiah Aakula Veeraiah S/o Bhumaiah Wap
Aakula Shivadeenam S/o Veeraiah Wap 7825011257

record-1

owner name: Aakula Anjaiah

separated by: S/o

father name: Veeraiah

separated by: Wap

RationCardno: 6825011205

record-2

owner name: Aakula Sada Nandam

separated by: S/o

father name: Veeraiah Aakula Veeraiah (???????????)

Now,

1) There isnt any separation for now record after RationCardNo, OR you might consider the single word for Rationcardno.

2) Look in record-2. You cannot separate father name and the end of record.

So, I strongly feel that you have to change the string in your column, and add some character to separate the individual record OR change your table/application structure to insert data.

"Don't limit your challenges, challenge your limits"

Lowell SSC Guru Points: 323518 More actions · Answer 3

Thanks to kruti's insight, i think i see your problem.

your datasource makes no sense to anyone, so noone can really help.

I'm assuming that this is a list of names/family members, with one SID per family.

your data is not in any standard format, so it's gotta be cleaned up before anyone can offer any suggestions;

what does S/o w/o mean, for example? why do some people have a RationCardNo and others do not?

look at the way i formatted this? is this how the one SID should really be if it were a table? see how there are holes/missing fields if the data is formatted out this way?

you've got to get teh data into a REAL table structure (CREATE TABLE ...) complete with the insert statements in order for us to be able to help and interpret your quesiton.

SID OwnerName FatherName RationCardNo

S001 Aakula Anjaiah S/o Veeraiah Wap 6825011205

Aakula Sada Nandam S/o Veeraiah Aakula Veeraiah

S/o Bhumaiah Wap

Aakula Shivadeenam S/o Veeraiah Wap 7825011257

S002 Sayad Ajimuddin S/o Bhasumiya Wap 6825010014

Shaik Shassina Begam W/o Moulana Wap 1883913037

Syed Alina W/o Bhasu Wap 883910321

Syed Nabhi S/o Bhasu Syed

Mahaboob Ali S/o Bhasu Wap 3839130147

Syed Ali S/o Bhasumiya

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!