Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Recursive Queries in MS SQL Server

Introduction
4. The Allocation table
Quiz
Summary

Instruction

Perfect! And finally – the last table.

Exercise

Select all the information from the table Allocation.

At the company we're discussing, each employee (EmployeeId) can work on a single project (ProjectId) on a given date (WorkDate) for a given number of hours (HoursSpent). For instance, employees can work on project 1 on Monday, project 2 on Tuesday, project 1 again on Wednesday, etc.