SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 to get identity pri key values af 1 table in anoth
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

abuzar
Starting Member

India
20 Posts

Posted - 12/09/2013 :  15:36:45  Show Profile  Reply with Quote
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_statelist

A) table tbl_statelist

S_ID state_name
1 ANDAMAN AND NICOBAR ISLANDS
2 ANDHRA PRADESH
3 ARUNACHAL PRADESH
4 ASSAM
5 BIHAR
6 CHATTISGARH
7 CHANDIGARH
8 DAMAN AND DIU
9 DELHI
10 DADRA AND NAGAR HAVELI
11 GOA
12 GUJARAT
13 HIMACHAL PRADESH
14 HARYANA
15 JAMMU AND KASHMIR
16 JHARKHAND
17 KERALA
18 KARNATAKA
19 LAKSHADWEEP
20 MEGHALAYA
21 MAHARASHTRA
22 MANIPUR
23 MADHYA PRADESH
24 MIZORAM
25 NAGALAND
26 ORISSA
27 PUNJAB
28 PONDICHERRY
29 RAJASTHAN
30 SIKKIM
31 TAMIL NADU
32 TRIPURA
33 UTTARAKHAND
34 UTTAR PRADESH
35 WEST BENGAL
36 UTTARANCHAL
B) Table tbl_city

