Example Stored Procedure: SELECT

/*************************************************************************************/
PRINT 'RGSP_RGSP_ReadRGConversation';
/*************************************************************************************/
GO
IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_NAME = N'CreateRGConversation' AND ROUTINE_TYPE = N'PROCEDURE' AND ROUTINE_SCHEMA = N'dbo')
    DROP PROCEDURE dbo.RGSP_ReadRGConversation
GO
CREATE PROCEDURE dbo.RGSP_ReadRGConversation (
        @EmployeeID int
) AS
/*
    Select basic employee data by EmployeeID.
*/
BEGIN
    SET NOCOUNT ON

    SELECT
        ConversationID,
        UserID,
        Description,
        Active
        DateLastUpdated
    FROM dbo.RGConversation
    WHERE ConversationID = @ConversationID

    RETURN(0)
END
GO

Comments:

If the only thing a stored procedure does is a simple SELECT, no error checking is required.  Just write the SELECT with a RETURN(0) at the end.