i give example only..

how to insert two tables in single quarie ...like above

i want output like display fourthpart order

8-3-132/3

8-3-132/3

8-3-132/3

8-3-132/3

8-3-132/53

8-3-132/53

8-3-132/75

8-3-132/77A

8-3-132/77/A

8-3-132/77/A

using ur code

not display ordey

if my table like

3-2-10

3-2-100

3-2-11

3-2-3

3-2-33

3-2-4

using ur code display order o/p like

3-2-10

3-2-11

3-2-100

3-2-3

3-2-33

3-2-4

if houseno like 3-1-900 ,3-1-92/4 ,.......not display order

output like

3-1-900

3-1-92/4 hyd

3-1-99/7

using.......

WITH MyAddresses (HouseNo) AS ( -- meagre sample data set

SELECT '3-1-900' UNION ALL

SELECT '3-1-92/4 hyd' UNION ALL

SELECT '3-1-99/7'

)

SELECT a.*,...

if houseno like 3-1-900 ,3-1-92/4 ,.......not display order

output like

3-1-900

3-1-92/4 hyd

3-1-99/7

using.......

WITH MyAddresses (HouseNo) AS ( -- meagre sample data set

SELECT '3-1-900' UNION ALL

SELECT '3-1-92/4 hyd' UNION ALL

SELECT '3-1-99/7'

)

SELECT a.*,...

if ex - table like this below format using ur quarie not display order

WITH MyAddresses (HouseNo) AS ( -- meagre sample data set

SELECT '3-12-19 . HYDERABAD'...

k ..thanku

if house no like...

SELECT '3-4-53 . HYDERABAD' UNION ALL

SELECT '3-400-199/1.ASVV' UNION ALL

SELECT '3-49-vizag' UNION ALL

SELECT '3-53-22,nagar' UNION ALL

SELECT '4-5-1300.old colony' UNION ALL

SELECT '4-500-120' UNION ALL

SELECT '3-4-' UNION ALL

SELECT...

Thanks for replay ......

ur quarie is working ....... thank u sir

again it shows error like

Msg 537, Level 16, State 5, Line 1

Invalid length parameter passed to the LEFT or SUBSTRING function.

Thanks for Replay...........

but shows error

" Conversion failed when converting the varchar value '300,' to data type int. "

Thanks for replay ...but ur quarie is not work for above format

IT SHOWS ERROR

Conversion failed when converting the varchar value '1867 C' to data type int

the first method is ok but ..... it works only if housenumber is integer only ...

it shows error when housenumber mixed wit varchar .............

plz write the code if...

Msg 245, Level 16, State 1, Line 1

Conversion failed when converting the nvarchar value '17-280' to data type int.

it shows error like

Msg 245, Level 16, State 1, Line 1

Conversion failed when converting the nvarchar value '17-280' to data type int.