Create 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_name
1 NULL ADILABAD ANDHRA PRADESH
2 NULL PORT BLAIR ANDAMAN AND NICOBAR ISLANDS
3 NULL ADONI ANDHRA PRADESH
4 NULL ALWAL ANDHRA PRADESH
5 NULL ANAKAPALLE ANDHRA PRADESH
6 NULL ANANTAPUR ANDHRA PRADESH
7 NULL BAPATLA ANDHRA PRADESH
8 NULL BELAMPALLI ANDHRA PRADESH
9 NULL BHIMAVARAM ANDHRA PRADESH
10 NULL BHONGIR ANDHRA PRADESH
11 NULL BOBBILI ANDHRA PRADESH
12 NULL BODHAN ANDHRA PRADESH
13 NULL CHILAKALURUPET ANDHRA PRADESH
14 NULL CHINNA CHAWK ANDHRA PRADESH
15 NULL CHIRALA ANDHRA PRADESH
16 NULL CHITTUR ANDHRA PRADESH
17 NULL CUDDAPAH ANDHRA PRADESH
18 NULL DHARMAVARAM ANDHRA PRADESH
19 NULL DHONE ANDHRA PRADESH
20 NULL ELURU ANDHRA PRADESH
21 NULL GADDIANNARAM ANDHRA PRADESH
22 NULL GADWAL ANDHRA PRADESH
23 NULL GAJUWAKA ANDHRA PRADESH
24 NULL GUDIVADA ANDHRA PRADESH
25 NULL GUDUR ANDHRA PRADESH
26 NULL GUNTAKAL ANDHRA PRADESH
27 NULL GUNTUR ANDHRA PRADESH
28 NULL HINDUPUR ANDHRA PRADESH
29 NULL HYDERABAD ANDHRA PRADESH
30 NULL JAGTIAL ANDHRA PRADESH
31 NULL KADIRI ANDHRA PRADESH
32 NULL KAGAZNAGAR ANDHRA PRADESH
33 NULL KAKINADA ANDHRA PRADESH
34 NULL KALLUR ANDHRA PRADESH
35 NULL KAMAREDDI ANDHRA PRADESH
36 NULL KAPRA ANDHRA PRADESH
37 NULL KARIMNAGAR ANDHRA PRADESH
38 NULL KARNUL ANDHRA PRADESH
39 NULL KAVALI ANDHRA PRADESH
40 NULL KHAMMAM ANDHRA PRADESH
41 NULL KODAR ANDHRA PRADESH
42 NULL KONDUKUR ANDHRA PRADESH
43 NULL KORATLA ANDHRA PRADESH
44 NULL KOTTAGUDEM ANDHRA PRADESH
45 NULL KUKATPALLE ANDHRA PRADESH
46 NULL LALBAHADUR NAGAR ANDHRA PRADESH
47 NULL MACHILIPATNAM ANDHRA PRADESH
48 NULL MAHBUBNAGAR ANDHRA PRADESH
49 NULL MALKAJGIRI ANDHRA PRADESH
50 NULL MANCHERAL ANDHRA PRADESH
51 NULL MANDAMARRI ANDHRA PRADESH
52 NULL MANGALAGIRI ANDHRA PRADESH
53 NULL MARKAPUR ANDHRA PRADESH
54 NULL MIRYALAGUDA ANDHRA PRADESH
55 NULL NALGONDA ANDHRA PRADESH
56 NULL NANDYAL ANDHRA PRADESH
57 NULL NARASAPUR ANDHRA PRADESH
58 NULL NARASARAOPET ANDHRA PRADESH
59 NULL NELLUR ANDHRA PRADESH
60 NULL NIRMAL ANDHRA PRADESH
61 NULL NIZAMABAD ANDHRA PRADESH
62 NULL NUZVID ANDHRA PRADESH
63 NULL ONGOLE ANDHRA PRADESH
64 NULL PALAKOLLU ANDHRA PRADESH
65 NULL PALASA ANDHRA PRADESH
66 NULL PALWANCHA ANDHRA PRADESH
67 NULL PATANCHERU ANDHRA PRADESH
68 NULL PIDUGURALLA ANDHRA PRADESH
69 NULL PONNUR ANDHRA PRADESH
70 NULL PRODDATUR ANDHRA PRADESH
71 NULL QUTUBULLAPUR ANDHRA PRADESH
72 NULL RAJAMAHENDRI ANDHRA PRADESH
73 NULL RAJAMPET ANDHRA PRADESH
74 NULL RAJENDRANAGAR ANDHRA PRADESH
75 NULL RAMACHANDRAPURAM ANDHRA PRADESH
76 NULL RAMAGUNDAM ANDHRA PRADESH
77 NULL RAYACHOTI ANDHRA PRADESH
78 NULL RAYADRUG ANDHRA PRADESH
79 NULL SAMALKOT ANDHRA PRADESH
80 NULL SANGAREDDI ANDHRA PRADESH
81 NULL SATTENAPALLE ANDHRA PRADESH
82 NULL SERILUNGAMPALLE ANDHRA PRADESH
83 NULL SIDDIPET ANDHRA PRADESH
84 NULL SIKANDARABAD ANDHRA PRADESH
85 NULL SIRSILLA ANDHRA PRADESH
86 NULL SRIKAKULAM ANDHRA PRADESH
87 NULL SRIKALAHASTI ANDHRA PRADESH
88 NULL SURIAPET ANDHRA PRADESH
89 NULL TADEPALLE ANDHRA PRADESH
90 NULL TADEPALLEGUDEM ANDHRA PRADESH
91 NULL TADPATRI ANDHRA PRADESH
92 NULL TANDUR ANDHRA PRADESH
93 NULL TANUKU ANDHRA PRADESH
94 NULL TENALI ANDHRA PRADESH
95 NULL TIRUPATI ANDHRA PRADESH
96 NULL TUNI ANDHRA PRADESH
97 NULL UPPAL KALAN ANDHRA PRADESH
98 NULL VIJAYAWADA ANDHRA PRADESH
99 NULL VINUKONDA ANDHRA PRADESH
100 NULL VISAKHAPATNAM ANDHRA PRADESH
101 NULL VIZIANAGARAM ANDHRA PRADESH
102 NULL VUYYURU ANDHRA PRADESH
103 NULL WANPARTI ANDHRA PRADESH
104 NULL WARANGAL ANDHRA PRADESH
105 NULL YEMMIGANUR ANDHRA PRADESH
106 NULL ITANAGAR ARUNACHAL PRADESH
107 NULL BARPETA ASSAM
108 NULL BONGAIGAON ASSAM
109 NULL DHUBURI ASSAM
110 NULL DIBRUGARH ASSAM
111 NULL DIPHU ASSAM
112 NULL GUWAHATI ASSAM
113 NULL JORHAT ASSAM
114 NULL KARIMGANJ ASSAM
115 NULL LAKHIMPUR ASSAM
116 NULL LANKA ASSAM
117 NULL NAGAON ASSAM
118 NULL SIBSAGAR ASSAM
119 NULL SILCHAR ASSAM
120 NULL TEZPUR ASSAM
121 NULL TINSUKIA ASSAM
122 NULL ALIPUR DUAR WEST BENGAL
123 NULL ARAMBAGH WEST BENGAL
124 NULL ASANSOL WEST BENGAL
125 NULL ASHOKNAGAR KALYANGARH WEST BENGAL
126 NULL BAHARAMPUR WEST BENGAL
127 NULL BAIDYABATI WEST BENGAL
128 NULL BAJ BAJ WEST BENGAL
129 NULL BALLY WEST BENGAL
130 NULL BALLY CANTONMENT WEST BENGAL
131 NULL BALURGHAT WEST BENGAL
132 NULL BANGAON WEST BENGAL
133 NULL BANKRA WEST BENGAL
134 NULL BANKURA WEST BENGAL
135 NULL BANSBARIA WEST BENGAL
136 NULL BARANAGAR WEST BENGAL
137 NULL BARDDHAMAN WEST BENGAL
138 NULL BASIRHAT WEST BENGAL
139 NULL BHADRESWAR WEST BENGAL
140 NULL BHATPARA WEST BENGAL
141 NULL BIDHANNAGAR WEST BENGAL
142 NULL BINNAGURI WEST BENGAL
143 NULL BISHNUPUR WEST BENGAL
144 NULL BOLPUR WEST BENGAL
145 NULL CALCUTTA WEST BENGAL
146 NULL CHAKDAHA WEST BENGAL
147 NULL CHAMPDANI WEST BENGAL
148 NULL CHANDANNAGAR WEST BENGAL
149 NULL CONTAI WEST BENGAL
150 NULL DABGRAM WEST BENGAL
151 NULL DARJILING WEST BENGAL
152 NULL DHULIAN WEST BENGAL
153 NULL DINHATA WEST BENGAL
154 NULL DUM DUM WEST BENGAL
155 NULL DURGAPUR WEST BENGAL
156 NULL GANGARAMPUR WEST BENGAL
157 NULL GARULIA WEST BENGAL
158 NULL GAYESPUR WEST BENGAL
159 NULL GHATAL WEST BENGAL
160 NULL GOPALPUR WEST BENGAL
161 NULL HABRA WEST BENGAL
162 NULL HALISAHAR WEST BENGAL
163 NULL HAORA WEST BENGAL
164 NULL HUGLICHUNCHURA WEST BENGAL
165 NULL INGRAJ BAZAR WEST BENGAL
166 NULL ISLAMPUR WEST BENGAL
167 NULL JALPAIGURI WEST BENGAL
168 NULL JAMURIA WEST BENGAL
169 NULL JANGIPUR WEST BENGAL
170 NULL JHARGRAM WEST BENGAL
171 NULL KALIYAGANJ WEST BENGAL
172 NULL KALNA WEST BENGAL
173 NULL KALYANI WEST BENGAL
174 NULL KAMARHATI WEST BENGAL
175 NULL KANCHRAPARA WEST BENGAL
176 NULL KANDI WEST BENGAL
177 NULL KARSIYANG WEST BENGAL
178 NULL KATWA WEST BENGAL
179 NULL KHARAGPUR WEST BENGAL
180 NULL KHARAGPUR RAILWAY SETTLEMENT WEST BENGAL
181 NULL KHARDAHA WEST BENGAL
182 NULL KHARIA WEST BENGAL
183 NULL KOCH BIHAR WEST BENGAL
184 NULL KONNAGAR WEST BENGAL
185 NULL KRISHNANAGAR WEST BENGAL
186 NULL KULTI WEST BENGAL
187 NULL MADHYAMGRAM WEST BENGAL
188 NULL MAHESHTALA WEST BENGAL
189 NULL MEMARI WEST BENGAL
190 NULL MIDNAPUR WEST BENGAL
191 NULL NAIHATI WEST BENGAL
192 NULL NAVADWIP WEST BENGAL
193 NULL NI BARAKPUR WEST BENGAL
194 NULL NORTH BARAKPUR WEST BENGAL
195 NULL NORTH DUM DUM WEST BENGAL
196 NULL OLD MALDAH WEST BENGAL
197 NULL PANIHATI WEST BENGAL
198 NULL PHULIA WEST BENGAL
199 NULL PUJALI WEST BENGAL
200 NULL PURULIYA WEST BENGAL
201 NULL RAIGANJ WEST BENGAL
202 NULL RAJPUR WEST BENGAL
203 NULL RAMPUR HAT WEST BENGAL
204 NULL RANAGHAT WEST BENGAL
205 NULL RANIGANJ WEST BENGAL
206 NULL RISHRA WEST BENGAL
207 NULL SHANTIPUR WEST BENGAL
208 NULL SHILIGURI WEST BENGAL
209 NULL SHRIRAMPUR WEST BENGAL
210 NULL SIURI WEST BENGAL
211 NULL SOUTH DUM DUM WEST BENGAL
212 NULL TITAGARH WEST BENGAL
213 NULL ULUBARIA WEST BENGAL
214 NULL UTTARPARAKOTRUNG WEST BENGAL
215 NULL ARARIA BIHAR
216 NULL ARRAH BIHAR
217 NULL AURANGABAD BIHAR
218 NULL BAGAHA BIHAR
219 NULL BEGUSARAI BIHAR
220 NULL BETTIAH BIHAR
221 NULL BHABUA BIHAR
222 NULL BHAGALPUR BIHAR
223 NULL BIHAR BIHAR
224 NULL BUXAR BIHAR
225 NULL CHHAPRA BIHAR
226 NULL DARBHANGA BIHAR
227 NULL DEHRI BIHAR
228 NULL DIGHAMAINPURA BIHAR
229 NULL DINAPUR BIHAR
230 NULL DUMRAON BIHAR
231 NULL GAYA BIHAR
232 NULL GOPALGANJ BIHAR
233 NULL GOURA BIHAR
234 NULL HAJIPUR BIHAR
235 NULL JAHANABAD BIHAR
236 NULL JAMALPUR BIHAR
237 NULL JAMUI BIHAR
238 NULL KATIHAR BIHAR
239 NULL KHAGARIA BIHAR
240 NULL KHAGAUL BIHAR
241 NULL KISHANGANJ BIHAR
242 NULL LAKHISARAI BIHAR
243 NULL MADHIPURA BIHAR
244 NULL MADHUBANI BIHAR
245 NULL MASAURHI BIHAR
246 NULL MOKAMA BIHAR
247 NULL MOTIHARI BIHAR
248 NULL MUNGER BIHAR
249 NULL MUZAFFARPUR BIHAR
250 NULL NAWADA BIHAR
251 NULL PATNA BIHAR
252 NULL PHULWARI BIHAR
253 NULL PURNIA BIHAR
254 NULL RAXAUL BIHAR
255 NULL SAHARSA BIHAR
256 NULL SAMASTIPUR BIHAR
257 NULL SASARAM BIHAR
258 NULL SITAMARHI BIHAR
259 NULL SIWAN BIHAR
260 NULL SUPAUL BIHAR
261 NULL CHANDIGARH CHANDIGARH
262 NULL AMBIKAPUR CHHATTISGARH
263 NULL BHILAI CHHATTISGARH
264 NULL BILASPUR CHHATTISGARH
265 NULL CHARODA CHHATTISGARH
266 NULL CHIRMIRI CHHATTISGARH
267 NULL DHAMTARI CHHATTISGARH
268 NULL DURG CHHATTISGARH
269 NULL JAGDALPUR CHHATTISGARH
270 NULL KORBA CHHATTISGARH
271 NULL RAIGARH CHHATTISGARH
272 NULL RAIPUR CHHATTISGARH
273 NULL RAJNANDGAON CHHATTISGARH
274 NULL BHALSWA JAHANGIRPUR DELHI
275 NULL BURARI DELHI
276 NULL CHILLA SARODA BANGAR DELHI
277 NULL DALLO PURA DELHI
278 NULL DELHI DELHI
279 NULL DEOLI DELHI
280 NULL DILLI CANTONMENT DELHI
281 NULL GHAROLI DELHI
282 NULL GOKALPUR DELHI
283 NULL HASTSAL DELHI
284 NULL JAFFRABAD DELHI
285 NULL KARAWAL NAGAR DELHI
286 NULL KHAJURI KHAS DELHI
287 NULL KIRARI SULEMAN NAGAR DELHI
288 NULL MANDOLI DELHI
289 NULL MITHE PUR DELHI
290 NULL MOLARBAND DELHI
291 NULL MUNDKA DELHI
292 NULL MUSTAFABAD DELHI
293 NULL NANGLOI JAT DELHI
294 NULL NI DILLI DELHI
295 NULL PUL PEHLAD DELHI
296 NULL PUTH KALAN DELHI
297 NULL ROSHAN PURA DELHI
298 NULL SADAT PUR GUJRAN DELHI
299 NULL SULTANPUR MAJRA DELHI
300 NULL TAJPUL DELHI
301 NULL TIGRI DELHI
302 NULL ZIAUDDIN PUR DELHI
303 NULL MADGAON GOA
304 NULL MORMUGAO GOA
305 NULL PANAJI GOA
306 NULL AHMADABAD GUJARAT
307 NULL AMRELI GUJARAT
308 NULL ANAND GUJARAT
309 NULL ANJAR GUJARAT
310 NULL BARDOLI GUJARAT
311 NULL BHARUCH GUJARAT
312 NULL BHAVNAGAR GUJARAT
313 NULL BHUJ GUJARAT
314 NULL BORSAD GUJARAT
315 NULL BOTAD GUJARAT
316 NULL CHANDKHEDA GUJARAT
317 NULL CHANDLODIYA GUJARAT
318 NULL DABHOI GUJARAT
319 NULL DAHOD GUJARAT
320 NULL DHOLKA GUJARAT
321 NULL DHORAJI GUJARAT
322 NULL DHRANGADHRA GUJARAT
323 NULL DISA GUJARAT
324 NULL GANDHIDHAM GUJARAT
325 NULL GANDHINAGAR GUJARAT
326 NULL GHATLODIYA GUJARAT
327 NULL GODHRA GUJARAT
328 NULL GONDAL GUJARAT
329 NULL HIMATNAGAR GUJARAT
330 NULL JAMNAGAR GUJARAT
331 NULL JAMNAGAR GUJARAT
332 NULL JETPUR GUJARAT
333 NULL JUNAGADH GUJARAT
334 NULL KALOL GUJARAT
335 NULL KESHOD GUJARAT
336 NULL KHAMBHAT GUJARAT
337 NULL KUNDLA GUJARAT
338 NULL MAHUVA GUJARAT
339 NULL MANGROL GUJARAT
340 NULL MODASA GUJARAT
341 NULL MORVI GUJARAT
342 NULL NADIAD GUJARAT
343 NULL NAVAGAM GHED GUJARAT
344 NULL NAVSARI GUJARAT
345 NULL PALITANA GUJARAT
346 NULL PATAN GUJARAT
347 NULL PORBANDAR GUJARAT
348 NULL PUNA GUJARAT
349 NULL RAJKOT GUJARAT
350 NULL RAMOD GUJARAT
351 NULL RANIP GUJARAT
352 NULL SIDDHAPUR GUJARAT
353 NULL SIHOR GUJARAT
354 NULL SURAT GUJARAT
355 NULL SURENDRANAGAR GUJARAT
356 NULL THALTEJ GUJARAT
357 NULL UNA GUJARAT
358 NULL UNJHA GUJARAT
359 NULL UPLETA GUJARAT
360 NULL VADODARA GUJARAT
361 NULL VALSAD GUJARAT
362 NULL VAPI GUJARAT
363 NULL VASTRAL GUJARAT
364 NULL VEJALPUR GUJARAT
365 NULL VERAVAL GUJARAT
366 NULL VIJALPOR GUJARAT
367 NULL VISNAGAR GUJARAT
368 NULL WADHWAN GUJARAT
369 NULL AMBALA HARYANA
370 NULL AMBALA CANTONMENT HARYANA
371 NULL AMBALA SADAR HARYANA
372 NULL BAHADURGARH HARYANA
373 NULL BHIWANI HARYANA
374 NULL CHARKHI DADRI HARYANA
375 NULL DABWALI HARYANA
376 NULL FARIDABAD HARYANA
377 NULL GOHANA HARYANA
378 NULL HISAR HARYANA
379 NULL JAGADHRI HARYANA
380 NULL JIND HARYANA
381 NULL KAITHAL HARYANA
382 NULL KARNAL HARYANA
383 NULL NARNAUL HARYANA
384 NULL NARWANA HARYANA
385 NULL PALWAL HARYANA
386 NULL PANCHKULA HARYANA
387 NULL PANIPAT HARYANA
388 NULL REWARI HARYANA
389 NULL ROHTAK HARYANA
390 NULL SIRSA HARYANA
391 NULL SONIPAT HARYANA
392 NULL THANESAR HARYANA
393 NULL TOHANA HARYANA
394 NULL YAMUNANAGAR HARYANA
395 NULL SHIMLA HIMACHAL PRADESH
396 NULL ANANTNAG JAMMU AND KASHMIR
397 NULL BARAMULA JAMMU AND KASHMIR
398 NULL BARI BRAHMANA JAMMU AND KASHMIR
399 NULL JAMMU JAMMU AND KASHMIR
400 NULL KATHUA JAMMU AND KASHMIR
401 NULL SOPUR JAMMU AND KASHMIR
402 NULL SRINAGAR JAMMU AND KASHMIR
403 NULL UDHAMPUR JAMMU AND KASHMIR
404 NULL ADITYAPUR JHARKHAND
405 NULL BAGBAHRA JHARKHAND
406 NULL BHULI JHARKHAND
407 NULL BOKARO JHARKHAND
408 NULL CHAIBASA JHARKHAND
409 NULL CHAS JHARKHAND
410 NULL DALTENGANJ JHARKHAND
411 NULL DEVGHAR JHARKHAND
412 NULL DHANBAD JHARKHAND
413 NULL HAZARIBAG JHARKHAND
414 NULL JAMSHEDPUR JHARKHAND
415 NULL JHARIA JHARKHAND
416 NULL JHUMRI TILAIYA JHARKHAND
417 NULL JORAPOKHAR JHARKHAND
418 NULL KATRAS JHARKHAND
419 NULL LOHARDAGA JHARKHAND
420 NULL MANGO JHARKHAND
421 NULL PHUSRO JHARKHAND
422 NULL RAMGARH JHARKHAND
423 NULL RANCHI JHARKHAND
424 NULL SAHIBGANJ JHARKHAND
425 NULL SAUNDA JHARKHAND
426 NULL SINDARI JHARKHAND
427 NULL BAGALKOT KARNATAKA
428 NULL BANGALORE KARNATAKA
429 NULL BASAVAKALYAN KARNATAKA
430 NULL BELGAUM KARNATAKA
431 NULL BELLARY KARNATAKA
432 NULL BHADRAVATI KARNATAKA
433 NULL BIDAR KARNATAKA
434 NULL BIJAPUR KARNATAKA
435 NULL BOMMANAHALLI KARNATAKA
436 NULL BYATARAYANAPURA KARNATAKA
437 NULL CHALLAKERE KARNATAKA
438 NULL CHAMRAJNAGAR KARNATAKA
439 NULL CHANNAPATNA KARNATAKA
440 NULL CHIK BALLAPUR KARNATAKA
441 NULL CHIKMAGALUR KARNATAKA
442 NULL CHINTAMANI KARNATAKA
443 NULL CHITRADURGA KARNATAKA
444 NULL DASARAHALLI KARNATAKA
445 NULL DAVANAGERE KARNATAKA
446 NULL DOD BALLAPUR KARNATAKA
447 NULL GADAG KARNATAKA
448 NULL GANGAWATI KARNATAKA
449 NULL GOKAK KARNATAKA
450 NULL GULBARGA KARNATAKA
451 NULL HARIHAR KARNATAKA
452 NULL HASSAN KARNATAKA
453 NULL HAVERI KARNATAKA
454 NULL HIRIYUR KARNATAKA
455 NULL HOSAKOTE KARNATAKA
456 NULL HOSPET KARNATAKA
457 NULL HUBLI KARNATAKA
458 NULL ILKAL KARNATAKA
459 NULL JAMKHANDI KARNATAKA
460 NULL KANAKAPURA KARNATAKA
461 NULL KARWAR KARNATAKA
462 NULL KOLAR KARNATAKA
463 NULL KOLLEGAL KARNATAKA
464 NULL KOPPAL KARNATAKA
465 NULL KRISHNARAJAPURA KARNATAKA
466 NULL MAHADEVAPURA KARNATAKA
467 NULL MAISURU KARNATAKA
468 NULL MANDYA KARNATAKA
469 NULL MANGALURU KARNATAKA
470 NULL NIPANI KARNATAKA
471 NULL PATTANAGERE KARNATAKA
472 NULL PUTTUR KARNATAKA
473 NULL RABKAVI KARNATAKA
474 NULL RAICHUR KARNATAKA
475 NULL RAMANAGARAM KARNATAKA
476 NULL RANIBENNUR KARNATAKA
477 NULL ROBERTSONPET KARNATAKA
478 NULL SAGAR KARNATAKA
479 NULL SHAHABAD KARNATAKA
480 NULL SHAHPUR KARNATAKA
481 NULL SHIMOGA KARNATAKA
482 NULL SHORAPUR KARNATAKA
483 NULL SIDLAGHATTA KARNATAKA
484 NULL SIRA KARNATAKA
485 NULL SIRSI KARNATAKA
486 NULL TIPTUR KARNATAKA
487 NULL TUMKUR KARNATAKA
488 NULL UDUPI KARNATAKA
489 NULL ULLAL KARNATAKA
490 NULL YADGIR KARNATAKA
491 NULL YELAHANKA KARNATAKA
492 NULL ALAPPUZHA KERALA
493 NULL BEYPUR KERALA
494 NULL CHERUVANNUR KERALA
495 NULL EDAKKARA KERALA
496 NULL EDATHALA KERALA
497 NULL KALAMASSERY KERALA
498 NULL KANNAN DEVAN HILLS KERALA
499 NULL KANNANGAD KERALA
500 NULL KANNUR KERALA
501 NULL KAYANKULAM KERALA
502 NULL KOCHI KERALA
503 NULL KOLLAM KERALA
504 NULL KOTTAYAM KERALA
505 NULL KOYILANDI KERALA
506 NULL KOZHIKKOD KERALA
507 NULL KUNNAMKULAM KERALA
508 NULL MALAPPURAM KERALA
509 NULL MANJERI KERALA
510 NULL NEDUMANGAD KERALA
511 NULL NEYYATTINKARA KERALA
512 NULL PALAKKAD KERALA
513 NULL PALLICHAL KERALA
514 NULL PAYYANNUR KERALA
515 NULL PONNANI KERALA
516 NULL TALIPPARAMBA KERALA
517 NULL THALASSERY KERALA
518 NULL THIRUVANANTHAPURAM KERALA
519 NULL THRIPPUNITHURA KERALA
520 NULL THRISSUR KERALA
521 NULL TIRUR KERALA
522 NULL TIRUVALLA KERALA
523 NULL VADAKARA KERALA
524 NULL ASHOKNAGAR MADHYA PRADESH
525 NULL BALAGHAT MADHYA PRADESH
526 NULL BASODA MADHYA PRADESH
527 NULL BETUL MADHYA PRADESH
528 NULL BHIND MADHYA PRADESH
529 NULL BHOPAL MADHYA PRADESH
530 NULL BINAETAWA MADHYA PRADESH
531 NULL BURHANPUR MADHYA PRADESH
532 NULL CHHATARPUR MADHYA PRADESH
533 NULL CHHINDWARA MADHYA PRADESH
534 NULL DABRA MADHYA PRADESH
535 NULL DAMOH MADHYA PRADESH
536 NULL DATIA MADHYA PRADESH
537 NULL DEWAS MADHYA PRADESH
538 NULL DHAR MADHYA PRADESH
539 NULL GOHAD MADHYA PRADESH
540 NULL GUNA MADHYA PRADESH
541 NULL GWALIOR MADHYA PRADESH
542 NULL HARDA MADHYA PRADESH
543 NULL HOSHANGABAD MADHYA PRADESH
544 NULL INDORE MADHYA PRADESH
545 NULL ITARSI MADHYA PRADESH
546 NULL JABALPUR MADHYA PRADESH
547 NULL JABALPUR CANTONMENT MADHYA PRADESH
548 NULL JAORA MADHYA PRADESH
549 NULL KHANDWA MADHYA PRADESH
550 NULL KHARGONE MADHYA PRADESH
551 NULL MANDIDIP MADHYA PRADESH
552 NULL MANDSAUR MADHYA PRADESH
553 NULL MAU MADHYA PRADESH
554 NULL MORENA MADHYA PRADESH
555 NULL MURWARA MADHYA PRADESH
556 NULL NAGDA MADHYA PRADESH
557 NULL NIMACH MADHYA PRADESH
558 NULL PITHAMPUR MADHYA PRADESH
559 NULL RAGHOGARH MADHYA PRADESH
560 NULL RATLAM MADHYA PRADESH
561 NULL REWA MADHYA PRADESH
562 NULL SAGAR MADHYA PRADESH
563 NULL SARNI MADHYA PRADESH
564 NULL SATNA MADHYA PRADESH
565 NULL SEHORE MADHYA PRADESH
566 NULL SENDHWA MADHYA PRADESH
567 NULL SEONI MADHYA PRADESH
568 NULL SHAHDOL MADHYA PRADESH
569 NULL SHAJAPUR MADHYA PRADESH
570 NULL SHEOPUR MADHYA PRADESH
571 NULL SHIVAPURI MADHYA PRADESH
572 NULL SIDHI MADHYA PRADESH
573 NULL SINGRAULI MADHYA PRADESH
574 NULL TIKAMGARH MADHYA PRADESH
575 NULL UJJAIN MADHYA PRADESH
576 NULL VIDISHA MADHYA PRADESH
577 NULL ACHALPUR MAHARASHTRA
578 NULL AHMADNAGAR MAHARASHTRA
579 NULL AKOLA MAHARASHTRA
580 NULL AKOT MAHARASHTRA
581 NULL AMALNER MAHARASHTRA
582 NULL AMBAJOGAI MAHARASHTRA
583 NULL AMRAVATI MAHARASHTRA
584 NULL ANJANGAON MAHARASHTRA
585 NULL AURANGABAD MAHARASHTRA
586 NULL BADLAPUR MAHARASHTRA
587 NULL BALLARPUR MAHARASHTRA
588 NULL BARAMATI MAHARASHTRA
589 NULL BARSI MAHARASHTRA
590 NULL BASMAT MAHARASHTRA
591 NULL BHADRAVATI MAHARASHTRA
592 NULL BHANDARA MAHARASHTRA
593 NULL BHIWANDI MAHARASHTRA
594 NULL BHUSAWAL MAHARASHTRA
595 NULL BID MAHARASHTRA
596 NULL MUMBAI MAHARASHTRA
597 NULL BULDANA MAHARASHTRA
598 NULL CHALISGAON MAHARASHTRA
599 NULL CHANDRAPUR MAHARASHTRA
600 NULL CHIKHLI MAHARASHTRA
601 NULL CHIPLUN MAHARASHTRA
602 NULL CHOPDA MAHARASHTRA
603 NULL DAHANU MAHARASHTRA
604 NULL DEOLALI MAHARASHTRA
605 NULL DHULE MAHARASHTRA
606 NULL DIGDOH MAHARASHTRA
607 NULL DIGLUR MAHARASHTRA
608 NULL GADCHIROLI MAHARASHTRA
609 NULL GONDIYA MAHARASHTRA
610 NULL HINGANGHAT MAHARASHTRA
611 NULL HINGOLI MAHARASHTRA
612 NULL ICHALKARANJI MAHARASHTRA
613 NULL JALGAON MAHARASHTRA
614 NULL JALNA MAHARASHTRA
615 NULL KALYAN MAHARASHTRA
616 NULL KAMTHI MAHARASHTRA
617 NULL KARANJA MAHARASHTRA
618 NULL KHADKI MAHARASHTRA
619 NULL KHAMGAON MAHARASHTRA
620 NULL KHOPOLI MAHARASHTRA
621 NULL KOLHAPUR MAHARASHTRA
622 NULL KOPARGAON MAHARASHTRA
623 NULL LATUR MAHARASHTRA
624 NULL LONAVALE MAHARASHTRA
625 NULL MALEGAON MAHARASHTRA
626 NULL MALKAPUR MAHARASHTRA
627 NULL MANMAD MAHARASHTRA
628 NULL MIRA BHAYANDAR MAHARASHTRA
629 NULL NAGPUR MAHARASHTRA
630 NULL NALASOPARA MAHARASHTRA
631 NULL NANDED MAHARASHTRA
632 NULL NANDURBAR MAHARASHTRA
633 NULL NASHIK MAHARASHTRA
634 NULL NAVGHAR MAHARASHTRA
635 NULL NAVI MUMBAI MAHARASHTRA
636 NULL NAVI MUMBAI MAHARASHTRA
637 NULL OSMANABAD MAHARASHTRA
638 NULL PALGHAR MAHARASHTRA
639 NULL PANDHARPUR MAHARASHTRA
640 NULL PARBHANI MAHARASHTRA
641 NULL PHALTAN MAHARASHTRA
642 NULL PIMPRI MAHARASHTRA
643 NULL PUNE MAHARASHTRA
644 NULL PUNE CANTONMENT MAHARASHTRA
645 NULL PUSAD MAHARASHTRA
646 NULL RATNAGIRI MAHARASHTRA
647 NULL SANGLIMIRAJ MAHARASHTRA
648 NULL SATARA MAHARASHTRA
649 NULL SHAHADA MAHARASHTRA
650 NULL SHEGAON MAHARASHTRA
651 NULL SHIRPUR MAHARASHTRA
652 NULL SHOLAPUR MAHARASHTRA
653 NULL SHRIRAMPUR MAHARASHTRA
654 NULL SILLOD MAHARASHTRA
655 NULL THANA MAHARASHTRA
656 NULL UDGIR MAHARASHTRA
657 NULL ULHASNAGAR MAHARASHTRA
658 NULL URAN ISLAMPUR MAHARASHTRA
659 NULL VASAI MAHARASHTRA
660 NULL VIRAR MAHARASHTRA
661 NULL WADI MAHARASHTRA
662 NULL WANI MAHARASHTRA
663 NULL WARDHA MAHARASHTRA
664 NULL WARUD MAHARASHTRA
665 NULL WASHIM MAHARASHTRA
666 NULL YAVATMAL MAHARASHTRA
667 NULL IMPHAL MANIPUR
668 NULL SHILLONG MEGHALAYA
669 NULL TURA MEGHALAYA
670 NULL AIZAWL MIZORAM
671 NULL LUNGLEI MIZORAM
672 NULL DIMAPUR NAGALAND
673 NULL KOHIMA NAGALAND
674 NULL WOKHA NAGALAND
675 NULL BALANGIR ORISSA
676 NULL BALESHWAR ORISSA
677 NULL BARBIL ORISSA
678 NULL BARGARH ORISSA
679 NULL BARIPADA ORISSA
680 NULL BHADRAK ORISSA
681 NULL BHAWANIPATNA ORISSA
682 NULL BHUBANESWAR ORISSA
683 NULL BRAHMAPUR ORISSA
684 NULL BRAJRAJNAGAR ORISSA
685 NULL DHENKANAL ORISSA
686 NULL JAYPUR ORISSA
687 NULL JHARSUGUDA ORISSA
688 NULL KATAKA ORISSA
689 NULL KENDUJHAR ORISSA
690 NULL PARADWIP ORISSA
691 NULL PURI ORISSA
692 NULL RAURKELA ORISSA
693 NULL RAURKELA INDUSTRIAL TOWNSHIP ORISSA
694 NULL RAYAGADA ORISSA
695 NULL SAMBALPUR ORISSA
696 NULL SUNABEDA ORISSA
697 NULL KARAIKAL PONDICHERRY
698 NULL OZHUKARAI PONDICHERRY
699 NULL PONDICHERRY PONDICHERRY
700 NULL ABOHAR PUNJAB
701 NULL AMRITSAR PUNJAB
702 NULL BARNALA PUNJAB
703 NULL BATALA PUNJAB
704 NULL BATHINDA PUNJAB
705 NULL DHURI PUNJAB
706 NULL FARIDKOT PUNJAB
707 NULL FAZILKA PUNJAB
708 NULL FIROZPUR PUNJAB
709 NULL FIROZPUR CANTONMENT PUNJAB
710 NULL GOBINDGARH PUNJAB
711 NULL GURDASPUR PUNJAB
712 NULL HOSHIARPUR PUNJAB
713 NULL JAGRAON PUNJAB
714 NULL JALANDHAR PUNJAB
715 NULL KAPURTHALA PUNJAB
716 NULL KHANNA PUNJAB
717 NULL KOT KAPURA PUNJAB
718 NULL LUDHIANA PUNJAB
719 NULL MALAUT PUNJAB
720 NULL MALER KOTLA PUNJAB
721 NULL MANSA PUNJAB
722 NULL MOGA PUNJAB
723 NULL MOHALI PUNJAB
724 NULL PATHANKOT PUNJAB
725 NULL PATIALA PUNJAB
726 NULL PHAGWARA PUNJAB
727 NULL RAJPURA PUNJAB
728 NULL RUPNAGAR PUNJAB
729 NULL SAMANA PUNJAB
730 NULL SANGRUR PUNJAB
731 NULL SIRHIND PUNJAB
732 NULL SUNAM PUNJAB
733 NULL TARN TARAN PUNJAB
734 NULL AJMER RAJASTHAN
735 NULL ALWAR RAJASTHAN
736 NULL BALOTRA RAJASTHAN
737 NULL BANSWARA RAJASTHAN
738 NULL BARAN RAJASTHAN
739 NULL BARI RAJASTHAN
740 NULL BARMER RAJASTHAN
741 NULL BEAWAR RAJASTHAN
742 NULL BHARATPUR RAJASTHAN
743 NULL BHILWARA RAJASTHAN
744 NULL BHIWADI RAJASTHAN
745 NULL BIKANER RAJASTHAN
746 NULL BUNDI RAJASTHAN
747 NULL CHITTAURGARH RAJASTHAN
748 NULL CHOMUN RAJASTHAN
749 NULL CHURU RAJASTHAN
750 NULL DAOSA RAJASTHAN
751 NULL DHAULPUR RAJASTHAN
752 NULL DIDWANA RAJASTHAN
753 NULL FATEHPUR RAJASTHAN
754 NULL GANGANAGAR RAJASTHAN
755 NULL GANGAPUR RAJASTHAN
756 NULL HANUMANGARH RAJASTHAN
757 NULL HINDAUN RAJASTHAN
758 NULL JAIPUR RAJASTHAN
759 NULL JAISALMER RAJASTHAN
760 NULL JALOR RAJASTHAN
761 NULL JHALAWAR RAJASTHAN
762 NULL JHUNJHUNUN RAJASTHAN
763 NULL JODHPUR RAJASTHAN
764 NULL KARAULI RAJASTHAN
765 NULL KISHANGARH RAJASTHAN
766 NULL KOTA RAJASTHAN
767 NULL KUCHAMAN RAJASTHAN
768 NULL LADNUN RAJASTHAN
769 NULL MAKRANA RAJASTHAN
770 NULL NAGAUR RAJASTHAN
771 NULL NAWALGARH RAJASTHAN
772 NULL NIMBAHERA RAJASTHAN
773 NULL NOKHA RAJASTHAN
774 NULL PALI RAJASTHAN
775 NULL RAJSAMAND RAJASTHAN
776 NULL RATANGARH RAJASTHAN
777 NULL SARDARSHAHR RAJASTHAN
778 NULL SAWAI MADHOPUR RAJASTHAN
779 NULL SIKAR RAJASTHAN
780 NULL SUJANGARH RAJASTHAN
781 NULL SURATGARH RAJASTHAN
782 NULL TONK RAJASTHAN
783 NULL UDAIPUR RAJASTHAN
784 NULL ALANDUR TAMIL NADU
785 NULL AMBATTUR TAMIL NADU
786 NULL AMBUR TAMIL NADU
787 NULL ARAKONAM TAMIL NADU
788 NULL ARANI TAMIL NADU
789 NULL ARUPPUKKOTTAI TAMIL NADU
790 NULL ATTUR TAMIL NADU
791 NULL AVADI TAMIL NADU
792 NULL AVANIAPURAM TAMIL NADU
793 NULL BODINAYAKKANUR TAMIL NADU
794 NULL CHENGALPATTU TAMIL NADU
795 NULL DHARAPURAM TAMIL NADU
796 NULL DHARMAPURI TAMIL NADU
797 NULL DINDIGUL TAMIL NADU
798 NULL ERODE TAMIL NADU
799 NULL GOPICHETTIPALAIYAM TAMIL NADU
800 NULL GUDALUR TAMIL NADU
801 NULL GUDIYATTAM TAMIL NADU
802 NULL HOSUR TAMIL NADU
803 NULL IDAPPADI TAMIL NADU
804 NULL KADAYANALLUR TAMIL NADU
805 NULL KAMBAM TAMIL NADU
806 NULL KANCHIPURAM TAMIL NADU
807 NULL KARUR TAMIL NADU
808 NULL KAVUNDAMPALAIYAM TAMIL NADU
809 NULL KOVILPATTI TAMIL NADU
810 NULL KOYAMPATTUR TAMIL NADU
811 NULL KRISHNAGIRI TAMIL NADU
812 NULL KUMARAPALAIYAM TAMIL NADU
813 NULL KUMBAKONAM TAMIL NADU
814 NULL KUNIYAMUTHUR TAMIL NADU
815 NULL KURICHI TAMIL NADU
816 NULL MADHAVARAM TAMIL NADU
817 NULL MADRAS TAMIL NADU
818 NULL MADURAI TAMIL NADU
819 NULL MADURAVOYAL TAMIL NADU
820 NULL MANNARGUDI TAMIL NADU
821 NULL MAYILADUTHURAI TAMIL NADU
822 NULL METTUPALAYAM TAMIL NADU
823 NULL METTUR TAMIL NADU
824 NULL NAGAPATTINAM TAMIL NADU
825 NULL NAGERCOIL TAMIL NADU
826 NULL NAMAKKAL TAMIL NADU
827 NULL NERKUNRAM TAMIL NADU
828 NULL NEYVELI TAMIL NADU
829 NULL PALLAVARAM TAMIL NADU
830 NULL PAMMAL TAMIL NADU
831 NULL PANNURATTI TAMIL NADU
832 NULL PARAMAKKUDI TAMIL NADU
833 NULL PATTUKKOTTAI TAMIL NADU
834 NULL POLLACHI TAMIL NADU
835 NULL PUDUKKOTTAI TAMIL NADU
836 NULL PULIYANKUDI TAMIL NADU
837 NULL PUNAMALLI TAMIL NADU
838 NULL RAJAPALAIYAM TAMIL NADU
839 NULL RAMANATHAPURAM TAMIL NADU
840 NULL SALEM TAMIL NADU
841 NULL SANKARANKOIL TAMIL NADU
842 NULL SIVAKASI TAMIL NADU
843 NULL SRIVILLIPUTTUR TAMIL NADU
844 NULL TAMBARAM TAMIL NADU
845 NULL TENKASI TAMIL NADU
846 NULL THANJAVUR TAMIL NADU
847 NULL THENI ALLINAGARAM TAMIL NADU
848 NULL THIRUTHANGAL TAMIL NADU
849 NULL THIRUVARUR TAMIL NADU
850 NULL THUTHUKKUDI TAMIL NADU
851 NULL TINDIVANAM TAMIL NADU
852 NULL TIRUCHCHIRAPPALLI TAMIL NADU
853 NULL TIRUCHENGODE TAMIL NADU
854 NULL TIRUNELVELI TAMIL NADU
855 NULL TIRUPATHUR TAMIL NADU
856 NULL TIRUPPUR TAMIL NADU
857 NULL TIRUVANNAMALAI TAMIL NADU
858 NULL TIRUVOTTIYUR TAMIL NADU
859 NULL UDAGAMANDALAM TAMIL NADU
860 NULL UDUMALAIPETTAI TAMIL NADU
861 NULL VALPARAI TAMIL NADU
862 NULL VANIYAMBADI TAMIL NADU
863 NULL VELAMPALAIYAM TAMIL NADU
864 NULL VELLURU TAMIL NADU
865 NULL VILUPPURAM TAMIL NADU
866 NULL VIRAPPANCHATRAM TAMIL NADU
867 NULL VIRUDHACHALAM TAMIL NADU
868 NULL VIRUDUNAGAR TAMIL NADU
869 NULL AGARTALA TRIPURA
870 NULL AGARTALA MCL TRIPURA
871 NULL BADHARGHAT TRIPURA
872 NULL AGRA UTTAR PRADESH
873 NULL ALIGARH UTTAR PRADESH
874 NULL ALLAHABAD UTTAR PRADESH
875 NULL AMROHA UTTAR PRADESH
876 NULL AONLA UTTAR PRADESH
877 NULL AURAIYA UTTAR PRADESH
878 NULL AYODHYA UTTAR PRADESH
879 NULL AZAMGARH UTTAR PRADESH
880 NULL BAHERI UTTAR PRADESH
881 NULL BAHRAICH UTTAR PRADESH
882 NULL BALLIA UTTAR PRADESH
883 NULL BALRAMPUR UTTAR PRADESH
884 NULL BANDA UTTAR PRADESH
885 NULL BARAUT UTTAR PRADESH
886 NULL BARELI UTTAR PRADESH
887 NULL BASTI UTTAR PRADESH
888 NULL BEHTA HAJIPUR UTTAR PRADESH
889 NULL BELA UTTAR PRADESH
890 NULL BHADOHI UTTAR PRADESH
891 NULL BIJNOR UTTAR PRADESH
892 NULL BISALPUR UTTAR PRADESH
893 NULL BISWAN UTTAR PRADESH
894 NULL BUDAUN UTTAR PRADESH
895 NULL BULANDSHAHR UTTAR PRADESH
896 NULL CHANDAUSI UTTAR PRADESH
897 NULL CHANDPUR UTTAR PRADESH
898 NULL CHHIBRAMAU UTTAR PRADESH
899 NULL CHITRAKUT DHAM UTTAR PRADESH
900 NULL DADRI UTTAR PRADESH
901 NULL DEOBAND UTTAR PRADESH
902 NULL DEORIA UTTAR PRADESH
903 NULL ETAH UTTAR PRADESH
904 NULL ETAWAH UTTAR PRADESH
905 NULL FAIZABAD UTTAR PRADESH
906 NULL FARIDPUR UTTAR PRADESH
907 NULL FARRUKHABAD UTTAR PRADESH
908 NULL FATEHPUR UTTAR PRADESH
909 NULL FIROZABAD UTTAR PRADESH
910 NULL GAJRAULA UTTAR PRADESH
911 NULL GANGA GHAT UTTAR PRADESH
912 NULL GANGOH UTTAR PRADESH
913 NULL GHAZIABAD UTTAR PRADESH
914 NULL GHAZIPUR UTTAR PRADESH
915 NULL GOLA GOKARANNATH UTTAR PRADESH
916 NULL GONDA UTTAR PRADESH
917 NULL GORAKHPUR UTTAR PRADESH
918 NULL HAPUR UTTAR PRADESH
919 NULL HARDOI UTTAR PRADESH
920 NULL HASANPUR UTTAR PRADESH
921 NULL HATHRAS UTTAR PRADESH
922 NULL JAHANGIRABAD UTTAR PRADESH
923 NULL JALAUN UTTAR PRADESH
924 NULL JAUNPUR UTTAR PRADESH
925 NULL JHANSI UTTAR PRADESH
926 NULL KADI UTTAR PRADESH
927 NULL KAIRANA UTTAR PRADESH
928 NULL KANNAUJ UTTAR PRADESH
929 NULL KANPUR UTTAR PRADESH
930 NULL KANPUR CANTONMENT UTTAR PRADESH
931 NULL KASGANJ UTTAR PRADESH
932 NULL KHATAULI UTTAR PRADESH
933 NULL KHORA UTTAR PRADESH
934 NULL KHURJA UTTAR PRADESH
935 NULL KIRATPUR UTTAR PRADESH
936 NULL KOSI KALAN UTTAR PRADESH
937 NULL LAHARPUR UTTAR PRADESH
938 NULL LAKHIMPUR UTTAR PRADESH
939 NULL LAKHNAU UTTAR PRADESH
940 NULL LAKHNAU CANTONMENT UTTAR PRADESH
941 NULL LALITPUR UTTAR PRADESH
942 NULL LONI UTTAR PRADESH
943 NULL MAHOBA UTTAR PRADESH
944 NULL MAINPURI UTTAR PRADESH
945 NULL MATHURA UTTAR PRADESH
946 NULL MAU UTTAR PRADESH
947 NULL MAURANIPUR UTTAR PRADESH
948 NULL MAWANA UTTAR PRADESH
949 NULL MIRAT UTTAR PRADESH
950 NULL MIRAT CANTONMENT UTTAR PRADESH
951 NULL MIRZAPUR UTTAR PRADESH
952 NULL MODINAGAR UTTAR PRADESH
953 NULL MORADABAD UTTAR PRADESH
954 NULL MUBARAKPUR UTTAR PRADESH
955 NULL MUGHAL SARAI UTTAR PRADESH
956 NULL MURADNAGAR UTTAR PRADESH
957 NULL MUZAFFARNAGAR UTTAR PRADESH
958 NULL NAGINA UTTAR PRADESH
959 NULL NAJIBABAD UTTAR PRADESH
960 NULL NAWABGANJ UTTAR PRADESH
961 NULL NOIDA UTTAR PRADESH
962 NULL OBRA UTTAR PRADESH
963 NULL ORAI UTTAR PRADESH
964 NULL PILIBHIT UTTAR PRADESH
965 NULL PILKHUWA UTTAR PRADESH
966 NULL RAE BARELI UTTAR PRADESH
967 NULL RAMGARH NAGLA KOTHI UTTAR PRADESH
968 NULL RAMPUR UTTAR PRADESH
969 NULL RATH UTTAR PRADESH
970 NULL RENUKUT UTTAR PRADESH
971 NULL SAHARANPUR UTTAR PRADESH
972 NULL SAHASWAN UTTAR PRADESH
973 NULL SAMBHAL UTTAR PRADESH
974 NULL SANDILA UTTAR PRADESH
975 NULL SHAHABAD UTTAR PRADESH
976 NULL SHAHJAHANPUR UTTAR PRADESH
977 NULL SHAMLI UTTAR PRADESH
978 NULL SHERKOT UTTAR PRADESH
979 NULL SHIKOHABAD UTTAR PRADESH
980 NULL SIKANDARABAD UTTAR PRADESH
981 NULL SITAPUR UTTAR PRADESH
982 NULL SUKHMALPUR NIZAMABAD UTTAR PRADESH
983 NULL SULTANPUR UTTAR PRADESH
984 NULL TANDA UTTAR PRADESH
985 NULL TILHAR UTTAR PRADESH
986 NULL TUNDLA UTTAR PRADESH
987 NULL UJHANI UTTAR PRADESH
988 NULL UNNAO UTTAR PRADESH
989 NULL VARANASI UTTAR PRADESH
990 NULL VRINDAVAN UTTAR PRADESH
991 NULL DEHRA DUN UTTARANCHAL
992 NULL DEHRA DUN CANTONMENT UTTARANCHAL
993 NULL GOLA RANGE UTTARANCHAL
994 NULL HALDWANI UTTARANCHAL
995 NULL HARIDWAR UTTARANCHAL
996 NULL KASHIPUR UTTARANCHAL
997 NULL PITHORAGARH UTTARANCHAL
998 NULL RISHIKESH UTTARANCHAL
999 NULL RUDRAPUR UTTARANCHAL
1000 NULL RURKI UTTARANCHAL

