I am using a dynamic select query in reporting Services. The CASE statement doesn't work, I tried that before but thought maybe the syntax was wrong. This is a real...

I found an article, http://www.sommarskog.se/dynamic_sql.html that basically explains that it is not really possible to do this. In the article they explain how to create a new function that dynamically...

I have gotten the Query to RUN, using those techniques, but the parameter value is not passed. The quoted string is merely part of the query, not active in the...

If I understand, this would run the query locally....

I have to use the

SELECT *

FROM OPENQUERY(LinkedServer, 'SQL HERE')

If I don't use this the linked server...

That solution did not work as I have a String of text...

IN ('Company1, 'Company2', 'Company3')

Maybe I wasn't clear enough.

This is part (subquery) of a large roll up query. Essentially what I need to determine is if it's possible to accomplish this task.

Here is...

The big whoosh you heard was all of those suggestions going over my head.

What I can grasp is that I am basically creating a temp table, then populating it with...

The Derived table worked! I have only seen this kind of coding in T-SQL, ala the GURU's Guide by Ken Henderson... Any tips on figuring out why this worked. What...

Thanks for your reply. I have emailed you some files, but I will post the Union query here perhaps you can make heads or tails...?

...

...When the mention of Excel causes the veins in your head to start bulging and you run for the nearest exit.

**Everyone knows Excel is the Devil