Comments
Sort by recent activity
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...
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...
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...
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?
Looks like it's fixed in 8.2.1.2603. Thanks! / comments
Looks like it's fixed in 8.2.1.2603. Thanks!
Thanks @AlessandroAlpi. I thought I had tried that, but just tried it again and it works. It's a bit of an ugly solution though. Before using SQL Prompt I'd just use 2 tabs instead of 1, it would be nice if I could specify that somewhere. / comments
Thanks @AlessandroAlpi. I thought I had tried that, but just tried it again and it works. It's a bit of an ugly solution though. Before using SQL Prompt I'd just use 2 tabs instead of 1, it would b...