Activity overview
Latest activity by GregDodd
I'm having the same problem and it's driving me nuts. Also on version 10.0.4.12779. / comments
I'm having the same problem and it's driving me nuts. Also on version 10.0.4.12779.
Not sure if this is the same problem, but I did the upgrade to 9.5 before installing SSMS 18, I now have no way of installing it into SSMS 18 as the installer detects that it's already installed. I guess I have to uninstall first? / comments
Not sure if this is the same problem, but I did the upgrade to 9.5 before installing SSMS 18, I now have no way of installing it into SSMS 18 as the installer detects that it's already installed. I...
I thought I'd logged it before but I couldn't find it. I still don't like the work around - I don't need an alias for the column list in the select, or the join conditions, or the group by, but I need to alias both for the order by. / comments
I thought I'd logged it before but I couldn't find it. I still don't like the work around - I don't need an alias for the column list in the select, or the join conditions, or the group by, but I n...
SQL Prompt changes alias in order by clause
I'm not sure if this is the right place to report a bug, but I'm seeing SQL Prompt (version 9.4.14.8687) change the table alias in an order by clause (doesn't affect the column list in the select, ...
I was on 9.2.6.6145, but it's still happening after updating to 9.2.8.6358. I can run the following on a new database (or tempdb): CREATE TABLE Product ( ProductItemID INT PRIMARY KEY, ProductName VARCHAR(50), ProductCode VARCHAR(10), MainProductID INT ) Then write the following script: SELECT Product.ProductCode
,MainProduct.ProductCode
FROM Product
INNER JOIN Product AS MainProduct
ON MainProduct.ProductItemID = Product.MainProductID
ORDER BY Product.ProductName Then when I format it I get MainProduct.ProductName in the order by clause
/ comments
I was on 9.2.6.6145, but it's still happening after updating to 9.2.8.6358. I can run the following on a new database (or tempdb):CREATE TABLE Product( ProductItemID INT PRIMARY KEY, ProductName VA...
SQL Prompt Wrongly Alias'ing order by clause
When you have a table joined to itself and you alias the 2nd table but not the first, SQL Prompt formats the order by clause to use the Aliased tablename, overwriting the chosen filename.e.g.:SELEC...
Style sent via email / comments
Style sent via email
I'm get errors on formatting delete and update statements. E.g. for this script:
CREATE TABLE #TempTable (col1 INT)
DELETE Stock
FROM #TempTable
INNER JOIN Stock
ON Stock.stockid= col1
WHERE Stock.BaseQuantity = 10
I get a message: [image]
When I look at the error, I see this: [image] / comments
I'm get errors on formatting delete and update statements. E.g. for this script:
CREATE TABLE #TempTable (col1 INT)
DELETE Stock
FROM #TempTable
INNER JOIN Stock
ON Stock.stockid= col1
WHERE Stoc...
Looks like it's fixed in 8.2.1.2603. Thanks! / comments
Looks like it's fixed in 8.2.1.2603. Thanks!
Hi @James R - just wondering how you were going with this? Any updates on when a fix might be out? / comments
Hi @James R - just wondering how you were going with this? Any updates on when a fix might be out?