If u want to do this using any programming lang. then u should check the documentation of lang. There will be some methods provided by its api to extract xml elements.

You can use OPENROWSET[^] function. Something like: SELECT * FROM OPENROWSET(BULK 'path\file', SINGLE_BLOB) AS alias You can place the result into a variable and then use CONVERT[^] to convert the data to XML (or you can do the convert in the select statement). After that you can insert the data into the table. If you want, you can compress this to one statement, but it will be harder to find errors if such occur. INSERT INTO targetTable (targetColumn) SELECT CONVERT(xml, alias.sourcecolumn) FROM OPENROWSET(BULK 'path\file', SINGLE_BLOB) AS alias The need to optimize rises from a bad design.My articles[^]

Have a look at the example B in CREATE PROCEDURE[^] The need to optimize rises from a bad design.My articles[^]

Timer control which comes with AJAX tookit? If yes, it uses JS setTimeout() method. Navaneeth How to use google | Ask smart questions