Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
abuzar
Starting Member
20 Posts |
Posted - 2013-12-09 : 15:36:45
|
hii all..i am studying in it field i have a query given below plz do reply thank you all in advance.CREATE TABLE tbl_statelist(S_ID int identity primary key , state_name varchar(50) NOT NULL)drop TABLE tbl_statelistA) table tbl_statelistS_ID state_name1 ANDAMAN AND NICOBAR ISLANDS2 ANDHRA PRADESH3 ARUNACHAL PRADESH4 ASSAM5 BIHAR6 CHATTISGARH7 CHANDIGARH8 DAMAN AND DIU9 DELHI10 DADRA AND NAGAR HAVELI11 GOA12 GUJARAT13 HIMACHAL PRADESH14 HARYANA15 JAMMU AND KASHMIR16 JHARKHAND17 KERALA18 KARNATAKA19 LAKSHADWEEP20 MEGHALAYA21 MAHARASHTRA22 MANIPUR23 MADHYA PRADESH24 MIZORAM25 NAGALAND26 ORISSA27 PUNJAB28 PONDICHERRY29 RAJASTHAN30 SIKKIM31 TAMIL NADU32 TRIPURA33 UTTARAKHAND34 UTTAR PRADESH35 WEST BENGAL36 UTTARANCHALB) Table tbl_cityCreate TABLE tbl_citylist(C_ID int identity primary key , S_ID int foreign key references tbl_statelist(S_ID), city_name varchar(50) NOT NULL, state_name varchar(50) NOT NULL) C_ID S_ID city_name state_name1 NULL ADILABAD ANDHRA PRADESH2 NULL PORT BLAIR ANDAMAN AND NICOBAR ISLANDS3 NULL ADONI ANDHRA PRADESH4 NULL ALWAL ANDHRA PRADESH5 NULL ANAKAPALLE ANDHRA PRADESH6 NULL ANANTAPUR ANDHRA PRADESH7 NULL BAPATLA ANDHRA PRADESH8 NULL BELAMPALLI ANDHRA PRADESH9 NULL BHIMAVARAM ANDHRA PRADESH10 NULL BHONGIR ANDHRA PRADESH11 NULL BOBBILI ANDHRA PRADESH12 NULL BODHAN ANDHRA PRADESH13 NULL CHILAKALURUPET ANDHRA PRADESH14 NULL CHINNA CHAWK ANDHRA PRADESH15 NULL CHIRALA ANDHRA PRADESH16 NULL CHITTUR ANDHRA PRADESH17 NULL CUDDAPAH ANDHRA PRADESH18 NULL DHARMAVARAM ANDHRA PRADESH19 NULL DHONE ANDHRA PRADESH20 NULL ELURU ANDHRA PRADESH21 NULL GADDIANNARAM ANDHRA PRADESH22 NULL GADWAL ANDHRA PRADESH23 NULL GAJUWAKA ANDHRA PRADESH24 NULL GUDIVADA ANDHRA PRADESH25 NULL GUDUR ANDHRA PRADESH26 NULL GUNTAKAL ANDHRA PRADESH27 NULL GUNTUR ANDHRA PRADESH28 NULL HINDUPUR ANDHRA PRADESH29 NULL HYDERABAD ANDHRA PRADESH30 NULL JAGTIAL ANDHRA PRADESH31 NULL KADIRI ANDHRA PRADESH32 NULL KAGAZNAGAR ANDHRA PRADESH33 NULL KAKINADA ANDHRA PRADESH34 NULL KALLUR ANDHRA PRADESH35 NULL KAMAREDDI ANDHRA PRADESH36 NULL KAPRA ANDHRA PRADESH37 NULL KARIMNAGAR ANDHRA PRADESH38 NULL KARNUL ANDHRA PRADESH39 NULL KAVALI ANDHRA PRADESH40 NULL KHAMMAM ANDHRA PRADESH41 NULL KODAR ANDHRA PRADESH42 NULL KONDUKUR ANDHRA PRADESH43 NULL KORATLA ANDHRA PRADESH44 NULL KOTTAGUDEM ANDHRA PRADESH45 NULL KUKATPALLE ANDHRA PRADESH46 NULL LALBAHADUR NAGAR ANDHRA PRADESH47 NULL MACHILIPATNAM ANDHRA PRADESH48 NULL MAHBUBNAGAR ANDHRA PRADESH49 NULL MALKAJGIRI ANDHRA PRADESH50 NULL MANCHERAL ANDHRA PRADESH51 NULL MANDAMARRI ANDHRA PRADESH52 NULL MANGALAGIRI ANDHRA PRADESH53 NULL MARKAPUR ANDHRA PRADESH54 NULL MIRYALAGUDA ANDHRA PRADESH55 NULL NALGONDA ANDHRA PRADESH56 NULL NANDYAL ANDHRA PRADESH57 NULL NARASAPUR ANDHRA PRADESH58 NULL NARASARAOPET ANDHRA PRADESH59 NULL NELLUR ANDHRA PRADESH60 NULL NIRMAL ANDHRA PRADESH61 NULL NIZAMABAD ANDHRA PRADESH62 NULL NUZVID ANDHRA PRADESH63 NULL ONGOLE ANDHRA PRADESH64 NULL PALAKOLLU ANDHRA PRADESH65 NULL PALASA ANDHRA PRADESH66 NULL PALWANCHA ANDHRA PRADESH67 NULL PATANCHERU ANDHRA PRADESH68 NULL PIDUGURALLA ANDHRA PRADESH69 NULL PONNUR ANDHRA PRADESH70 NULL PRODDATUR ANDHRA PRADESH71 NULL QUTUBULLAPUR ANDHRA PRADESH72 NULL RAJAMAHENDRI ANDHRA PRADESH73 NULL RAJAMPET ANDHRA PRADESH74 NULL RAJENDRANAGAR ANDHRA PRADESH75 NULL RAMACHANDRAPURAM ANDHRA PRADESH76 NULL RAMAGUNDAM ANDHRA PRADESH77 NULL RAYACHOTI ANDHRA PRADESH78 NULL RAYADRUG ANDHRA PRADESH79 NULL SAMALKOT ANDHRA PRADESH80 NULL SANGAREDDI ANDHRA PRADESH81 NULL SATTENAPALLE ANDHRA PRADESH82 NULL SERILUNGAMPALLE ANDHRA PRADESH83 NULL SIDDIPET ANDHRA PRADESH84 NULL SIKANDARABAD ANDHRA PRADESH85 NULL SIRSILLA ANDHRA PRADESH86 NULL SRIKAKULAM ANDHRA PRADESH87 NULL SRIKALAHASTI ANDHRA PRADESH88 NULL SURIAPET ANDHRA PRADESH89 NULL TADEPALLE ANDHRA PRADESH90 NULL TADEPALLEGUDEM ANDHRA PRADESH91 NULL TADPATRI ANDHRA PRADESH92 NULL TANDUR ANDHRA PRADESH93 NULL TANUKU ANDHRA PRADESH94 NULL TENALI ANDHRA PRADESH95 NULL TIRUPATI ANDHRA PRADESH96 NULL TUNI ANDHRA PRADESH97 NULL UPPAL KALAN ANDHRA PRADESH98 NULL VIJAYAWADA ANDHRA PRADESH99 NULL VINUKONDA ANDHRA PRADESH100 NULL VISAKHAPATNAM ANDHRA PRADESH101 NULL VIZIANAGARAM ANDHRA PRADESH102 NULL VUYYURU ANDHRA PRADESH103 NULL WANPARTI ANDHRA PRADESH104 NULL WARANGAL ANDHRA PRADESH105 NULL YEMMIGANUR ANDHRA PRADESH106 NULL ITANAGAR ARUNACHAL PRADESH107 NULL BARPETA ASSAM108 NULL BONGAIGAON ASSAM109 NULL DHUBURI ASSAM110 NULL DIBRUGARH ASSAM111 NULL DIPHU ASSAM112 NULL GUWAHATI ASSAM113 NULL JORHAT ASSAM114 NULL KARIMGANJ ASSAM115 NULL LAKHIMPUR ASSAM116 NULL LANKA ASSAM117 NULL NAGAON ASSAM118 NULL SIBSAGAR ASSAM119 NULL SILCHAR ASSAM120 NULL TEZPUR ASSAM121 NULL TINSUKIA ASSAM122 NULL ALIPUR DUAR WEST BENGAL123 NULL ARAMBAGH WEST BENGAL124 NULL ASANSOL WEST BENGAL125 NULL ASHOKNAGAR KALYANGARH WEST BENGAL126 NULL BAHARAMPUR WEST BENGAL127 NULL BAIDYABATI WEST BENGAL128 NULL BAJ BAJ WEST BENGAL129 NULL BALLY WEST BENGAL130 NULL BALLY CANTONMENT WEST BENGAL131 NULL BALURGHAT WEST BENGAL132 NULL BANGAON WEST BENGAL133 NULL BANKRA WEST BENGAL134 NULL BANKURA WEST BENGAL135 NULL BANSBARIA WEST BENGAL136 NULL BARANAGAR WEST BENGAL137 NULL BARDDHAMAN WEST BENGAL138 NULL BASIRHAT WEST BENGAL139 NULL BHADRESWAR WEST BENGAL140 NULL BHATPARA WEST BENGAL141 NULL BIDHANNAGAR WEST BENGAL142 NULL BINNAGURI WEST BENGAL143 NULL BISHNUPUR WEST BENGAL144 NULL BOLPUR WEST BENGAL145 NULL CALCUTTA WEST BENGAL146 NULL CHAKDAHA WEST BENGAL147 NULL CHAMPDANI WEST BENGAL148 NULL CHANDANNAGAR WEST BENGAL149 NULL CONTAI WEST BENGAL150 NULL DABGRAM WEST BENGAL151 NULL DARJILING WEST BENGAL152 NULL DHULIAN WEST BENGAL153 NULL DINHATA WEST BENGAL154 NULL DUM DUM WEST BENGAL155 NULL DURGAPUR WEST BENGAL156 NULL GANGARAMPUR WEST BENGAL157 NULL GARULIA WEST BENGAL158 NULL GAYESPUR WEST BENGAL159 NULL GHATAL WEST BENGAL160 NULL GOPALPUR WEST BENGAL161 NULL HABRA WEST BENGAL162 NULL HALISAHAR WEST BENGAL163 NULL HAORA WEST BENGAL164 NULL HUGLICHUNCHURA WEST BENGAL165 NULL INGRAJ BAZAR WEST BENGAL166 NULL ISLAMPUR WEST BENGAL167 NULL JALPAIGURI WEST BENGAL168 NULL JAMURIA WEST BENGAL169 NULL JANGIPUR WEST BENGAL170 NULL JHARGRAM WEST BENGAL171 NULL KALIYAGANJ WEST BENGAL172 NULL KALNA WEST BENGAL173 NULL KALYANI WEST BENGAL174 NULL KAMARHATI WEST BENGAL175 NULL KANCHRAPARA WEST BENGAL176 NULL KANDI WEST BENGAL177 NULL KARSIYANG WEST BENGAL178 NULL KATWA WEST BENGAL179 NULL KHARAGPUR WEST BENGAL180 NULL KHARAGPUR RAILWAY SETTLEMENT WEST BENGAL181 NULL KHARDAHA WEST BENGAL182 NULL KHARIA WEST BENGAL183 NULL KOCH BIHAR WEST BENGAL184 NULL KONNAGAR WEST BENGAL185 NULL KRISHNANAGAR WEST BENGAL186 NULL KULTI WEST BENGAL187 NULL MADHYAMGRAM WEST BENGAL188 NULL MAHESHTALA WEST BENGAL189 NULL MEMARI WEST BENGAL190 NULL MIDNAPUR WEST BENGAL191 NULL NAIHATI WEST BENGAL192 NULL NAVADWIP WEST BENGAL193 NULL NI BARAKPUR WEST BENGAL194 NULL NORTH BARAKPUR WEST BENGAL195 NULL NORTH DUM DUM WEST BENGAL196 NULL OLD MALDAH WEST BENGAL197 NULL PANIHATI WEST BENGAL198 NULL PHULIA WEST BENGAL199 NULL PUJALI WEST BENGAL200 NULL PURULIYA WEST BENGAL201 NULL RAIGANJ WEST BENGAL202 NULL RAJPUR WEST BENGAL203 NULL RAMPUR HAT WEST BENGAL204 NULL RANAGHAT WEST BENGAL205 NULL RANIGANJ WEST BENGAL206 NULL RISHRA WEST BENGAL207 NULL SHANTIPUR WEST BENGAL208 NULL SHILIGURI WEST BENGAL209 NULL SHRIRAMPUR WEST BENGAL210 NULL SIURI WEST BENGAL211 NULL SOUTH DUM DUM WEST BENGAL212 NULL TITAGARH WEST BENGAL213 NULL ULUBARIA WEST BENGAL214 NULL UTTARPARAKOTRUNG WEST BENGAL215 NULL ARARIA BIHAR216 NULL ARRAH BIHAR217 NULL AURANGABAD BIHAR218 NULL BAGAHA BIHAR219 NULL BEGUSARAI BIHAR220 NULL BETTIAH BIHAR221 NULL BHABUA BIHAR222 NULL BHAGALPUR BIHAR223 NULL BIHAR BIHAR224 NULL BUXAR BIHAR225 NULL CHHAPRA BIHAR226 NULL DARBHANGA BIHAR227 NULL DEHRI BIHAR228 NULL DIGHAMAINPURA BIHAR229 NULL DINAPUR BIHAR230 NULL DUMRAON BIHAR231 NULL GAYA BIHAR232 NULL GOPALGANJ BIHAR233 NULL GOURA BIHAR234 NULL HAJIPUR BIHAR235 NULL JAHANABAD BIHAR236 NULL JAMALPUR BIHAR237 NULL JAMUI BIHAR238 NULL KATIHAR BIHAR239 NULL KHAGARIA BIHAR240 NULL KHAGAUL BIHAR241 NULL KISHANGANJ BIHAR242 NULL LAKHISARAI BIHAR243 NULL MADHIPURA BIHAR244 NULL MADHUBANI BIHAR245 NULL MASAURHI BIHAR246 NULL MOKAMA BIHAR247 NULL MOTIHARI BIHAR248 NULL MUNGER BIHAR249 NULL MUZAFFARPUR BIHAR250 NULL NAWADA BIHAR251 NULL PATNA BIHAR252 NULL PHULWARI BIHAR253 NULL PURNIA BIHAR254 NULL RAXAUL BIHAR255 NULL SAHARSA BIHAR256 NULL SAMASTIPUR BIHAR257 NULL SASARAM BIHAR258 NULL SITAMARHI BIHAR259 NULL SIWAN BIHAR260 NULL SUPAUL BIHAR261 NULL CHANDIGARH CHANDIGARH262 NULL AMBIKAPUR CHHATTISGARH263 NULL BHILAI CHHATTISGARH264 NULL BILASPUR CHHATTISGARH265 NULL CHARODA CHHATTISGARH266 NULL CHIRMIRI CHHATTISGARH267 NULL DHAMTARI CHHATTISGARH268 NULL DURG CHHATTISGARH269 NULL JAGDALPUR CHHATTISGARH270 NULL KORBA CHHATTISGARH271 NULL RAIGARH CHHATTISGARH272 NULL RAIPUR CHHATTISGARH273 NULL RAJNANDGAON CHHATTISGARH274 NULL BHALSWA JAHANGIRPUR DELHI275 NULL BURARI DELHI276 NULL CHILLA SARODA BANGAR DELHI277 NULL DALLO PURA DELHI278 NULL DELHI DELHI279 NULL DEOLI DELHI280 NULL DILLI CANTONMENT DELHI281 NULL GHAROLI DELHI282 NULL GOKALPUR DELHI283 NULL HASTSAL DELHI284 NULL JAFFRABAD DELHI285 NULL KARAWAL NAGAR DELHI286 NULL KHAJURI KHAS DELHI287 NULL KIRARI SULEMAN NAGAR DELHI288 NULL MANDOLI DELHI289 NULL MITHE PUR DELHI290 NULL MOLARBAND DELHI291 NULL MUNDKA DELHI292 NULL MUSTAFABAD DELHI293 NULL NANGLOI JAT DELHI294 NULL NI DILLI DELHI295 NULL PUL PEHLAD DELHI296 NULL PUTH KALAN DELHI297 NULL ROSHAN PURA DELHI298 NULL SADAT PUR GUJRAN DELHI299 NULL SULTANPUR MAJRA DELHI300 NULL TAJPUL DELHI301 NULL TIGRI DELHI302 NULL ZIAUDDIN PUR DELHI303 NULL MADGAON GOA304 NULL MORMUGAO GOA305 NULL PANAJI GOA306 NULL AHMADABAD GUJARAT307 NULL AMRELI GUJARAT308 NULL ANAND GUJARAT309 NULL ANJAR GUJARAT310 NULL BARDOLI GUJARAT311 NULL BHARUCH GUJARAT312 NULL BHAVNAGAR GUJARAT313 NULL BHUJ GUJARAT314 NULL BORSAD GUJARAT315 NULL BOTAD GUJARAT316 NULL CHANDKHEDA GUJARAT317 NULL CHANDLODIYA GUJARAT318 NULL DABHOI GUJARAT319 NULL DAHOD GUJARAT320 NULL DHOLKA GUJARAT321 NULL DHORAJI GUJARAT322 NULL DHRANGADHRA GUJARAT323 NULL DISA GUJARAT324 NULL GANDHIDHAM GUJARAT325 NULL GANDHINAGAR GUJARAT326 NULL GHATLODIYA GUJARAT327 NULL GODHRA GUJARAT328 NULL GONDAL GUJARAT329 NULL HIMATNAGAR GUJARAT330 NULL JAMNAGAR GUJARAT331 NULL JAMNAGAR GUJARAT332 NULL JETPUR GUJARAT333 NULL JUNAGADH GUJARAT334 NULL KALOL GUJARAT335 NULL KESHOD GUJARAT336 NULL KHAMBHAT GUJARAT337 NULL KUNDLA GUJARAT338 NULL MAHUVA GUJARAT339 NULL MANGROL GUJARAT340 NULL MODASA GUJARAT341 NULL MORVI GUJARAT342 NULL NADIAD GUJARAT343 NULL NAVAGAM GHED GUJARAT344 NULL NAVSARI GUJARAT345 NULL PALITANA GUJARAT346 NULL PATAN GUJARAT347 NULL PORBANDAR GUJARAT348 NULL PUNA GUJARAT349 NULL RAJKOT GUJARAT350 NULL RAMOD GUJARAT351 NULL RANIP GUJARAT352 NULL SIDDHAPUR GUJARAT353 NULL SIHOR GUJARAT354 NULL SURAT GUJARAT355 NULL SURENDRANAGAR GUJARAT356 NULL THALTEJ GUJARAT357 NULL UNA GUJARAT358 NULL UNJHA GUJARAT359 NULL UPLETA GUJARAT360 NULL VADODARA GUJARAT361 NULL VALSAD GUJARAT362 NULL VAPI GUJARAT363 NULL VASTRAL GUJARAT364 NULL VEJALPUR GUJARAT365 NULL VERAVAL GUJARAT366 NULL VIJALPOR GUJARAT367 NULL VISNAGAR GUJARAT368 NULL WADHWAN GUJARAT369 NULL AMBALA HARYANA370 NULL AMBALA CANTONMENT HARYANA371 NULL AMBALA SADAR HARYANA372 NULL BAHADURGARH HARYANA373 NULL BHIWANI HARYANA374 NULL CHARKHI DADRI HARYANA375 NULL DABWALI HARYANA376 NULL FARIDABAD HARYANA377 NULL GOHANA HARYANA378 NULL HISAR HARYANA379 NULL JAGADHRI HARYANA380 NULL JIND HARYANA381 NULL KAITHAL HARYANA382 NULL KARNAL HARYANA383 NULL NARNAUL HARYANA384 NULL NARWANA HARYANA385 NULL PALWAL HARYANA386 NULL PANCHKULA HARYANA387 NULL PANIPAT HARYANA388 NULL REWARI HARYANA389 NULL ROHTAK HARYANA390 NULL SIRSA HARYANA391 NULL SONIPAT HARYANA392 NULL THANESAR HARYANA393 NULL TOHANA HARYANA394 NULL YAMUNANAGAR HARYANA395 NULL SHIMLA HIMACHAL PRADESH396 NULL ANANTNAG JAMMU AND KASHMIR397 NULL BARAMULA JAMMU AND KASHMIR398 NULL BARI BRAHMANA JAMMU AND KASHMIR399 NULL JAMMU JAMMU AND KASHMIR400 NULL KATHUA JAMMU AND KASHMIR401 NULL SOPUR JAMMU AND KASHMIR402 NULL SRINAGAR JAMMU AND KASHMIR403 NULL UDHAMPUR JAMMU AND KASHMIR404 NULL ADITYAPUR JHARKHAND405 NULL BAGBAHRA JHARKHAND406 NULL BHULI JHARKHAND407 NULL BOKARO JHARKHAND408 NULL CHAIBASA JHARKHAND409 NULL CHAS JHARKHAND410 NULL DALTENGANJ JHARKHAND411 NULL DEVGHAR JHARKHAND412 NULL DHANBAD JHARKHAND413 NULL HAZARIBAG JHARKHAND414 NULL JAMSHEDPUR JHARKHAND415 NULL JHARIA JHARKHAND416 NULL JHUMRI TILAIYA JHARKHAND417 NULL JORAPOKHAR JHARKHAND418 NULL KATRAS JHARKHAND419 NULL LOHARDAGA JHARKHAND420 NULL MANGO JHARKHAND421 NULL PHUSRO JHARKHAND422 NULL RAMGARH JHARKHAND423 NULL RANCHI JHARKHAND424 NULL SAHIBGANJ JHARKHAND425 NULL SAUNDA JHARKHAND426 NULL SINDARI JHARKHAND427 NULL BAGALKOT KARNATAKA428 NULL BANGALORE KARNATAKA429 NULL BASAVAKALYAN KARNATAKA430 NULL BELGAUM KARNATAKA431 NULL BELLARY KARNATAKA432 NULL BHADRAVATI KARNATAKA433 NULL BIDAR KARNATAKA434 NULL BIJAPUR KARNATAKA435 NULL BOMMANAHALLI KARNATAKA436 NULL BYATARAYANAPURA KARNATAKA437 NULL CHALLAKERE KARNATAKA438 NULL CHAMRAJNAGAR KARNATAKA439 NULL CHANNAPATNA KARNATAKA440 NULL CHIK BALLAPUR KARNATAKA441 NULL CHIKMAGALUR KARNATAKA442 NULL CHINTAMANI KARNATAKA443 NULL CHITRADURGA KARNATAKA444 NULL DASARAHALLI KARNATAKA445 NULL DAVANAGERE KARNATAKA446 NULL DOD BALLAPUR KARNATAKA447 NULL GADAG KARNATAKA448 NULL GANGAWATI KARNATAKA449 NULL GOKAK KARNATAKA450 NULL GULBARGA KARNATAKA451 NULL HARIHAR KARNATAKA452 NULL HASSAN KARNATAKA453 NULL HAVERI KARNATAKA454 NULL HIRIYUR KARNATAKA455 NULL HOSAKOTE KARNATAKA456 NULL HOSPET KARNATAKA457 NULL HUBLI KARNATAKA458 NULL ILKAL KARNATAKA459 NULL JAMKHANDI KARNATAKA460 NULL KANAKAPURA KARNATAKA461 NULL KARWAR KARNATAKA462 NULL KOLAR KARNATAKA463 NULL KOLLEGAL KARNATAKA464 NULL KOPPAL KARNATAKA465 NULL KRISHNARAJAPURA KARNATAKA466 NULL MAHADEVAPURA KARNATAKA467 NULL MAISURU KARNATAKA468 NULL MANDYA KARNATAKA469 NULL MANGALURU KARNATAKA470 NULL NIPANI KARNATAKA471 NULL PATTANAGERE KARNATAKA472 NULL PUTTUR KARNATAKA473 NULL RABKAVI KARNATAKA474 NULL RAICHUR KARNATAKA475 NULL RAMANAGARAM KARNATAKA476 NULL RANIBENNUR KARNATAKA477 NULL ROBERTSONPET KARNATAKA478 NULL SAGAR KARNATAKA479 NULL SHAHABAD KARNATAKA480 NULL SHAHPUR KARNATAKA481 NULL SHIMOGA KARNATAKA482 NULL SHORAPUR KARNATAKA483 NULL SIDLAGHATTA KARNATAKA484 NULL SIRA KARNATAKA485 NULL SIRSI KARNATAKA486 NULL TIPTUR KARNATAKA487 NULL TUMKUR KARNATAKA488 NULL UDUPI KARNATAKA489 NULL ULLAL KARNATAKA490 NULL YADGIR KARNATAKA491 NULL YELAHANKA KARNATAKA492 NULL ALAPPUZHA KERALA493 NULL BEYPUR KERALA494 NULL CHERUVANNUR KERALA495 NULL EDAKKARA KERALA496 NULL EDATHALA KERALA497 NULL KALAMASSERY KERALA498 NULL KANNAN DEVAN HILLS KERALA499 NULL KANNANGAD KERALA500 NULL KANNUR KERALA501 NULL KAYANKULAM KERALA502 NULL KOCHI KERALA503 NULL KOLLAM KERALA504 NULL KOTTAYAM KERALA505 NULL KOYILANDI KERALA506 NULL KOZHIKKOD KERALA507 NULL KUNNAMKULAM KERALA508 NULL MALAPPURAM KERALA509 NULL MANJERI KERALA510 NULL NEDUMANGAD KERALA511 NULL NEYYATTINKARA KERALA512 NULL PALAKKAD KERALA513 NULL PALLICHAL KERALA514 NULL PAYYANNUR KERALA515 NULL PONNANI KERALA516 NULL TALIPPARAMBA KERALA517 NULL THALASSERY KERALA518 NULL THIRUVANANTHAPURAM KERALA519 NULL THRIPPUNITHURA KERALA520 NULL THRISSUR KERALA521 NULL TIRUR KERALA522 NULL TIRUVALLA KERALA523 NULL VADAKARA KERALA524 NULL ASHOKNAGAR MADHYA PRADESH525 NULL BALAGHAT MADHYA PRADESH526 NULL BASODA MADHYA PRADESH527 NULL BETUL MADHYA PRADESH528 NULL BHIND MADHYA PRADESH529 NULL BHOPAL MADHYA PRADESH530 NULL BINAETAWA MADHYA PRADESH531 NULL BURHANPUR MADHYA PRADESH532 NULL CHHATARPUR MADHYA PRADESH533 NULL CHHINDWARA MADHYA PRADESH534 NULL DABRA MADHYA PRADESH535 NULL DAMOH MADHYA PRADESH536 NULL DATIA MADHYA PRADESH537 NULL DEWAS MADHYA PRADESH538 NULL DHAR MADHYA PRADESH539 NULL GOHAD MADHYA PRADESH540 NULL GUNA MADHYA PRADESH541 NULL GWALIOR MADHYA PRADESH542 NULL HARDA MADHYA PRADESH543 NULL HOSHANGABAD MADHYA PRADESH544 NULL INDORE MADHYA PRADESH545 NULL ITARSI MADHYA PRADESH546 NULL JABALPUR MADHYA PRADESH547 NULL JABALPUR CANTONMENT MADHYA PRADESH548 NULL JAORA MADHYA PRADESH549 NULL KHANDWA MADHYA PRADESH550 NULL KHARGONE MADHYA PRADESH551 NULL MANDIDIP MADHYA PRADESH552 NULL MANDSAUR MADHYA PRADESH553 NULL MAU MADHYA PRADESH554 NULL MORENA MADHYA PRADESH555 NULL MURWARA MADHYA PRADESH556 NULL NAGDA MADHYA PRADESH557 NULL NIMACH MADHYA PRADESH558 NULL PITHAMPUR MADHYA PRADESH559 NULL RAGHOGARH MADHYA PRADESH560 NULL RATLAM MADHYA PRADESH561 NULL REWA MADHYA PRADESH562 NULL SAGAR MADHYA PRADESH563 NULL SARNI MADHYA PRADESH564 NULL SATNA MADHYA PRADESH565 NULL SEHORE MADHYA PRADESH566 NULL SENDHWA MADHYA PRADESH567 NULL SEONI MADHYA PRADESH568 NULL SHAHDOL MADHYA PRADESH569 NULL SHAJAPUR MADHYA PRADESH570 NULL SHEOPUR MADHYA PRADESH571 NULL SHIVAPURI MADHYA PRADESH572 NULL SIDHI MADHYA PRADESH573 NULL SINGRAULI MADHYA PRADESH574 NULL TIKAMGARH MADHYA PRADESH575 NULL UJJAIN MADHYA PRADESH576 NULL VIDISHA MADHYA PRADESH577 NULL ACHALPUR MAHARASHTRA578 NULL AHMADNAGAR MAHARASHTRA579 NULL AKOLA MAHARASHTRA580 NULL AKOT MAHARASHTRA581 NULL AMALNER MAHARASHTRA582 NULL AMBAJOGAI MAHARASHTRA583 NULL AMRAVATI MAHARASHTRA584 NULL ANJANGAON MAHARASHTRA585 NULL AURANGABAD MAHARASHTRA586 NULL BADLAPUR MAHARASHTRA587 NULL BALLARPUR MAHARASHTRA588 NULL BARAMATI MAHARASHTRA589 NULL BARSI MAHARASHTRA590 NULL BASMAT MAHARASHTRA591 NULL BHADRAVATI MAHARASHTRA592 NULL BHANDARA MAHARASHTRA593 NULL BHIWANDI MAHARASHTRA594 NULL BHUSAWAL MAHARASHTRA595 NULL BID MAHARASHTRA596 NULL MUMBAI MAHARASHTRA597 NULL BULDANA MAHARASHTRA598 NULL CHALISGAON MAHARASHTRA599 NULL CHANDRAPUR MAHARASHTRA600 NULL CHIKHLI MAHARASHTRA601 NULL CHIPLUN MAHARASHTRA602 NULL CHOPDA MAHARASHTRA603 NULL DAHANU MAHARASHTRA604 NULL DEOLALI MAHARASHTRA605 NULL DHULE MAHARASHTRA606 NULL DIGDOH MAHARASHTRA607 NULL DIGLUR MAHARASHTRA608 NULL GADCHIROLI MAHARASHTRA609 NULL GONDIYA MAHARASHTRA610 NULL HINGANGHAT MAHARASHTRA611 NULL HINGOLI MAHARASHTRA612 NULL ICHALKARANJI MAHARASHTRA613 NULL JALGAON MAHARASHTRA614 NULL JALNA MAHARASHTRA615 NULL KALYAN MAHARASHTRA616 NULL KAMTHI MAHARASHTRA617 NULL KARANJA MAHARASHTRA618 NULL KHADKI MAHARASHTRA619 NULL KHAMGAON MAHARASHTRA620 NULL KHOPOLI MAHARASHTRA621 NULL KOLHAPUR MAHARASHTRA622 NULL KOPARGAON MAHARASHTRA623 NULL LATUR MAHARASHTRA624 NULL LONAVALE MAHARASHTRA625 NULL MALEGAON MAHARASHTRA626 NULL MALKAPUR MAHARASHTRA627 NULL MANMAD MAHARASHTRA628 NULL MIRA BHAYANDAR MAHARASHTRA629 NULL NAGPUR MAHARASHTRA630 NULL NALASOPARA MAHARASHTRA631 NULL NANDED MAHARASHTRA632 NULL NANDURBAR MAHARASHTRA633 NULL NASHIK MAHARASHTRA634 NULL NAVGHAR MAHARASHTRA635 NULL NAVI MUMBAI MAHARASHTRA636 NULL NAVI MUMBAI MAHARASHTRA637 NULL OSMANABAD MAHARASHTRA638 NULL PALGHAR MAHARASHTRA639 NULL PANDHARPUR MAHARASHTRA640 NULL PARBHANI MAHARASHTRA641 NULL PHALTAN MAHARASHTRA642 NULL PIMPRI MAHARASHTRA643 NULL PUNE MAHARASHTRA644 NULL PUNE CANTONMENT MAHARASHTRA645 NULL PUSAD MAHARASHTRA646 NULL RATNAGIRI MAHARASHTRA647 NULL SANGLIMIRAJ MAHARASHTRA648 NULL SATARA MAHARASHTRA649 NULL SHAHADA MAHARASHTRA650 NULL SHEGAON MAHARASHTRA651 NULL SHIRPUR MAHARASHTRA652 NULL SHOLAPUR MAHARASHTRA653 NULL SHRIRAMPUR MAHARASHTRA654 NULL SILLOD MAHARASHTRA655 NULL THANA MAHARASHTRA656 NULL UDGIR MAHARASHTRA657 NULL ULHASNAGAR MAHARASHTRA658 NULL URAN ISLAMPUR MAHARASHTRA659 NULL VASAI MAHARASHTRA660 NULL VIRAR MAHARASHTRA661 NULL WADI MAHARASHTRA662 NULL WANI MAHARASHTRA663 NULL WARDHA MAHARASHTRA664 NULL WARUD MAHARASHTRA665 NULL WASHIM MAHARASHTRA666 NULL YAVATMAL MAHARASHTRA667 NULL IMPHAL MANIPUR668 NULL SHILLONG MEGHALAYA669 NULL TURA MEGHALAYA670 NULL AIZAWL MIZORAM671 NULL LUNGLEI MIZORAM672 NULL DIMAPUR NAGALAND673 NULL KOHIMA NAGALAND674 NULL WOKHA NAGALAND675 NULL BALANGIR ORISSA676 NULL BALESHWAR ORISSA677 NULL BARBIL ORISSA678 NULL BARGARH ORISSA679 NULL BARIPADA ORISSA680 NULL BHADRAK ORISSA681 NULL BHAWANIPATNA ORISSA682 NULL BHUBANESWAR ORISSA683 NULL BRAHMAPUR ORISSA684 NULL BRAJRAJNAGAR ORISSA685 NULL DHENKANAL ORISSA686 NULL JAYPUR ORISSA687 NULL JHARSUGUDA ORISSA688 NULL KATAKA ORISSA689 NULL KENDUJHAR ORISSA690 NULL PARADWIP ORISSA691 NULL PURI ORISSA692 NULL RAURKELA ORISSA693 NULL RAURKELA INDUSTRIAL TOWNSHIP ORISSA694 NULL RAYAGADA ORISSA695 NULL SAMBALPUR ORISSA696 NULL SUNABEDA ORISSA697 NULL KARAIKAL PONDICHERRY698 NULL OZHUKARAI PONDICHERRY699 NULL PONDICHERRY PONDICHERRY700 NULL ABOHAR PUNJAB701 NULL AMRITSAR PUNJAB702 NULL BARNALA PUNJAB703 NULL BATALA PUNJAB704 NULL BATHINDA PUNJAB705 NULL DHURI PUNJAB706 NULL FARIDKOT PUNJAB707 NULL FAZILKA PUNJAB708 NULL FIROZPUR PUNJAB709 NULL FIROZPUR CANTONMENT PUNJAB710 NULL GOBINDGARH PUNJAB711 NULL GURDASPUR PUNJAB712 NULL HOSHIARPUR PUNJAB713 NULL JAGRAON PUNJAB714 NULL JALANDHAR PUNJAB715 NULL KAPURTHALA PUNJAB716 NULL KHANNA PUNJAB717 NULL KOT KAPURA PUNJAB718 NULL LUDHIANA PUNJAB719 NULL MALAUT PUNJAB720 NULL MALER KOTLA PUNJAB721 NULL MANSA PUNJAB722 NULL MOGA PUNJAB723 NULL MOHALI PUNJAB724 NULL PATHANKOT PUNJAB725 NULL PATIALA PUNJAB726 NULL PHAGWARA PUNJAB727 NULL RAJPURA PUNJAB728 NULL RUPNAGAR PUNJAB729 NULL SAMANA PUNJAB730 NULL SANGRUR PUNJAB731 NULL SIRHIND PUNJAB732 NULL SUNAM PUNJAB733 NULL TARN TARAN PUNJAB734 NULL AJMER RAJASTHAN735 NULL ALWAR RAJASTHAN736 NULL BALOTRA RAJASTHAN737 NULL BANSWARA RAJASTHAN738 NULL BARAN RAJASTHAN739 NULL BARI RAJASTHAN740 NULL BARMER RAJASTHAN741 NULL BEAWAR RAJASTHAN742 NULL BHARATPUR RAJASTHAN743 NULL BHILWARA RAJASTHAN744 NULL BHIWADI RAJASTHAN745 NULL BIKANER RAJASTHAN746 NULL BUNDI RAJASTHAN747 NULL CHITTAURGARH RAJASTHAN748 NULL CHOMUN RAJASTHAN749 NULL CHURU RAJASTHAN750 NULL DAOSA RAJASTHAN751 NULL DHAULPUR RAJASTHAN752 NULL DIDWANA RAJASTHAN753 NULL FATEHPUR RAJASTHAN754 NULL GANGANAGAR RAJASTHAN755 NULL GANGAPUR RAJASTHAN756 NULL HANUMANGARH RAJASTHAN757 NULL HINDAUN RAJASTHAN758 NULL JAIPUR RAJASTHAN759 NULL JAISALMER RAJASTHAN760 NULL JALOR RAJASTHAN761 NULL JHALAWAR RAJASTHAN762 NULL JHUNJHUNUN RAJASTHAN763 NULL JODHPUR RAJASTHAN764 NULL KARAULI RAJASTHAN765 NULL KISHANGARH RAJASTHAN766 NULL KOTA RAJASTHAN767 NULL KUCHAMAN RAJASTHAN768 NULL LADNUN RAJASTHAN769 NULL MAKRANA RAJASTHAN770 NULL NAGAUR RAJASTHAN771 NULL NAWALGARH RAJASTHAN772 NULL NIMBAHERA RAJASTHAN773 NULL NOKHA RAJASTHAN774 NULL PALI RAJASTHAN775 NULL RAJSAMAND RAJASTHAN776 NULL RATANGARH RAJASTHAN777 NULL SARDARSHAHR RAJASTHAN778 NULL SAWAI MADHOPUR RAJASTHAN779 NULL SIKAR RAJASTHAN780 NULL SUJANGARH RAJASTHAN781 NULL SURATGARH RAJASTHAN782 NULL TONK RAJASTHAN783 NULL UDAIPUR RAJASTHAN784 NULL ALANDUR TAMIL NADU785 NULL AMBATTUR TAMIL NADU786 NULL AMBUR TAMIL NADU787 NULL ARAKONAM TAMIL NADU788 NULL ARANI TAMIL NADU789 NULL ARUPPUKKOTTAI TAMIL NADU790 NULL ATTUR TAMIL NADU791 NULL AVADI TAMIL NADU792 NULL AVANIAPURAM TAMIL NADU793 NULL BODINAYAKKANUR TAMIL NADU794 NULL CHENGALPATTU TAMIL NADU795 NULL DHARAPURAM TAMIL NADU796 NULL DHARMAPURI TAMIL NADU797 NULL DINDIGUL TAMIL NADU798 NULL ERODE TAMIL NADU799 NULL GOPICHETTIPALAIYAM TAMIL NADU800 NULL GUDALUR TAMIL NADU801 NULL GUDIYATTAM TAMIL NADU802 NULL HOSUR TAMIL NADU803 NULL IDAPPADI TAMIL NADU804 NULL KADAYANALLUR TAMIL NADU805 NULL KAMBAM TAMIL NADU806 NULL KANCHIPURAM TAMIL NADU807 NULL KARUR TAMIL NADU808 NULL KAVUNDAMPALAIYAM TAMIL NADU809 NULL KOVILPATTI TAMIL NADU810 NULL KOYAMPATTUR TAMIL NADU811 NULL KRISHNAGIRI TAMIL NADU812 NULL KUMARAPALAIYAM TAMIL NADU813 NULL KUMBAKONAM TAMIL NADU814 NULL KUNIYAMUTHUR TAMIL NADU815 NULL KURICHI TAMIL NADU816 NULL MADHAVARAM TAMIL NADU817 NULL MADRAS TAMIL NADU818 NULL MADURAI TAMIL NADU819 NULL MADURAVOYAL TAMIL NADU820 NULL MANNARGUDI TAMIL NADU821 NULL MAYILADUTHURAI TAMIL NADU822 NULL METTUPALAYAM TAMIL NADU823 NULL METTUR TAMIL NADU824 NULL NAGAPATTINAM TAMIL NADU825 NULL NAGERCOIL TAMIL NADU826 NULL NAMAKKAL TAMIL NADU827 NULL NERKUNRAM TAMIL NADU828 NULL NEYVELI TAMIL NADU829 NULL PALLAVARAM TAMIL NADU830 NULL PAMMAL TAMIL NADU831 NULL PANNURATTI TAMIL NADU832 NULL PARAMAKKUDI TAMIL NADU833 NULL PATTUKKOTTAI TAMIL NADU834 NULL POLLACHI TAMIL NADU835 NULL PUDUKKOTTAI TAMIL NADU836 NULL PULIYANKUDI TAMIL NADU837 NULL PUNAMALLI TAMIL NADU838 NULL RAJAPALAIYAM TAMIL NADU839 NULL RAMANATHAPURAM TAMIL NADU840 NULL SALEM TAMIL NADU841 NULL SANKARANKOIL TAMIL NADU842 NULL SIVAKASI TAMIL NADU843 NULL SRIVILLIPUTTUR TAMIL NADU844 NULL TAMBARAM TAMIL NADU845 NULL TENKASI TAMIL NADU846 NULL THANJAVUR TAMIL NADU847 NULL THENI ALLINAGARAM TAMIL NADU848 NULL THIRUTHANGAL TAMIL NADU849 NULL THIRUVARUR TAMIL NADU850 NULL THUTHUKKUDI TAMIL NADU851 NULL TINDIVANAM TAMIL NADU852 NULL TIRUCHCHIRAPPALLI TAMIL NADU853 NULL TIRUCHENGODE TAMIL NADU854 NULL TIRUNELVELI TAMIL NADU855 NULL TIRUPATHUR TAMIL NADU856 NULL TIRUPPUR TAMIL NADU857 NULL TIRUVANNAMALAI TAMIL NADU858 NULL TIRUVOTTIYUR TAMIL NADU859 NULL UDAGAMANDALAM TAMIL NADU860 NULL UDUMALAIPETTAI TAMIL NADU861 NULL VALPARAI TAMIL NADU862 NULL VANIYAMBADI TAMIL NADU863 NULL VELAMPALAIYAM TAMIL NADU864 NULL VELLURU TAMIL NADU865 NULL VILUPPURAM TAMIL NADU866 NULL VIRAPPANCHATRAM TAMIL NADU867 NULL VIRUDHACHALAM TAMIL NADU868 NULL VIRUDUNAGAR TAMIL NADU869 NULL AGARTALA TRIPURA870 NULL AGARTALA MCL TRIPURA871 NULL BADHARGHAT TRIPURA872 NULL AGRA UTTAR PRADESH873 NULL ALIGARH UTTAR PRADESH874 NULL ALLAHABAD UTTAR PRADESH875 NULL AMROHA UTTAR PRADESH876 NULL AONLA UTTAR PRADESH877 NULL AURAIYA UTTAR PRADESH878 NULL AYODHYA UTTAR PRADESH879 NULL AZAMGARH UTTAR PRADESH880 NULL BAHERI UTTAR PRADESH881 NULL BAHRAICH UTTAR PRADESH882 NULL BALLIA UTTAR PRADESH883 NULL BALRAMPUR UTTAR PRADESH884 NULL BANDA UTTAR PRADESH885 NULL BARAUT UTTAR PRADESH886 NULL BARELI UTTAR PRADESH887 NULL BASTI UTTAR PRADESH888 NULL BEHTA HAJIPUR UTTAR PRADESH889 NULL BELA UTTAR PRADESH890 NULL BHADOHI UTTAR PRADESH891 NULL BIJNOR UTTAR PRADESH892 NULL BISALPUR UTTAR PRADESH893 NULL BISWAN UTTAR PRADESH894 NULL BUDAUN UTTAR PRADESH895 NULL BULANDSHAHR UTTAR PRADESH896 NULL CHANDAUSI UTTAR PRADESH897 NULL CHANDPUR UTTAR PRADESH898 NULL CHHIBRAMAU UTTAR PRADESH899 NULL CHITRAKUT DHAM UTTAR PRADESH900 NULL DADRI UTTAR PRADESH901 NULL DEOBAND UTTAR PRADESH902 NULL DEORIA UTTAR PRADESH903 NULL ETAH UTTAR PRADESH904 NULL ETAWAH UTTAR PRADESH905 NULL FAIZABAD UTTAR PRADESH906 NULL FARIDPUR UTTAR PRADESH907 NULL FARRUKHABAD UTTAR PRADESH908 NULL FATEHPUR UTTAR PRADESH909 NULL FIROZABAD UTTAR PRADESH910 NULL GAJRAULA UTTAR PRADESH911 NULL GANGA GHAT UTTAR PRADESH912 NULL GANGOH UTTAR PRADESH913 NULL GHAZIABAD UTTAR PRADESH914 NULL GHAZIPUR UTTAR PRADESH915 NULL GOLA GOKARANNATH UTTAR PRADESH916 NULL GONDA UTTAR PRADESH917 NULL GORAKHPUR UTTAR PRADESH918 NULL HAPUR UTTAR PRADESH919 NULL HARDOI UTTAR PRADESH920 NULL HASANPUR UTTAR PRADESH921 NULL HATHRAS UTTAR PRADESH922 NULL JAHANGIRABAD UTTAR PRADESH923 NULL JALAUN UTTAR PRADESH924 NULL JAUNPUR UTTAR PRADESH925 NULL JHANSI UTTAR PRADESH926 NULL KADI UTTAR PRADESH927 NULL KAIRANA UTTAR PRADESH928 NULL KANNAUJ UTTAR PRADESH929 NULL KANPUR UTTAR PRADESH930 NULL KANPUR CANTONMENT UTTAR PRADESH931 NULL KASGANJ UTTAR PRADESH932 NULL KHATAULI UTTAR PRADESH933 NULL KHORA UTTAR PRADESH934 NULL KHURJA UTTAR PRADESH935 NULL KIRATPUR UTTAR PRADESH936 NULL KOSI KALAN UTTAR PRADESH937 NULL LAHARPUR UTTAR PRADESH938 NULL LAKHIMPUR UTTAR PRADESH939 NULL LAKHNAU UTTAR PRADESH940 NULL LAKHNAU CANTONMENT UTTAR PRADESH941 NULL LALITPUR UTTAR PRADESH942 NULL LONI UTTAR PRADESH943 NULL MAHOBA UTTAR PRADESH944 NULL MAINPURI UTTAR PRADESH945 NULL MATHURA UTTAR PRADESH946 NULL MAU UTTAR PRADESH947 NULL MAURANIPUR UTTAR PRADESH948 NULL MAWANA UTTAR PRADESH949 NULL MIRAT UTTAR PRADESH950 NULL MIRAT CANTONMENT UTTAR PRADESH951 NULL MIRZAPUR UTTAR PRADESH952 NULL MODINAGAR UTTAR PRADESH953 NULL MORADABAD UTTAR PRADESH954 NULL MUBARAKPUR UTTAR PRADESH955 NULL MUGHAL SARAI UTTAR PRADESH956 NULL MURADNAGAR UTTAR PRADESH957 NULL MUZAFFARNAGAR UTTAR PRADESH958 NULL NAGINA UTTAR PRADESH959 NULL NAJIBABAD UTTAR PRADESH960 NULL NAWABGANJ UTTAR PRADESH961 NULL NOIDA UTTAR PRADESH962 NULL OBRA UTTAR PRADESH963 NULL ORAI UTTAR PRADESH964 NULL PILIBHIT UTTAR PRADESH965 NULL PILKHUWA UTTAR PRADESH966 NULL RAE BARELI UTTAR PRADESH967 NULL RAMGARH NAGLA KOTHI UTTAR PRADESH968 NULL RAMPUR UTTAR PRADESH969 NULL RATH UTTAR PRADESH970 NULL RENUKUT UTTAR PRADESH971 NULL SAHARANPUR UTTAR PRADESH972 NULL SAHASWAN UTTAR PRADESH973 NULL SAMBHAL UTTAR PRADESH974 NULL SANDILA UTTAR PRADESH975 NULL SHAHABAD UTTAR PRADESH976 NULL SHAHJAHANPUR UTTAR PRADESH977 NULL SHAMLI UTTAR PRADESH978 NULL SHERKOT UTTAR PRADESH979 NULL SHIKOHABAD UTTAR PRADESH980 NULL SIKANDARABAD UTTAR PRADESH981 NULL SITAPUR UTTAR PRADESH982 NULL SUKHMALPUR NIZAMABAD UTTAR PRADESH983 NULL SULTANPUR UTTAR PRADESH984 NULL TANDA UTTAR PRADESH985 NULL TILHAR UTTAR PRADESH986 NULL TUNDLA UTTAR PRADESH987 NULL UJHANI UTTAR PRADESH988 NULL UNNAO UTTAR PRADESH989 NULL VARANASI UTTAR PRADESH990 NULL VRINDAVAN UTTAR PRADESH991 NULL DEHRA DUN UTTARANCHAL992 NULL DEHRA DUN CANTONMENT UTTARANCHAL993 NULL GOLA RANGE UTTARANCHAL994 NULL HALDWANI UTTARANCHAL995 NULL HARIDWAR UTTARANCHAL996 NULL KASHIPUR UTTARANCHAL997 NULL PITHORAGARH UTTARANCHAL998 NULL RISHIKESH UTTARANCHAL999 NULL RUDRAPUR UTTARANCHAL1000 NULL RURKI UTTARANCHALhere S_ID is coming null but i want the unique id which is in the tbl_staelisteg for all state_name values i want S_ID which is assigned to value of the Stae_name column of table tbl_statelist like as below994 36 HALDWANI UTTARANCHAL995 36 HARIDWAR UTTARANCHAL996 36 KASHIPUR UTTARANCHAL997 36 PITHORAGARH UTTARANCHAL998 36 RISHIKESH UTTARANCHAL999 36 RUDRAPUR UTTARANCHALplz do helpregardsabuzar |
|
bitsmed
Aged Yak Warrior
545 Posts |
Posted - 2013-12-09 : 17:43:49
|
Try this:select a.c_id ,b.s_id ,a.city_name ,a.state_name from tbl_citylist as a inner join tbl_statelist as b on b.state_name=a.state_name order by a.c_id |
|
|
abuzar
Starting Member
20 Posts |
Posted - 2013-12-10 : 14:55:37
|
quote: Originally posted by bitsmed Try this:select a.c_id ,b.s_id ,a.city_name ,a.state_name from tbl_citylist as a inner join tbl_statelist as b on b.state_name=a.state_name order by a.c_id
Thank you very much for your valuable reply it runs perfectly what i wanted :))) |
|
|
abuzar
Starting Member
20 Posts |
Posted - 2013-12-10 : 15:37:22
|
will you plz help me out in one more thing..In a table named customers i have made 4 column (id int primary key not null,name varchar(20), surname(20),dates datetime not null default getdate())create function CustomerNumber (@id int) returns char(5) as begin return 'C' + right('0000' + convert(varchar(10), @id), 4) endalter Customers add CustomerNumber varchar(10) create trigger Customers_insert on Customers after insert as update Customers set Customers.customerNumber = dbo.CustomerNumber(Customers.dbID) from Customers inner join inserted on Customers.dbID= inserted.dbIDid customernumber name surname date1 c0001 abc a 2013-12-11 02:02:35.770 2 c0002 efg b 2013-12-11 02:02:35.7703 c0003 hij xyz 2013-12-11 02:02:35.7704 c0004 klm pqr 2013-12-11 02:02:35.770suppose if the date changes from 11 to 12id customernumber name surname date5 c0001 jhon a 2013-12-12 02:02:35.770 6 c0002 lee b 2013-12-12 02:02:35.7707 c0003 sam xyz 2013-12-12 02:02:35.7708 c0004 jim pqr 2013-12-12 02:02:35.770the customer number should again start from c0001 onwardsplz do help thanks |
|
|
|
|
|
|
|