Thanks for the ideas. I actually solved it a while ago by putting the report inside another table that is grouped by NottificationType. Based on the NotificationType, I'm able to...

Thanks all for the suggestions. I was able to convince the business we need to change the format of the input file to include the keys and no have each...

Okay I got it working with changing the @sql and output vars to NVarChars.

Thanks.

I tried that and still got the error . This time it said the error was at the alias not the ).

matak (3/20/2016)

---

You need to give your

select *

from (

.

.

.

)

an...

Okay for some reason the link to the execution plan didn't come out right. Here it is again

twin.devil (2/24/2016)

---

Seems to me that you are using Dimension table from your DW and joining them with a table / view of a staging table. So means no direct relation...