Details

    • Sprint:
      CFAMX 2020R3 SA Sprint 4, CFAMX 2020R3 SA Sprint 5

      Description

      – ************* #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)

        Attachments

        1. screenshot-1.png
          75 kB
          Caner Saritac
        2. screenshot-2.png
          70 kB
          Caner Saritac

          Activity

            People

            • Assignee:
              caner.saritac Caner Saritac
              Reporter:
              caner.saritac Caner Saritac
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 14h
                14h
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 3h 1m Time Not Required
                3h 1m

                  PagerDuty

                  Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.