-- bisp_Employees_SelectByPrimaryKey generated on 11/28/2005 by Blue Ink

-- Do not modify this code as Blue Ink will delete and recreate this procedure on next generation

ALTER PROCEDURE dbo.bisp_Employees_SelectByPrimaryKey

      @EmployeeID Int

AS

SELECT

      [Employees].[Address] AS [Address],

      [Employees].[BirthDate] AS [BirthDate],

      [Employees].[City] AS [City],

      [Employees].[Country] AS [Country],

      [Employees].[EmployeeID] AS [EmployeeID],

      [Employees].[Extension] AS [Extension],

      [Employees].[FirstName] AS [FirstName],

      [Employees].[HireDate] AS [HireDate],

      [Employees].[HomePhone] AS [HomePhone],

      [Employees].[LastName] AS [LastName],

      [Employees].[Notes] AS [Notes],

      [Employees].[Photo] AS [Photo],

      [Employees].[PhotoPath] AS [PhotoPath],

      [Employees].[PostalCode] AS [PostalCode],

      [Employees].[Region] AS [Region],

      [Employees].[ReportsTo] AS [ReportsTo],

      [Employees].[Title] AS [Title],

      [Employees].[TitleOfCourtesy] AS [TitleOfCourtesy]

FROM [Employees]

WHERE

      [Employees].[EmployeeID] = @EmployeeID