USP_KPI_REVENUE_COMMUNICATIONPLANGOALAMOUNT

                CREATE procedure dbo.USP_KPI_REVENUE_COMMUNICATIONPLANGOALAMOUNT(
                    @VALUE money output,
                    @COMMUNICATIONPLANID uniqueidentifier
                )
                as
                        set @VALUE = 0;

                        select
                            @VALUE = COMMUNICATIONPLAN.REVENUEGOAL
                        from
                            dbo.COMMUNICATIONPLAN
                        where
                            COMMUNICATIONPLAN.ID = @COMMUNICATIONPLANID