Comments
Sort by recent activity
Anu Deshpande wrote:
Thanks for your post.
I was trying to replicate the issue with reference to the query you have posted above.
I found some issues with the alias you used dbo.Audit_Suppliers cas and the alias in Join condition as.StagingID do not match.
Could you kindly elaborate more on this issue along with the query?
Sorry, changed a table name and thus the alias for the post. Basically, for any update query that invloves an alias, SQL Prompt is not providing suggestions. Another sample is provided below. Again, if I type the alias and the period after it, i would expect suggested columns to come up. nothing happens. This worked in version 3.x, so not sure if is a setting or a bug. My setting are pretty much default.
UPDATE mi
SET mi.input_item_records = ii.records,
FROM #mi mi
JOIN ( SELECT mid ,
COUNT(*) AS records
FROM #ii
GROUP BY mid
) ii ON mi.MID = ii.MID / comments
Anu Deshpande wrote:
Thanks for your post.
I was trying to replicate the issue with reference to the query you have posted above.
I found some issues with the alias you used dbo.Audit_Suppliers c...
The repair option fixed it, thanks.
SQL Prompt v3.9.3.303 is the version that is installed.
SSMS (2008) version 10.0.1600.22
Yes, there was another version3 installed, not sure which. This is a new laptop, so it would have been the latest available for download. The version above was the one released to help with VPN issues.
No other add-ins are installed.
Version 4 did remove itself. I had to remove the menu option from SSMS though.
I may try version 4 (EAP) again if an update is released that fixes some of the issues with syntax error checking and supports linked servers; otherwise I’ll probably wait for release. Lack of linked server support is the one thing I can’t live without.
Thanks again for the support,
Shawn. / comments
The repair option fixed it, thanks.
SQL Prompt v3.9.3.303 is the version that is installed.
SSMS (2008) version 10.0.1600.22
Yes, there was another version3 installed, not sure which. This is a ne...
Big Bill in TN wrote:
Try this.
Mouse over the tool bar and right click > Customize
When the Customize dialog box opens drag the SQL Prompt Button off the tool bar and drop it anywhere. It should be gone next time you start.
Has work for me.
Thanks,
That gets rid of version 4, or at least the menu option for it, but does not re-enable version 3. It is still installed but does not show up. I was hoping to avoind re-installing version 3, but may have to try that. / comments
Big Bill in TN wrote:
Try this.
Mouse over the tool bar and right click > Customize
When the Customize dialog box opens drag the SQL Prompt Button off the tool bar and drop it anywhere. It should...
I re-activated it and that fixed it. / comments
I re-activated it and that fixed it.
Same issue here.
Shawn. / comments
Same issue here.
Shawn.