VALUES ('1104', 'C', 'A', 'Test', 'User4', 'tuser4', 'Legal', 'Lola Jacobson', '1999-07-28') 15. At the top, Execute. This will take a moment and you should see four lines that say (1 row(s) affected) in the lower part of the center pane. 16. At the top, click New Query. SQL Server Management Studio will populate the center with a blank white screen. There will be a blinking cursor at the top of this white center pane. 17. Copy the following code into the center pane. USE [HR] GO /****** Object: View [dbo].[Active_Employees] Script Date: 02/02/2011 08:21:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[Active_Employees]AS SELECT EmployeeNumber, FirstName, LastName, UserID, EmployeeType, EmploymentStatus, StartDate, EndDate, Manager, Department, EmployeeNumber AS Expr1,FirstName AS Expr2, LastName AS Expr3, UserID AS Expr4, Department AS Expr5, Manager AS Expr6, EndDate AS StartDate AS Expr8,EmploymentStatus AS Expr9, EmployeeType AS Expr10 FROM dbo.Employees WHERE(EndDate <= DATEADD(day, 0, GETDATE())) AND (EndDate > DATEADD(day, - 45, GETDATE())) OR (EndDate IS NULL) GO 18. At the top, Execute. This will take a moment and you should see Command(s) completed successfully in the lower part of the center pane. 19. Close SQL Server Management Studio. 20. Log off APP1.
VALUES ('1104', 'C', 'A', 'Test', 'User4', 'tuser4', 'Legal', 'Lola Jacobson', '1999-07-28') 15. At the top, Execute. This will take a moment and you should see four lines that say (1 row(s) affected) in the lower part of the center pane. 16. At the top, click New Query. SQL Server Management Studio will populate the center with a blank white screen. There will be a blinking cursor at the top of this white center pane. 17. Copy the following code into the center pane. USE [HR] GO /****** Object: View [dbo].[Active_Employees] Script Date: 02/02/2011 08:21:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[Active_Employees]AS SELECT EmployeeNumber, FirstName, LastName, UserID, EmployeeType, EmploymentStatus, StartDate, EndDate, Manager, Department, EmployeeNumber AS Expr1,FirstName AS Expr2, LastName AS Expr3, UserID AS Expr4, Department AS Expr5, Manager AS Expr6, EndDate AS StartDate AS Expr8,EmploymentStatus AS Expr9, EmployeeType AS Expr10 FROM dbo.Employees WHERE(EndDate <= DATEADD(day, 0, GETDATE())) AND (EndDate > DATEADD(day, - 45, GETDATE())) OR (EndDate IS NULL) GO 18. At the top, Execute. This will take a moment and you should see Command(s) completed successfully in the lower part of the center pane. 19. Close SQL Server Management Studio. 20. Log off APP1.
TestLabGuide_ManagedUserID.docx