astrid 69000 (4/20/2016)

---

Thanks so much.

I read and read and I understood. and it worked :-P:-P

Here is my code

declare @x xml

DECLARE @site_value INT;

SET @site_value = 0;

WHILE @site_value <= 1000

BEGIN

select @x = (select myxml from myxl where id = @site_value)

SET @site_value = @site_value + 1;

insert into mytablexml

SELECT FullPath FROM dbo.XMLTable(@x);

end;