Comments
Sort by recent activity
The issue was resolved by correcting the RGTEMP variable. An incorrect file path user setting was migrated onto a laptop install. / comments
The issue was resolved by correcting the RGTEMP variable. An incorrect file path user setting was migrated onto a laptop install.
Tabs are sometimes added after alias names. Occurrences have been noticed where the tab is added either in front or following the . operator separating the table name from the column name. Occurrences seem to happen on lengthy scripts.
Example fragment:
WHERE t. BusWeek BETWEEN @ReportStart AND @ReportEnd
Example 2 fragment (Issue shows up in both lines 6 and 8 - notice the tab can be prior to or after the . operator:
FROM dbo.PA10702 PA_PO_ReceiptLine
LEFT JOIN dbo.PA01201 PA_Project_MSTR ON PA_PO_ReceiptLine.PAPROJNUMBER = PA_Project_MSTR.PAPROJNUMBER
LEFT JOIN dbo.PA01101 PA_Contract_MSTR ON PA_Project_MSTR.PACONTNUMBER = PA_Contract_MSTR.PACONTNUMBER
INNER JOIN dbo.PA01001 PA_Cost_Category_MSTR ON PA_PO_ReceiptLine.PACOSTCATID = PA_Cost_Category_MSTR.PACOSTCATID
LEFT JOIN dbo.PA01601 PA_ReceiptLine_Billing_Notes
ON PA_PO_ReceiptLine. PAbillnoteidx = PA_ReceiptLine_Billing_Notes.PAbillnoteidx
INNER JOIN DYNAMICS.dbo.MC40200 MC_Currency_SETP
ON PA_PO_ReceiptLine .PAMCCURNCYID = MC_Currency_SETP.CURNCYID;
/ comments
Tabs are sometimes added after alias names. Occurrences have been noticed where the tab is added either in front or following the . operator separating the table name from the column name. Occurren...