John,

I don't think that is a glitch. I don't think the forum has ever really shown the description. I don't think the OP knows what the problem/question is...

Jack Corbett (9/30/2009)

---

What tables do CalendarDate and date_closed belong to? It really would be much simpler to provide an answer if we had table definitions, some sample data, and...

What tables do CalendarDate and date_closed belong to? It really would be much simpler to provide an answer if we had table definitions, some sample data, and expected results...

Can you post table definitions and some sample data? Is CalendarDate a datetime/smalldatetime?

john.arnott (9/29/2009)

---

Somehow the text of the original question doesn't show up in the main post, but I was able to copy it from the annotation seen when hovering the mouse...

No problem. Glad I could help. It really makes sense if you look into how SQL Server processes queries. Search for Logical Query Processing.

I believe moving the filters on BILPRCP from the WHERE clause to the ON clause will return the results you are expecting. Like this:

SELECT

MSTBALP.CLIENT,

...

Here's an example of one of my favorite types of post. Question, who needs a stinking question?

The first recommendation I'd make is that you need to remove the functions that are being used against columns in your WHERE clause. Basically using function against a column...

You can also take a look at the Cross Tab and Pivot articles linked in my signature line. They give you options in addition to the PIVOT function provided.

What component are you using to call the stored procedure?

And your question is? I don't see a nested case in your code. If your question is "Is it possible?" then the answer is Yes.

I'm pretty sure this a known problem and design limitation with SSRS. SSRS is basically designed to work with IE and the printing capability uses an ActiveX control that...

What os are you running SQL server on?

Are you running on a domain?

Can you post the exact error message you are getting when you have a failed login?

Nice article. Easy to follow. What I'd like to see is an article that shows a practical use of Service Broker.