A bit naff (for USA readers translate this as turkey!)

You can use SELECT to create an element based XML data source and then

apply XSLT style-sheet(s) (that includes HTML) for the...

Using sp_ExecuteSQl isn't a good idea....

.....HMC

Experience suggests...if user says data is being truncated ,first check the size of any fields (or intermediate fields) used to store that data.

Regards

HMC