USP_DATALIST_SALESDEPOSITPROCESS

            CREATE procedure dbo.USP_DATALIST_SALESDEPOSITPROCESS
            as
                set nocount on;

                select
                    [SALESDEPOSITPROCESS].[ID],
                    [SALESDEPOSITPROCESS].[NAME],
                    (
                        select count(*)
                        from dbo.[SALESDEPOSITTEMPLATE]
                        where [SALESDEPOSITTEMPLATE].[SALESDEPOSITPROCESSID] = [SALESDEPOSITPROCESS].[ID]
                    ) as [NUMBEROFDEPOSITS],
                    [SALESDEPOSITPROCESS].[DESCRIPTION]
                from dbo.[SALESDEPOSITPROCESS]