# "ListManagers" Stored Procedure

Description:

This stored procedure returns user information from the Users table where the user is in a role of either 1 (Administrator) or 2 (Project Manager).

Definition:

    	CREATE    PROCEDURE TT_ListManagers

    	AS

    	SELECT
    		UserID, UserName, RoleID

    	FROM
    		TT_Users
    	Where
    		RoleID = 2
    	OR
    		RoleID = 1

Database Tables Used:

The primary key in the Users table is the UserID identity field.