-- =========================================
-- Create table template
-- =========================================

IF OBJECT_ID('dbo.virticalTable', 'U') IS NOT NULL
  DROP TABLE dbo.virticalTable
GO

CREATE TABLE dbo.virticalTable
(
	ManagerName varchar(255) NOT NULL, 
	ManagerEmail varchar(255) NULL, 
	Review varchar(255) NULL,
	EmployeeName varchar(255), 
)
GO
-- =========================================
-- Insert Sample Data
-- =========================================
INSERT INTO dbo.virticalTable (ManagerName, ManagerEmail, Review, EmployeeName)
VALUES('Jack Wilson', 'jwilson@comp.com', '2009 Review', 'John Sterrett')

INSERT INTO dbo.virticalTable (ManagerName, ManagerEmail, Review, EmployeeName)
VALUES('Jack Wilson', 'jwilson@comp.com', '2009 Review', 'Bo Smith')

INSERT INTO dbo.virticalTable (ManagerName, ManagerEmail, Review, EmployeeName)
VALUES('Hank Reed', 'hreed@comp.com', '2008 Review', 'John Sterrett')

INSERT INTO dbo.virticalTable (ManagerName, ManagerEmail, Review, EmployeeName)
VALUES('Jack Wilson', 'jwilson@comp.com', '2008 Review', 'John Sterrett')