public inbox for [email protected]  

help / color / mirror / Atom feed

From: nikhil raj <[email protected]>
To: Steve Midgley <[email protected]>
Cc: [email protected]
Subject: 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
Date: Tue, 28 Feb 2023 01:15:46 +0530
Message-ID: <CAG1ps1y8PdxGG6t6Bzd2wsheb4B+M2BUmCktcBsSwAZhAG7oxw@mail.gmail.com> (raw)
In-Reply-To: <CAJexoSLXy5yH7NROj=1ZMHMX1iDVpSmh-f4iZsAQX5KWY5AxGg@mail.gmail.com>
References: <CAG1ps1z_-s1yZM3fGghR07s2VcGN5xWPHYqWNBEX-0ujV7m_Dg@mail.gmail.com>
	<CAG1ps1wWWGS1bai_N5n-aJzTQ7Efv9WR37OPAydnT1MBqbrZBQ@mail.gmail.com>
	<CAJexoSLXy5yH7NROj=1ZMHMX1iDVpSmh-f4iZsAQX5KWY5AxGg@mail.gmail.com>

Hi Steve,

Yes, that is correct.

On Sun, Feb 26, 2023 at 3:26 AM Steve Midgley <[email protected]> wrote:

>
>
> On Sat, Feb 25, 2023 at 12:37 PM nikhil raj <[email protected]>
> wrote:
>
>>
>> Hi All,
>>
>> Need help in rotation of data in *Postgres*.
>>
>> There is a table called crew_details
>>
>> [image: enter image description here]
>> <https://i.stack.imgur.com/cTarQ.png;
>>
>> There is a requirement to rotate the crew members for in weekly or on the
>> every 7th day and continue for rest 6days the same order of for the given
>> date range un till it reach end date . and the expected output should be
>> like this below
>>
>> [image: >] <https://i.stack.imgur.com/hjasI.png;
>>
>> Please can any one help me in in the rotation in *postgres SQL*
>>
>
> 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
>

view thread (4+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: 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
  In-Reply-To: <CAG1ps1y8PdxGG6t6Bzd2wsheb4B+M2BUmCktcBsSwAZhAG7oxw@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox