The explanation is more complex than the implementation as all I did was create a job that starts a job when the data has changed. Also the folks I...

Yeah, I looked at that, I do have Enterprise Edition, but don't want the complexity that comes with it as I am a consultant and won't be around to...

Good Article that gave me some ideas. Here is an SP I created after reading the article that combines it all in 1 place, plus additions that you can...

The right thing for the customer is to notify Amazon about the error at the time of purchase. The right thing for Amazon is to not charge those who...

We didn't need to test it, I am sure it will work. Wow, that is a statement I don't think any developer should make.

Also, if the DB is down...

I agree with Andy about saving information, but when I made that suggestion I was thinking about places where I have worked, and, to be honest, most users, in my...

I think most, if not all, SSC members would agree that you should handle such an error gracefully, and let the user know what happened.

As far as being...

I am pretty sure that VB.NET is converting the Nulls to Nothing which is not the same as null. You should check your parameters for Nothing in VB.NET and...

Are you doing this from within a trigger or another function?

SSC is the best resource I have found to troubleshoot SQL Server problems. I have probably learned something from each of the top 20 posters as I see their...

I thought it was an excellent article and another tool to troubleshoot issues.  Certainly table size would come into play, but this is just a way to look at space...

Have you considered passing in XML and then using the SQL XML functions to create the temp table, or better yet a table variable? 

I would use:

where date_added between DateAdd(Month, -6, Getdate()) and DateAdd(Month, -3, GetDate())

 

I have looked into this as well.  The only way I have found that this can be done is to create a data-driven subscription which will provide the File Name.

The on ly time I have seen this happen is when the subreport is not in the same project as the main report.  Are you having this problem in the...