USP_WEALTHPOINT_DATAREFRESHNOTIFICATIONS_EXPIRED

Returns a selection of expired WealthPoint Data Refresh Notifications and associated Selections.

Parameters

Parameter	Parameter Type	Mode	Description
@EXPIREDASOFDATE	datetime	IN

Definition

Copy



            CREATE procedure dbo.USP_WEALTHPOINT_DATAREFRESHNOTIFICATIONS_EXPIRED(
                @EXPIREDASOFDATE datetime
            ) as begin
                set nocount on;

                select
                    WEALTHPOINTDATAREFRESHNOTIFICATION.NOTIFICATIONID,
                    WEALTHPOINTDATAREFRESHNOTIFICATION.IDSETREGISTERID,
                    WEALTHPOINTDATAREFRESHNOTIFICATION.DBOBJECTNAME
                from
                    dbo.WEALTHPOINTDATAREFRESHNOTIFICATION
                left join dbo.NOTIFICATION on
                    WEALTHPOINTDATAREFRESHNOTIFICATION.NOTIFICATIONID = NOTIFICATION.ID
                where
                    NOTIFICATION.VALIDUNTIL <= @EXPIREDASOFDATE
            end