USP_DATAFORMTEMPLATE_VIEW_FEPPROCESSESPAGEEXPRESSION

create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_FEPPROCESSESPAGEEXPRESSION
(
    @DATALOADED bit = 0 output,
    @PROCESSEXISTS bit = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

    select 
        @DATALOADED = 1,
        @PROCESSEXISTS =
            case 
                when exists(select FEPPROCESS.ID from dbo.FEPPROCESS inner join dbo.FEPSUBMITPROCESS on FEPPROCESS.ID = FEPSUBMITPROCESS.FEPPROCESSID) then 1
                else 0
            end;

    return 0;