usp_selectmanageremployees.sql

Beginning VB.NET DatabasesAll_Code.rar

CREATE PROCEDURE usp_SelectManagerEmployees
(
   @ManagerID   UNIQUEIDENTIFIER
)
AS
SELECT UserID, FirstName + ' ' + LastName AS EmployeeName
FROM Users
Where ManagerID = @ManagerID
ORDER BY EmployeeName