At first glance you are missing an alias for the derived table - just add an alias after the last bracket

😀

I prefer to do what needs to be done then get on with writing positive code - cleanup code is for DBAs 😀

I would:

Change the process so it doesn't generate empty tables.

Then filter the table list where name contains "MyTable_".

Open Object Explorer Details, right click column headers and include "Row Count" in...

I guess one solution would be to raise the error again with a user error level, but include the original error level in the message?

By the way, unrelated, but...

Thanks, I'd...

I meant to mention that the sample data provided has nothing we can ORDER by to ensure the concatenation happens as expected.

You should include something for that and add ORDER...

I guess we should handle NULLs as requested...

SET STATISTICS TIME,IO ON;

WITH ALL_A(A) AS (SELECT DISTINCT A FROM #T)

SELECT T.A

...

It's a horrible three scan plan...but I can't think of another way right now...

WITH ALL_A(A) AS(SELECT DISTINCT A FROM #T)

SELECT T.A, CONCATSTRINGB, CONCATSTRINGC

FROM ALL_A AS T

CROSS APPLY (

SELECT...

This sounds a lot like an Anti-Virus problem.

It's unlikely that two processes would use the same temp file name - and especially to keep doing it.

I suppose it's also possible...

If I were you, I would log this on Connect and Trello as a bug - I just tried it with a simple report that runs three selects that are...

Well, if you...

Ah well, it was worth a bash...

I guess it is running the first query once for the parameter, then again for the report and that messes with your timing.

Depending on your exact report, this may work - it works in principle, but performance might be an issue...

Create a hidden parameter that takes it's default value from Dataset1

Modify the...

Sergiy (9/7/2016)

---

mister.magoo (9/7/2016)

---

If I need to handle things differently when the value is zero (I don't want to return NULL), I end up with a CASE statement such as

CASE...

I would agree that in a lot of my t-sql code, I return a null for division by zero.

This is not, however, because division by zero equals NULL.

It doesn't.

I...