This is the data behind several SSRS reports.  The user selects the craft group from a dropdown.  If they select the word "ALL", then the SQL would be craft_group <> 'OTHER'. ...

Thanks SSCrazy!!! That gives me what I needed. Sorry for not having the data correct. Can't thank you enough!!

Yep, you're right. I missed it in the desired results.

Thanks for taking the time but MATL is not the min hold so this wouldn't work.

Thanks ZZartin, that returned the correct results. Now I'll review it and make sure I understand what it's doing. Thanks again, I knew there had to be a...

Closer but it's missing job/task 13000188/500. This job has a two holds and because it has another hold beside MATL, it needs to be in the list.

Yes I included 13000188/500 because it should be there. It has a NEF hold along with the MATL hold. And because of the NEF hold, it needs to...

Thanks for the quick reply but No it's not the desired result. It has jobnbr/task 13510859/525 in the result which should not be there .

Hum, instead of a cursor I used a while loop. Was thinking it would be so much simpler if I could do everything in one select statement!

Initially this is what I indicated the data should look like.

jobnbr task schstrdt tnbr

12500173 500 09/18/2013 07:30 T00

13502889 500 09/25/2013 08:00 T01

13506023 0 09/20/2013 07:30 T00

13506779 0 09/26/2013 07:30 T01

13506780...

As a former supervisor of mine said "the devil is in the details". I forgot about something. The stored procedure may skip weeks but the Tnbr should continue...

Gosh it's so simple:-D! Thanks!!!

Correction if schedule start date is 2014-01-12 the tnbr should be T17.

On second thought that works fine as long as the schedule start date is the current year. But when i run this on a job that has a schedule...

Thanks Dan. That works!!