I am running a for xml explicit procedure with about 18
tags - tag 3 uses a table called projects for instance,
tag 12 uses the projects table again but with a different
join.

I keep getting the parent tag not open error, even though
i have persevered with the order by clause. the weird
thing is that for some records i get the error, but with
other i dont. of course some records wont have data in all
the related tables - is this the cause of the problem?

does anyone have any idea of an easy way to locate the
exact line in a for xml explicit thats causing your err or
a better way to build them in the first place?

any help much appreciate - im on a tight schedule ;)