Re: Take the data from table and rotate the member on every 7th day or starting day of the week and continue for whole week continue till the date range

Thanks for posting the table and output. I'm not totally clear on the business requirements here but it seems like you have a crew rotation sequence that is, in this case modulus 5?

I'm not sure I've got the SQL skills to easily make this in a single query (but surely others here can). But just to clarify the business rules for such a SQL wizard, I would think the solution involves some kind of hidden variable (new column, aggregation, built in function?) where the number 1 team member's crew position number is incremented by 1 mod 5 for each new shift date. Whenever that tracking counter becomes 1 again, convert their actual shift order number to 5, and subtract 1 from every other crew members' crew position number. Does that sound like the correct business rule for the process you're trying to create?

Steve