CREATE TABLE #X1
(vcEmployeeUniqueID VARCHAR(20),
vcLastName VARCHAR(20),
vcFirstName VARCHAR(20),
vcSchoolName VARCHAR(50),
iSchoolYearCode INT)


INSERT INTO #X1 VALUES ('001210214','Miller','Helen','NORWALK HIGH SCHOOL',2009)
INSERT INTO #X1 VALUES ('001210214','Miller','Helen','STAMFORD HIGH SCHOOL',2010)
INSERT INTO #X1 VALUES ('001210214','Miller','Helen','NORWALK HIGH SCHOOL',2011)
INSERT INTO #X1 VALUES ('003215847','Carolyn','June','NORWALK HIGH SCHOOL',2010)
INSERT INTO #X1 VALUES ('003215847','Carolyn','June','WATERBURY HIGH SCHOOL',2011)
INSERT INTO #X1 VALUES ('002149013','Steve','Ulman','STAMFORD HIGH SCHOOL',2011)

vcEmployeeUniqueID	vcLastName	vcFirstName	SY2009			SY2010			SY2011	
001210214		Miller		Helen		NORWALK HIGH SCHOOL	STAMFORD HIGH SCHOOL	NORWALK HIGH SCHOOL	
003215847		Carolyn		June					NORWALK HIGH SCHOOL	WATERBURY HIGH SCHOOL
002149013		Steve		Ulman								STAMFORD HIGH SCHOOL