Query-Urgent

  • Table:Temp

    OwnerName/FatherName/RationCardnO

    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

    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 3 fields of Temp1 table

    my Temp1 table as 3 columns

    OwnerName

    FatherName

    RationCardNo

    Plz give me q query to insert

  • OwnerName/FatherName/RationCardnO

    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

    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

    Please specify the values for "OwnerName". "FatherName", "RationCardnO" in above lines. Can you differentiate them any how?

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

  • insert into #TempTable (OwnerName, FatherName, RationCardnO)

    values ('Aakula Anjaiah','Veeraiah Wap','6825011205')

    And so on, for each set of values.

    Is that what you need?

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

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

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