I don't what you did, but I did this. On my SQL 2008 instance I ran:

CREATE TABLE objects(id  int NOT NULL, name varbinary(400) NOT NULL)
INSERT objects...

Best is probably to do the pivoting client-side. In that case there will be no risk for SQL injection!!

As it happens, I also have some text about how to write...

You create a certificate and sign the procedure with the certificate. Then you create a user from the certificate and grant that user SELECT permission on the table in question....

And how do you expect us to be able to help you when you don't share any information at all? Permit me to point out that this is a forum...

Because Brian is smarter than me! 🙂

Seriously, we don't see your actual table, nor do we know your indexes, so it is difficult to answer. However, keep in mind that...

Your problem is a little complicated since your text columns lists on two levels. Since this is more of a presentation issue, maybe it should be done in the presentation...

I guess then that Service Broker is actually used in production. And the message comes from the production environment, but cannot be processed because of this error.

Did you change the...

Thanks, Erland... I missed it.  I'll be back.  I'm starting to think you might have been right, though.  I showed the Op the "easy way for understanding" with the...

Yeah, all I get for tsql_text is "Unable to retrieve SQL text".

Extended Events in SQL 2008 was a little half-baked, and things like capturing what is executed definitely works better...

Profiler is of course a really bad idea, but why would a server side Trace be impossible?

Jeff, he has already answered which version he has: SQL Express 2012 SP1. (So, Gaurav, you should apply the latest Service Pack for SQL 2012, which is SP4!)

Edit: When you say, "SQL Server may still opt to only assign the variable once.", are you indicating that SQL Server may not only get the order wrong but...

How would an ORDER BY or  TOP...

But here I still have a thing that is missing.

The list of all location is coming that's fine, but also I need the full list of Assets also (I marked...

No, I maintain...