[dba-SQLServer] code not working

Thanks Nancy -- I appreciate that. 

Susan H. 

I ran it in SQL2005 (not express) and got the same error:
Msg 207, Level 16, State 1, Line 32
Invalid column name 'DepartmentID'.
Msg 207, Level 16, State 1, Line 50
Invalid column name 'DepartmentID'


Would someone please run this in Express and see if you get the same error I
do? The Tech Editor says it works for him, but I'm getting an error that
there's no DepartmentID column in the Employee table. I checked, and it
isn't there. I don't know whether the TE's goofy or I'm just doing something
wrong.