I will miss not beginning my workday with these every day.  This is one of the only emails I subscribe to that I regularly read and learn from.  However,  I...

Hello Scott,

I've added new data that is more reflective of the entire data set.  There are fewer fields and now include the "Theoretical_Cycle" column (desired answer)  you had asked for.

By...

• This reply was modified 3 years, 9 months ago by  lmeinke.

Thank you Steve.  Your suggestion may work and I will give this some thought.

As to the rest of your text I absolutely agree.  I have never written a cursor (that...

Hello Again Steve,

I had thought this code worked as designed but have found it does not take into account the 90 criteria in sequence (1st 90 days... 2nd 180 days....3rd...

Hello Steve,

This gives me a start.  The data provided were for one theoretical provider with one patient.  In other words, the ID column pertains just to that provider/patient combination.  I...

• This reply was modified 3 years, 10 months ago by  lmeinke.

Good Morning Steve,

Thank you so much for your suggestion and effort.  I will get to this late this morning and update you this afternoon.  I very much appreciate your willingness...

Yes, both of them have to "re-start" at appt#1 and day#1 when the criteria is met (>= 6 appts & >= 90 days).

Thank you again Steve.  I believe the image follows the rules I suggested.  We need to always have 6 "rows" or appointments as that is one of the criteria.  In...

Thank you Steve for this suggestion.  I quickly tested this and am not getting the results wanted in the "Theoretical_Cycle" column I indicated in the image.  I will return to...

This is one last plea for help on this post.  I was hoping someone in the community may have run into this type of scenario in the past?  My thought...

After getting past my initial offense I can see how lacking my original post was.  I've added an image for "desired" results and indicated the column with a red arrow. ...

• This reply was modified 3 years, 10 months ago by  lmeinke.

Jcelko... I thank you for helping to write the standards for this language.  You have something to be very proud of.  Your behavior/communication style... not so much.

The truth is I've been out of coding and development for a few years.  I haven't posted many questions and when looking at the forums the proper path is not...

OK...my issue again....sloppy typing. I had an nvarchar type vs. varchar type...sorry.

Dwain's solution does run however it returns double the number of rows from my original table and takes...

Dwain,

The error message only mentions a type mismatch...nothing about length. I will continue to work on this this morning as time permit.

Again, thank you very much for your tenacity...