1 sql requests (ms sql)

Databases & SQL — incorrectly specified categories?

Project translated automatically. Log in or register, to view the original Every hour new idy arrives in the base.There are 5 managers.And you need to distribute new ids among managers, fix 1 id on one manager, and if the ids were 6, 7 and so on, then you need that 6th is already fixed again on the first manager.And so every hour.A puzzle that I can’t understand how to make the new idy automatically attached behind managers in order.And this order was not broken every hour.that is.Suppose at 8:00 am there was 7 id.The last ID is fixed on the second manager.And here you need to be at 9:00 after the arrival of the new id, start fixing from the third manager and so on, through the circle.Also, the receiving IDs are not always numerated consistently.How and how can this be implemented?What I need to do in the end.That man understands how this can be realized.He wrote the request or its general principle and explained how and what works.And already in the communication I will give a little more detailed data: id managers, examples of id, which are coming and all the details that will interest you.Maybe someone has already realized this, or knows how, or can do it.I would be very grateful.

Proposals 4 Discussions 2

Andrii Serbin

1 0

Projects -
Rating -
Rating 91

Budget: 500 UAH Deadline: 1 day

The good! I have been working with BD for 19+ years. He also used triggers and HP. Trigger is a good thing, but it is not desirable to use. Better than HP! I wait for details.

Vitalii Valchuk

226 0

Projects 235
Rating -
Rating 2 005

Budget: 500 UAH Deadline: 2 days

Welcome to! It can be done by trigger and procedure. You need to know how you are appointing iddy to managers now.

The list does not show proposals concealed by the client or freelancer with a Plus profile, as well as proposals violating rules

Current freelance projects in the category Databases & SQL

Updating Joomla version

Content Management Systems 15 proposals 13:38

16 USD
Senior AI Systems Architect (Project Lead) Needed to Complete an Existing Unfinished Global Service

Gaming Apps 18 proposals 3 August

Not specified
Development of the CRM module "Requests" in custom 1C (bus center)

Client Management & CRM 20 proposals 31 July

Not specified
Support for Samotur and its servers

17 proposals 27 July

22 USD
Cleaning the client database in SIMLA CRM: phones, duplicates, cities

Client Management & CRM 42 proposals 27 July

179 USD

Artyom Tselousov
Ukraine

Projects 2
Rating -
Rating 73

Andrii Serbin

Vitalii Valchuk

Proposals are currently absent

Current freelance projects in the category Databases & SQL

Updating Joomla version

Senior AI Systems Architect (Project Lead) Needed to Complete an Existing Unfinished Global Service

Development of the CRM module "Requests" in custom 1C (bus center)

Support for Samotur and its servers

Cleaning the client database in SIMLA CRM: phones, duplicates, cities