Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
mukejee
Starting Member
5 Posts |
Posted - 2014-02-19 : 04:51:06
|
Hi, I am having the following scenario.shift master tableRole Facility Starttime Duration Minimum Staff count 1 A 10AM 5hrs 32 A 10AM 3hrs 2Employee detail tableEmpID Role Facility Starttime Endtime duration1 1 A 10AM 12PM 2hrs2 1 A 10AM 10:15AM 0.25hrs3 1 A 11AM 1PM 2hrsI want to compare the data from the 2nd table against 2nd table that for a "Role" and "Facility" the minimum staff criteria is met or not?little more explaination.From 2nd table we can see,between10-12 crieria not met beacause the emp count is 1 which is not equal to 3 mentioned above.How to handle this scenario?Thanks Mus |
|
|
|
|