Here is what I am looking at which provides the proper results but still seems too RBAR.

declare @today datetime = '9/23/2016'

declare @rc int

declare @complete table (suspid int);

declare...

Each entity has successive periods. They can continue forever.

Your CTE is adding the total suspension duration in the first period. The solution must apply the suspension to...

The incentive periods are 3 calendar months if there are no suspensions not including the end date in your example.

If an agreement starts on 1/1/2016 then the baseline incentive periods...

You are setting the method to post but appears you should be doing a get. POST is should only used when you are passing a payload back to the...

I think I originally got this from Steve Jones or at least one of his posts. Made a couple of tweaks to handle Roman Numerals because we mostly use...

If your supplier data is unique the you don't need distinct when looking for records that don't match since there should only be one of each to begin with. ...

Thanks Greg, There is actually a whole other part of the query that deals with the randomization of the records that I left out to simplify the issue to the...

Sorry Lutz, I just didn't read it that closely.

This would be easier to help you with if you provided some sample data and sample results. I still believe you can do this with a set based solution.

so is the inner query really running one time for each typeid?

That works great but I don't get why. I'd appreciate it if you could give me the explaination as well.

If I get waht you are looking for 7 new records from each previous record, this should work in one step on the server.

insert into newtable(field1,field2,field3,other fields)

select field1,'Monday' DOW, Field2...

I also use 8765 knowing only that it fixes the issue of a field returning the wrong data length in ODBC. I would love to know if it...

I've been doing this with DTS since SQL7. One catch I don't see mentioned is that you have to log in manually the first time to cache the key....

I think, using Jeff's hint for the select into (I still don't get the (mod 5) + 1) and Lynn's code, I simplified it a little

select identity(int,1,1) did,dlc into...