Hi,

1. This is my own assembly and not an assembly from the BCL.

2. The same code was working previously with the permissions as I have mentioned above. It suddenly stopped...

Hi,

Here are the answers to both of your questions.

I have used the ALTER DATABASE property to set the trustworthy property on.

Also, I believe External Assembly Access permission is given...

I saw the reply somewhere in the chain.

Try this

Select * into #temptable

from your xml file(not sure about the syntax)

Drop the first column

Then

Select * from #temptable for Xml...

Use pivot statement. Its been a boon. Try this

http://www.simple-talk.com/sql/t-sql-programming/creating-cross-tab-queries-and-pivot-tables-in-sql/

1. Are you sure that the duplicate data is present in the database and not only visible on the reports?

2.If its present in the database you need to identify the...