Great Article!
I had 1 problem on Step 9 - no variable showed up so I created one. Then it looked like the articles
When testing in step 10 the HTML is empty 🙁 I tested the SQL in Management studio and I see a XML result set returned.
I checked on the Variable and the value is
<ROOT><?MSSQLError HResult=\"0x80004005\" Source=\"Microsoft XML Extensions to SQL Server\" Description=\"No description provided\"?></ROOT>\r}String
Any ideas on what went wrong?
Thanks in advance!