No. It just sounds like the install was corrupted.

What are the indexes on the table?

Have you looked at the execution plan (even estimated) as I'd guess the sort is killing performance?

I'd reinstall the client tools.

You can't use NOTHING in the stored procedure. You would use NOTHING in an expression when passing the report parameter value to the query parameter. Like:

=IIF(String.IsNullOrEmpty(Parameters!Parameter.Value), Nothing, Parameters!Parameter.Value)

I have never experienced any harm by answering yes.

Duh, why didn't I think of that?

I'm going to assume that you mean any time a student is absent consecutive days. Here's a solution, but I think it needs some more work to perform with...

I need some more information.

What SSIS components are you using?

What is the flow of your SSIS package?

How are you getting the data from your source and what is your source?

I'd suggest that you always get your Product information (name, etc...) from the Products table and then include a LEFT OUTER JOIN to the Quotes table to get quote information....

Me, too. Just the other day somebody asked if I spoke Spanish...

jacroberts (8/10/2009)

---

Many of the articles are well written which is one of the main reasons I read this site. As of now there have been 16,475 views of the article,...

I realize I am a bit late tot the party regarding today's lead article, but I'll comment anyway. Yes, there was some bad advice in the article, but there...

Could you actually attach an Excel file with the data?

Thanks.

Fortunately I have never had to deal with that. Of course that's why you are the security expert and I'm not.:-D

Bob,

I downloaded the file and all I see in it is SQL.