本文介绍了分组表属性的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

大家好

我有3个表-Employeeskills(Emp_ID,Skill_ID)团队(Team_ID,Emp_ID,Skill_ID,Team_Name,Available),JOBS(Job_ID,Team_ID,Date_Time,位置).现在,我需要从EmployeeSkills表到Teams表对员工进行分组,然后每个团队必须具备清洁窗户,洗碗,地板和浴室清洁等所有技能.这意味着我可以在一个团队中拥有五名员工.但是我的问题是如何将这些EmployeeSkills归为一个团队,依此类推?因为我需要分配每个团队一份工作.我正在使用SQLServer和ASP.net

Hi Everyone

I have 3 tables- Employeeskills(Emp_ID,Skill_ID) Teams(Team_ID,Emp_ID,Skill_ID, Team_Name, Availability), JOBS(Job_ID, Team_ID, Date_Time, Location). now i need to group employees from the EmployeeSkills table to the Teams table, and then each Team must have all the skills like cleaning windows, dish-washing, flooring and bathroom cleaning. meaning i could have five employees under one team. but my problem is how do i group these EmployeeSkills under one team and so on?. because i need to assign each team to a job. im using SQLServer and ASP.net

推荐答案


这篇关于分组表属性的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

10-28 21:26