The list of work orders where work orders have the same Site, Section and same date

Thank you Scott

Thank you all, this seems to work

That's correct!!

Hi Thom

Thanks for the response, it's unlikely i'll have a single file which is greater than 8MB because the database where i've downloaded the files from doesn't allow a sigle...

Hi Chris
your query work perfectly. it's what I wanted.

Thank you kindly

thanks for the response

the duration varies for each tasks hence I can't group it together

Thank John
it did work.

I forgot to mention
the RowGroup  = Status
ColumnGroup = RequiredByDate
Data = Count(WorkOrder)

Thank you so much

It worked as expected.

Regards

hi John

No I haven't

what I need to do is when the user select the date range: 20161201 to 20161231 I want to be able to return data for 20161225 to...

Yes, I want to be able to enter multiple values for the @shift.

Thanks for the response, but I tried that solution it's only works if you select single value. I you select multiple selection the WHERE clause doesn't work.

Regards,

if the value of the @shift = 'Afternoon Shift (FMF/SVP)' it must return 'Afternoon Shift'

else 'Afternoon Shift'. Hence the case statement:

WHERE

s.Description IN (

...