here S_ID is coming null but i want the unique id which is in the tbl_staelist

eg 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 below

994 36 HALDWANI UTTARANCHAL
995 36 HARIDWAR UTTARANCHAL
996 36 KASHIPUR UTTARANCHAL
997 36 PITHORAGARH UTTARANCHAL
998 36 RISHIKESH UTTARANCHAL
999 36 RUDRAPUR UTTARANCHAL


plz do help
regards
abuzar

bitsmed
Constraint Violating Yak Guru

421 Posts

Posted - 12/09/2013 :  17:43:49  Show Profile  Reply with Quote
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
Go to Top of Page

abuzar
Starting Member

India
20 Posts

Posted - 12/10/2013 :  14:55:37  Show Profile  Reply with Quote
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 :)))
Go to Top of Page

abuzar
Starting Member

India
20 Posts

Posted - 12/10/2013 :  15:37:22  Show Profile  Reply with Quote
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)
end
alter 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.dbID


id customernumber name surname date
1 c0001 abc a 2013-12-11 02:02:35.770
2 c0002 efg b 2013-12-11 02:02:35.770
3 c0003 hij xyz 2013-12-11 02:02:35.770
4 c0004 klm pqr 2013-12-11 02:02:35.770

suppose if the date changes from 11 to 12

id customernumber name surname date
5 c0001 jhon a 2013-12-12 02:02:35.770
6 c0002 lee b 2013-12-12 02:02:35.770
7 c0003 sam xyz 2013-12-12 02:02:35.770
8 c0004 jim pqr 2013-12-12 02:02:35.770

the customer number should again start from c0001 onwards

plz do help thanks
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.27 seconds. Powered By: Snitz Forums 2000