在区域基础上为人员分配问题 [英] Assigning personnel to issues on regional basis

问题描述

亲爱的专家，



1.需要向人员分配问题以便在区域基础上处理。



2.需要在人员中均匀均衡地映射问题，如下所示。



人员

Dear Expert,

1. Need to assign issues to personnel to handle on regional basis.

2. Need to map the issues evenly and equally amongst personnel as folows.

Personnel

idno name region
-------------------------
001 ike central
002 pet central
003 don central

0011 jan north
0012 ivy north
0013 alf north

0015 ama east
0016 ema east
0017 pal east

问题

Issues

ticket_no date region issue name-of-officer-to-be-assigned
--------------------------------------------------------------------------
00000001 14/09/2016 central ------
00000002 14/09/2016 central ------
00000003 14/09/2016 central ------
00000004 14/09/2016 central ------
00000005 14/09/2016 central ------
00000006 14/09/2016 central ------
00000007 14/09/2016 central ------
00000008 14/09/2016 central ------
00000009 14/09/2016 central ------

00000011 14/09/2016 north ------
00000012 14/09/2016 north ------
00000013 14/09/2016 north ------
00000014 14/09/2016 north ------
00000015 14/09/2016 north ------
00000016 14/09/2016 north ------
00000017 14/09/2016 north ------
00000018 14/09/2016 north ------
00000019 14/09/2016 north ------


00000111 14/09/2016 east ------
00000112 14/09/2016 east ------
00000113 14/09/2016 east ------
00000114 14/09/2016 east ------
00000115 14/09/2016 east ------
00000116 14/09/2016 east ------
00000117 14/09/2016 east ------
00000118 14/09/2016 east ------
00000119 14/09/2016 east ------

如何以编程方式为人员分配问题以便解决问题

在发生时均匀分布。


$ s $ b存储过程在ms sql server中



谢谢



我的尝试：



我自己尝试了，我已经检查了互联网上的silimar案例

How do you assign the personnel to the issues programmatically so that the issues
are evenly distributed as and when they occur.

stored procedure in ms sql server

Thanks

What I have tried:

tried it on my own, i have checked the internet for silimar cases

推荐答案

嗯......我建议阅读类似主题：

根据技能向工人公平分配任务的算法 - Stack Overflow [ ^ ]

将任务分配给资源的算法 - Stack Overflow [ ^ ] - 完美的在你的情况下！

工作分配算法 - 堆栈溢出 [ ^ ]



我从来没有见过基于SQL的解决方案，但是这个： T-SQL中的图形和图形算法 [ ^ ]可以帮助您实现自己的。

Well... I'd suggest to read similar threads:
Algorithm for fairly assigning tasks to workers based on skills - Stack Overflow[^]
Algorithm to assign task to resources - Stack Overflow[^] - perfect in your case!
Work Assignment Algorithm - Stack Overflow[^]

I've never seen SQL based solution, but this: Graphs and Graph Algorithms in T-SQL[^] may help you in implementation of your own.

这篇关于在区域基础上为人员分配问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！