USP_DATAFORMTEMPLATE_EDITLOAD_GIFTAIDREFRESHPREPROCESS

create procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_GIFTAIDREFRESHPREPROCESS
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @NAME nvarchar(100) = null output,
    @RECORDTYPEID uniqueidentifier = null output,
    @IDSETREGISTERID uniqueidentifier = null output
)
as

    set nocount on;

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

    set @DATALOADED = 0
    set @TSLONG = 0

    select
        @RECORDTYPEID = ID
    from
        dbo.RECORDTYPE
    where
        upper(BASETABLENAME) = 'REVENUE';

    select
        @DATALOADED = 1,
        @TSLONG = GIFTAIDREFRESHPROCESS.TSLONG,
        @NAME = GIFTAIDREFRESHPROCESS.NAME,
        @IDSETREGISTERID = GIFTAIDREFRESHPROCESS.IDSETREGISTERID
    from 
        dbo.GIFTAIDREFRESHPROCESS
    where 
        GIFTAIDREFRESHPROCESS.ID = @ID;

    return 0;