USP_DATAFORMTEMPLATE_EDITLOAD_RECURRINGGIFTSTATUSREASONCODE

    create procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_RECURRINGGIFTSTATUSREASONCODE
    (
        @ID uniqueidentifier,
        @REASONTYPECODE int = null output,
        @CODE nvarchar(10) = null output,
        @DESCRIPTION nvarchar(50) = null output,
        @DATALOADED bit = 0 output,
        @TSLONG bigint = 0 output
    )
    as

        set nocount on;

        -- be sure to set these, in case the select returns no rows

        set @DATALOADED = 0
        set @TSLONG = 0

        select
            @CODE = CODE,
            @REASONTYPECODE = REASONTYPECODE,
            @DESCRIPTION = DESCRIPTION,
            @DATALOADED = 1,
            @TSLONG = TSLONG
        from dbo.RECURRINGGIFTSTATUSREASONCODE
        where ID = @ID

        return 0;