The staging area would be used for the data warehouse and other processes as needed, at this time most of the ETL is handled in the SSIS packages pulling from...

Thank you so much!

Thank you all so much!

Thank you so much that looks like it works!

Sorry for the confusion. Here is additional sample data;

Create Table #Goals (

PersonId INT

, GoalDate Datetime

, GoalStatus INT

)

INSERT INTO #Goals (PersonId, GoalDate, GoalStatus) VALUES ('125600','1/10/2013','1')

INSERT INTO #Goals (PersonId, GoalDate, GoalStatus)...

Here is some additional sample data

Create Table #Goals (

PersonId INT

, GoalDate Datetime

, GoalStatus INT

)

INSERT INTO #Goals (PersonId, GoalDate, GoalStatus) VALUES ('125600','1/10/2013','1')

INSERT INTO #Goals (PersonId, GoalDate, GoalStatus) VALUES ('125600','1/12/2013','0')

INSERT INTO #Goals...

No, if the next record is GoalStatus=0 the consecutiveCount goes to 0. Then the next record where GoalStatus=1 the consecutivecount goes to 1.

Sorry about that. Here ya go;

GoalStatus; 1= Success, 0=UnSuccessfully

Create Table #Goals (

PersonId INT

, GoalDate Datetime

, GoalStatus INT

)

INSERT INTO #Goals (PersonId, GoalDate, GoalStatus) VALUES ('125600','1/10/2013','1')

INSERT INTO #Goals (PersonId, GoalDate,...