Viewing 15 posts - 4,156 through 4,170 (of 9,643 total)
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...
September 30, 2009 at 10:07 am
Jack Corbett (9/30/2009)
September 30, 2009 at 8:30 am
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...
September 30, 2009 at 7:51 am
Can you post table definitions and some sample data? Is CalendarDate a datetime/smalldatetime?
September 30, 2009 at 5:41 am
john.arnott (9/29/2009)
September 29, 2009 at 6:56 pm
No problem. Glad I could help. It really makes sense if you look into how SQL Server processes queries. Search for Logical Query Processing.
September 29, 2009 at 12:05 pm
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,
...
September 29, 2009 at 11:38 am
Here's an example of one of my favorite types of post. Question, who needs a stinking question?
September 29, 2009 at 10:42 am
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...
September 29, 2009 at 9:57 am
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.
September 29, 2009 at 9:35 am
What component are you using to call the stored procedure?
September 29, 2009 at 9:33 am
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.
September 29, 2009 at 9:27 am
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...
September 29, 2009 at 9:21 am
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?
September 29, 2009 at 8:30 am
Nice article. Easy to follow. What I'd like to see is an article that shows a practical use of Service Broker.
September 29, 2009 at 6:44 am
Viewing 15 posts - 4,156 through 4,170 (of 9,643 total)