March 19, 2019 at 7:12 am
Hi all,
I am currently working on a project where I need to allocate meetings to employees (randomly generated, E0,E1,E2,E3,E4,E5, F0, F1, F2) but to keep the daily hours to a maximum of 5 hours
I have the following table:
"MeetingType" "Meetingdate" "MeetingTime (duration in minutes)" "rnd(0 to 6 generated randomly)" "Dept" "Employee (Concatenate rnd&Dept)"
Any help would be greatly appreciated
Thank you
March 20, 2019 at 6:23 am
Please take the time to provide consumable test data, which will include a CREATE TABLE statement for the table involved, and then some test data as INSERT statements (or just one with a VALUES clause). Then provide the expected results, based on the sample data. We have to guess about data types, and that often matters one heck of a lot, as to the nature of the solution. It's much easier to get help when you do that. Trying to help someone when you really don't have enough information isn't just challenging ... it's often impossible and/or impractical.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
March 20, 2019 at 2:29 pm
Seriously looks like a homework problem.
March 21, 2019 at 8:55 am
This was removed by the editor as SPAM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply