USP_DATAFORMTEMPLATE_VIEW_GENERALSALESDEPOSITPROCESS

CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_GENERALSALESDEPOSITPROCESS
(
    @DATALOADED bit = 0 output
    ,@PROCESSID uniqueidentifier = null output
)
as
    set nocount on;

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

    select @DATALOADED = 1
        ,@PROCESSID = SALESDEPOSITPROCESS.ID
    from dbo.SALESDEPOSITPROCESS
  inner join dbo.PDACCOUNTSYSTEM on PDACCOUNTSYSTEM.ID = SALESDEPOSITPROCESS.PDACCOUNTSYSTEMID
    where ISRECONCILEDPROCESS = 1
  and (SALESDEPOSITPROCESS.PDACCOUNTSYSTEMID is null or PDACCOUNTSYSTEM.ISDEFAULT = 1)

    return 0;