I'm thinking that you really only need one table here, and it would be the solution table.   Then the cursor could do an UPDATE to that table and the results...

Assuming this is SQL 2016, you can use the STRING_SPLIT function, but understand that while you get a table, you would get one row per address fragment.   The problem would...

If it were that simple, it would already be working.   As Gail explained fairly clearly, you're querying a DMV that may not be returning what you seek when it runs...

A few things about this:

1.) This would be very difficult to achieve in T-SQL
2.) Why would you want to do this?   There are much better tools already...

That part where you have RIGHT(r.name, 8) is likely the reason.   You can't schemabind to a function on a field.

Look here:   https://social.msdn.microsoft.com/Forums/sqlserver/en-US/e44c5315-43ca-45e6-b119-b43a4d5e6fb8/how-to-pass-parameter-in-mdx-query-using-management-studio?forum=sqlanalysisservices

which also links to here:  http://prologika.com/how-to-test-ssrs-mdx-queries-in-sql-server-management-studio/

If you were just using the browser on the iPhone, you'd use an http address.   However, I'm not at all familiar with the app you're using, and usually, a connection...

I would think you could take that last query and have it be the input to a REPLACE function where you just strip out any commas, perhaps.   Unless, of course,...

Sorry, but that was all I could think of, as I've not actually seen this particular graph type as yet.   However, I assumed you tried making the overall graph different...

I vaguely recall dealing with a "Cache" database via ODBC once, but don't recall a lot of detail.   You may find that any sizable record count is problematic.   Also, you may...

Just thinking about whether your page size might have an impact.   If the "graph" itself is large enough, page size might force the labels to the inside.   Also check your...

To be honest, that table doesn't do enough for you to waste your time using it.  You should probably create an inline table-valued function to completely replace that table.   All...

In general, you should let grouping in SSRS take care of calculating totals.  Using custom code should be avoided for that kind of purpose.   Better yet, calculate your totals in...