USP_WEALTHPOINT_DATAREFRESHNOTIFICATION_DBOBJECTNAME_FROMNAME

Gets the Selection's table for a Data Refresh Notification given the Notification name.

Parameters

Parameter	Parameter Type	Mode	Description
@NAME	nvarchar(100)	IN
@DBOBJECTNAME	nvarchar(150)	INOUT

Definition

Copy



            create procedure dbo.USP_WEALTHPOINT_DATAREFRESHNOTIFICATION_DBOBJECTNAME_FROMNAME(
                @NAME nvarchar(100) = null,
                @DBOBJECTNAME nvarchar(150) = null output
            ) as begin
                set nocount on;

                select
                    @DBOBJECTNAME = WEALTHPOINTDATAREFRESHNOTIFICATION.DBOBJECTNAME
                from
                    dbo.WEALTHPOINTDATAREFRESHNOTIFICATION
                left join dbo.NOTIFICATION on
                    WEALTHPOINTDATAREFRESHNOTIFICATION.NOTIFICATIONID = NOTIFICATION.ID
                where
                    NOTIFICATION.NAME = @NAME

            end