USP_BBFR8A_DATAMART_GETDELETEDIDS
Used by the BBFR8A OLAP ETL. Returns a list of record ids that have been deleted between the supplied dates for the given table.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @AUDITTABLENAME | nvarchar(128) | IN | |
| @DATAWINDOWOPEN | datetime | IN | |
| @DATAWINDOWCLOSE | datetime | IN |
Definition
Copy
create procedure dbo.USP_BBFR8A_DATAMART_GETDELETEDIDS
@AUDITTABLENAME nvarchar(128),
@DATAWINDOWOPEN datetime,
@DATAWINDOWCLOSE datetime
as
declare @spresult int;
exec @spresult = dbo.USP_OLAP_ETL_DATAMART_GETDELETEDIDS @AUDITTABLENAME, @DATAWINDOWOPEN, @DATAWINDOWCLOSE;
return @spresult;