Can you give me any example how to do it in real?

.value('.','VARCHAR(MAX)') , 1,1,SPACE(0)) AS Concat_Values

can you explain this part only?

thanks a lot.

Thanks... i'll try this and let you know...

Can any give me the easiest way to check?:

That will take much work. right? If you have any good idea can you share me how to design the table in easy way...

Yes. I agree.

Table Name: busroute

It has two columns: busno and places.

Busno ...

I am getting this error.

Msg 2812, Level 16, State 62, Line 18

Could not find stored procedure 'master.dbo.xp_smtp_sendmail'.

I got it thanks

Hi Kingston and all,

Got it. I have read some article. So If i make a query like

Select * from employeeId where employeeId between 'xxxxxx' and 'xxxx'

or

Select * from employeeId...

Nice explanation. But I dint get how it is related to the database. Are you meant that if i can pull the data where index no is 3 I can...

Can you please give me the sample code and sp query which you have written.

It means that table2 has multiple instance of fieldid (say eg. fieldid =2). If you delete filedid (fieldid 2)then all the fieldid 2 will be deleted in table 2 right?

Can you please explain this code little bit?

Insert into Table1

SELECT * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',

'Data Source=C:\test\testing.xls;Extended Properties=Excel 8.0')...[sheet1$]

finally this code is working..

Thanks bhuvanesh......