Yes, that is the part of the query that takes 40 minutes.

I'll check the execution plan.

How could I implement and index on...

THANKS for the changes suggested to solve my problem.

Performace has taken a HUGE nose dive and I am not sure why. The inner Select result named as t3 performs just...

This xp is ONLY executable by:

1. A user/group (domain or SQL) that is a member of the sysadmin group

2. Service Startup Account for SQL Server Agent on the Server. In the...

Paul - Thanks!

The proxy account I was using for the SQL Agent Service did not have the correct permissions on the folder in...

I am interested in using this approach for a current project.

Let's say I have a sp that ultimately writes records to a temp table named FileOut which has only 1...

Wow!!! I have a bit to chew on (sorry for the pun) with these great responses.

The usage of this is for a website that will be using the information to dynamically generate option...

In RE your original question: "...a fact table to store an actual data and year-to-date data."

From a dimensional modeling perspective this is possible but not recommended as you are mixing...

Linking to SQL table via Access is not a "bad" idea and is much better then placing an Access database with data in a central network folder and permitting multi-user...

SQL Reporting Services can absolutly accomplish these tasks. In fact they have the ability to convert MS Access reports to SQL Reporting Services reports.

When you import a report into Report...

     I have worked with Crystal Reports for the last 6 years to write reports directly versus ERP datasources. I originally felt the same way as you both. The...

THANKS for the ideas...

I am still stuck on how the WHERE clause would be constructed. The requirement is that these date ranges may...

Obviously you could convert the time to a char based format and store in a SQL char or varchar field. I don't think this strategy this would be useful except...

An example of a prepared query is a stored procedure. This is precompiled on the server in advance of execution and therefore has performace benefits (e.g the execution plan is...

1. I need to create a few reports with some repeating pages. For example, in one of them I need to have a cover page, then couple content pages, then...

Microsoft Reporting Services in Action by Teo Lachev (ISBN 1-932394-22-2) has very useful content if you are interested in integrating SQL RS reporting into applications.

The WinForms Adventure Works Report Wizard...