This is more of a "know your data" scenario. NULL values can themselves represent data, as such, but might not necessarily represent what the column represents.In this case, you have...

Yes, but you'll need to supply NULL values for the columns that don't exist. So, in simple terms:
WITH AllData AS (
  SELECT Title, Firstname, Surname,
  ...

If the user couldn't access the report, they would get a different error to that (permission denied). That sounds like the connection to the server isn't working, either because the...

Great that you provided sample DDL and DLM, however, without an expected output or your logic, we can't give you an answer. Also, you have CustomerType as a column, but...

John does raise a good point here. I might be wrong, but unless I recall incorrectly sqlcmd is shipped with SSMS not SQL server. And SSMS is not shipped with...

How are you connecting to the other server? Is the datasource set to the other server, or is datasource the same as the SSRS server, and then the query run...

There isn't really much to the PoSh side of things. The main thing you need is to have the configuration file for your server available. That is very much unique...

I'm really not sure what you're asking here, sorry. Could you elaborate further? Also, as I said, using your insert into your table #Final, it destroying any way to identify...

I think this might be closer to what the OP is after:
WITH Summary AS (
  SELECT O.OrderID,
    STUFF((SELECT ', ' + CAST(sq.OptionID AS varchar(6))...

The problem here is your table set up, you lose any relationships between your data when you insert it into your table. This uses your XML directly instead, but gets...

I'm not 100%  sure what you want here, but you can query XML by using XQuery in T-SQL.

Without any sample data, or expected output, there's...

I believe, by "images" the OP actually means emoticons, which have a unicode value. These don't display well (at all?) if you're running Windows 7 or prior sometimes, as they...