Yup, it seems quite obvious when I look at it now, though my logic first told me, hey, if there was an error, there was nothing to perform transaction on....

Thanks, and I only just now figured it out.

Yes, it was ssms, trying to remove a record from a table that is referenced many times by many tables. We don't...

I re-ran it, I think I made a mistake when copying the xsl from her, sorry ... So, now that I corrected it, I only get an error: "XML document...

Unfortunately it's exactly the same thing as before. But thanks for trying 🙂

Yes, I can

Current Result:

<?xml version="1.0"?>

-<Report xmlns="test_3">

test_3

<Document>

<Assessments>

<Assessment>

<Date>05/01/2013</Date>

<Type>Physical</Type>

<Completed>1</Completed>

</Assessment>

<Assessment>

<Date>06/14/2013</Date>

<Type>Physical</Type>

<Completed>0</Completed>

</Assessment>

</Assessments>

</Document>

</Report>

Wanted result:

<Document>

<Assessments>

<Assessment>

<Date>05/01/2013</Date>

<Type>Physical</Type>

<Completed>1</Completed>

</Assessment>

<Assessment>

<Date>06/14/2013</Date>

<Type>Physical</Type>

<Completed>0</Completed>

</Assessment>

</Assessments>

</Document>