Hi Lads
Have been getting an error on the AdventureWorks DB, I would be eternally grateful for some help, any help at all. thank you!
/*
Q13
Schema(s) involved: [HumanResources]
Question: Remove all shifts from [HumanResources].Shift except for Day,Evening,Night
if they exist.
*/---------------------------------------------------------------------------------------------------
IF EXISTS(SELECT Name FROM HumanResources.Shift WHERE Name in('Day','Evening','Night'))
DELETE from HumanResources.Shift WHERE Name in('Day','Evening','Night')
----
I get the below error message:
The DELETE statement conflicted with the REFERENCE constraint "FK_EmployeeDepartmentHistory_Shift_ShiftID". The conflict occurred in database "AdventureWorks", table "HumanResources.EmployeeDepartmentHistory", column 'ShiftID'.
The statement has been terminated.