yeshk Posted November 15, 2009 Share Posted November 15, 2009 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.