You should get...

You've been around long enough to know that you should use the Insert/edit code sample command.

Drew

In my experience, you are correct.  SSRS is the least flexible of the reporting tools that I have used.  This is how I would rank the ones that I have...

Please use the Insert/edit code sample at the top of the box where you enter text to post.  It retains your formatting.

Because you didn't use it, your formatting is all...

I can do it.

I've seen several posts where people think that STUFF() is doing concatenation, so I'm wondering if the request was really for how to use XML concatenation.  Any sense from the...

You're confusing the data layer with the presentation layer. ...

Joe, You would take up an ANSI/ISO standard with Microsoft, because they are not complying with the standard and you want them to comply.  Until they do, stop pushing the...

This is demonstrably FALSE.  You have been told repeatedly that this is false.  If you don't like it take it up with Microsoft.  Until...

Use NULLIF() to replace the -1 with a NULL.  You can then optionally provide a specific date to replace NULL values.

Drew

You're using the lazy method of creating a temp table.  Instead of using SELECT/INTO you should be creating the table and then using INSERT/SELECT.

DECLARE @ProcessID TINYINT =...

But it's easy enough to clean up.  Just REPLACE(REPLACE(@sql, '1=1 AND ', ''), 'WHERE 1=1', '').  So if there are additional conditions, you remove the 1 = 1...

This site is specifically for SQL Server (T-SQL).  I could tell you how to approach this in T-SQL, but I don't know whether that solution will translate to PL/SQL.

The T-SQL...

But it's easy enough to clean...

Clean up your code and make sure that it runs.  I stopped trying to fix your code after the third error.  Also use the insert/edit code sample when inserting code. ...