-
Type: Dev Task
-
Status: Done (View Workflow)
-
Resolution: Done
-
Fix Version/s: CFA 2021R1
-
Labels:None
-
Sprint:CFAMX 2020R3 SA Sprint 4, CFAMX 2020R3 SA Sprint 5
– ************* #14 fn_ListStockValues_OBSOLETE_Partitioned
/*
WITHOUT BusinessDay against to TbTransactionitem
query time: ~ 5 seconds
WITH BusinessDay against to tbTransactionItem_NEW
query time: ~ 10 seconds
*/
DECLARE @EntityID bigint = 902
DECLARE @MyStartDate datetime = '2019-10-10'
select * from fn_ListStockValues_OBSOLETE_Partitioned (@EntityID, @MyStartDate)
select * from fn_ListStockValues_OBSOLETE (@EntityID, @MyStartDate)