You'll need the following tasks:

1. ExecuteSQL task - this is the first task in your control flow. This should query your table and return the results into a variable...

Some of this depends on how you want to summarize and display the data. Let's rewind a bit.

Can you provide an example of how you want your final result...

You mean a count and sum of only negative variances?

Check your table DDL. The error tells you exactly what to look at.....number of columns (including order) and data types.

Your...

Yep, that's exactly how you have to...

SQL Server does not recognize when you use a column alias within the same query. You have to fully define NumberOfDays in your calculated column.

SELECT DATEDIFF(dd, COALESCE(tbl1.Opendate,tbl?.YourOtherDateColumn) , tbl1.ClosedDate)...

If so, try this:

DECLARE @Table TABLE (W int, X int, Sequence int, Z varchar(10))

INSERT INTO @Table

SELECT 1,1,1,'text' UNION ALL

SELECT 1,1,2,'><' UNION ALL

SELECT 1,1,3,'text' UNION ALL

SELECT 1,1,4,'text' UNION ALL

SELECT 1,1,5,'><'...

In order for you to know what is between the values, you must specify how they are ordered. Is it safe to say that each WX value is ordered...

Do you mean that your NumberofDays calc needs to test for OpenDate being NULL?

If so, use COALESCE. Since you have not specified where that second date column comes from, I...

Huh, kind of ironic, but this was your 420th post......

For the record, I am not pointing this out to promote 420 logic...just thought it was interesting (I'm sober...

To be honest, I'm not real familiar with working with Microsoft ACCESS. I chimed in because I've worked with schema separation. Where is the stored procedure located?

Well, if you've already got the data in a staging table, you may consider doing as Jack suggests and just move it with T-SQL. If the data is already...

Good info Lowell. I had wondered if that could be done with triggers and I looked into that before I posted my reply. I looked at the DDL...

I don't think there is a way to retrict the source of a login, but you can set up a SQL trace so that you can monitor how and where...

Duplicate post, please follow this thread here