Summary Table

Categories Total Count
PII 0
URL 0
DNS 0
EKL 0
IP 0
PORT 0
VsID 0
CF 0
AI 0
VPD 0
PL 0
Other 0

File Content

?-- =============================================
-- Description: Returns table of BatchLog records awaiting loading for the load status provided
--
-- Maintenance Log:
--
-- Update By Update Date Description
-- ----------- --------- ----------------------------
-- =============================================
CREATE FUNCTION [dbo].[ufnGetBatchLogsForTableProcessing]
(
@loadStatus varchar(50),
@tableName varchar(200)
)
RETURNS @resultTable table
( BatchLogID bigint,
TableName varchar(50),
BatchDate datetime2(7)
)
AS
BEGIN
INSERT INTO @resultTable (BatchLogID, TableName, BatchDate)
SELECT DISTINCT BatchLogID, TableName, BatchDate
FROM BatchLogs
WHERE (LoadStatus = @loadStatus OR @loadStatus IS NULL)
AND (TableName = @tableName OR @tableName IS NULL)
ORDER BY BatchDate;

RETURN;
END
GO