-- =============================================
-- TaskList_GetStatusTypeByID
-- =============================================
-- creating the store procedure
IF EXISTS (SELECT name 
	   FROM   sysobjects 
	   WHERE  name = N'TaskList_GetStatusTypeByID' 
	   AND 	  type = 'P')
    DROP PROCEDURE TaskList_GetStatusTypeByID
GO

CREATE PROCEDURE TaskList_GetStatusTypeByID
	@StatusID BigInt
AS
SELECT ID AS StatusID, StatusDescription AS Description, StatusFontFlags AS FontFlags
FROM TaskListStatus WHERE ID = @StatusID