Thanks to both Wayne and Paul for their solutions. I ended up using Paul's solution because when run against my larger data set it kept out those records that...

Jeff,

I have been reviewing your solution and have been struggling with bringing all the rows of the table in. I ran your solution just as it is against my...

Jeff,

Here is my attempt at your suggestion. I left the WHERE commented because otherwise I lose claim numbers 45 and 51, whose first status was closed. I am...

Jeff,

I would expect to see it as a reopen in Dec 2009. It would not ever appear in any counts before that date because it was always closed to...

You are correct on 55, i misspoke about it being considered closed.

We are looking at the status at the end of the month and comparing it to the prior month,...

I wanted to follow up and see if anyone had further suggestions on this issue.

Thank you.

I apologize. I pasted the SQL in a few times and overwrote the calendar part.

-- Create the calendar table in your development database

CREATE TABLE [dbo].[CALENDAR]

(

[calendar_date] [smalldatetime] NOT NULL,

[weekday_flag] [bit]...

Jeff,

I think you are thinking of Peso's Subscription speed challenge query, which I have looked at but this has a few more complexities because you need to calculate new, reopened,...

I am returning the audit id to the package using a Stored Procedure. I use just one user varialbe to store the id.

Thank you Az.

What needs to be in the path with the -g512 switch?

I currently have:

-dC:\Program Files\Microsoft SQL Server\MSSQL.3\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL Server\MSSQL.3\MSSQL\LOG\ERRORLOG;-lC:\Program Files\Microsoft SQL Server\MSSQL.3\MSSQL\DATA\mastlog.ldf

I would be interested in hearing the resolution to your issue, as we just started seeing similar issues last week and are lost on what to do.