USP_DATAFORMTEMPLATE_VIEW_BBIS_TRANSBATCHUPGRADEINFO

CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_BBIS_TRANSBATCHUPGRADEINFO (
    @DATALOADED bit = 0 output,
    @SHOWDONATIONANDSIGNUPUPGRADEINFO bit = null output
) as begin
    set nocount on;

    -- be sure to set this, in case the select returns no rows
    set @DATALOADED = 0;

    select top 1
        @DATALOADED = 1,
        @SHOWDONATIONANDSIGNUPUPGRADEINFO = TBUI.SHOWDONATIONANDSIGNUPUPGRADEINFO
    from
        dbo.BBIS_TRANSBATCHUPGRADEINFO TBUI;

    return 0;
end