Automated Random Ticket assignment to team members This query loops over the employee database where selected employee except management are assigned tickets from the Task table "CM" weekly This is going to be part of an automation using SSIS package