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
Quiz
12. UPDATE with CTE
Summary

Instruction

Fine. How about UPDATE combined with a CTE?

Exercise

The company would like to know which projects are the most important.

For projects where employees devoted more than 40 hours, add N' (VIP)' at the end of the project’s name.

The name should look like this:

PROJECT_NAME (VIP)

Mind that there is a space between the project name and (VIP).