Activity overview
Latest activity by Bryan H
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.
SQL Search crashes SSMS
When trying to load a database, SSMS freezes and has to be shut down. Tool will load with no database connections in the object viewer, but once one is added, if Search is open management studio fr...
UPDATETEXT Function Not Recognised
SQL Prompt is not recognizing the SQL Server's UPDATETEXT function. The formatting results drop the table name out of the correct syntax and then return a Error Inserting Semicolons message. Exampl...
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...