Færdiggjort

SQL Sored Procedure

Job Description:

We need to create a SQL stored procedure to divide the calls to the user automatically based on the user count and the total calls count.

Example:

If we have 4 users on the table (USERS) and we have 15 calls on the table (calls)

the system will distribute 4 calls for each user.

Total =15 calls/4 users = 4 calls for each user.

⦁ The system will take the first 4 rows from the (calls) table and the first user from the (users) table,

and will assign the calls to this user on the "user worklist" table and will repeat the task till the records end on table “calls”

Færdigheder: Microsoft SQL Server, SQL

Om klienten:
( 1 bedømmelse ) Giza, Poland

Projekt ID: #34274205

Tildelt til:

awais26

Hi, I’m very interested in your job posting. Please consider my application. I have a background in database administration in MS SQL server and have been doing this for 7+ years. I have experience and can work with yo Flere

$20 USD in 7 dage
(3 bedømmelser)
2.8

7 freelancere byder i gennemsnit $37 timen for dette job

DBhut

Hello Sir, I am core SQL Server DBA \DEV with 15+years of experience . I have worked primarily for Banking and Financial Customers across the Globe . I am proficient in all activities of SQL Server Administration and Flere

$20 USD på 1 dag
(10 bedømmelser)
3.9
saiedmousa79

I have 7 years experience I have already read your requirements I've read your description, checked the project and I feel confident to help you. My workflow is very transparent and communication is the base. I'm ready Flere

$30 USD på 1 dag
(0 bedømmelser)
0.0
SeasonedDveloper

Hello, I'm an expert in Sql, and I have done the similar job before. Would you please start the chat?

$20 USD på 1 dag
(0 bedømmelser)
0.0
marinkozorkic

hello! I have a lot of experience with MySql, Sqlite databases. I've built a large MySql database for a web project. I want to build a database. Because I am very interested in building databases and linking table rel Flere

$20 USD på 1 dag
(0 bedømmelser)
0.0
vankadeepthi2395

Worked on stored Procedures for long time and have fair expertise , the task mentioned above can be completed according to the requirement in time

$135 USD in 7 dage
(0 bedømmelser)
0.0