[CFAMX-11406] Switch stored procedures to use table variables - HotSchedules JIRA

Details

Type: Feature Request
Status: Closed (View Workflow)
Priority: Major
Resolution: Completed
Affects Version/s: None
Fix Version/s: None
Component/s: None
Labels:

Description

Switch the following stored procedures to use table variables rather than persistent temporary tables:

MXC_Financial_GetCustomerSalesByDateRange
MXC_Financial_GetRefundedOnAccountSalesIds
qryMMSWorkFlowCheck_CustomerSalesStatus

Attachments

Issue Links

is implemented by

CFAMX-11407 Augment/Create Load Tests

Closed

CFAMX-11408 Documentation

Closed

CFAMX-12286 Update MXC_Financial_GetCustomerSalesByDateRange to use Table Variable

Closed

CFAMX-12291 Update MXC_Financial_GetRefundedOnAccountSalesIds to use Table Variable

Closed

CFAMX-12296 Update qryMMSWorkFlowCheck_CustomerSalesStatus to use Table Variable

Closed

Activity

People

Assignee:

Unassigned

Reporter:

Corey Amend (Inactive)

Watchers:

0 Start watching this issue

Dates

Created:

Aug/07/20 1:47 PM

Updated:

Oct/19/20 2:52 PM

Resolved:

Oct/19/20 2:52 PM

PagerDuty

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