Comments
Sort by recent activity
Didn't help. After being a customer for 19+ years, I'm done. Time to go to a competitor. / comments
Didn't help. After being a customer for 19+ years, I'm done. Time to go to a competitor.
Except I am not moving to 15.x because I'm not going to the "Subscription" model. What do we do if we are on 14.x? / comments
Except I am not moving to 15.x because I'm not going to the "Subscription" model. What do we do if we are on 14.x?
I am on the latest (9.2.9.6459) and it wasn't formatting correctly on the previous version. In the previous version it was basically the opposite problem where everything was spread way out. In this version everything is all left justified. This is what is looks like after being formatted: IF @CalculateHeld = 'Yes' BEGIN SELECT * FROM [#HeldFunds] WHERE [HeldAmount] > 0 DROP TABLE [#HeldFunds] END ELSE BEGIN SELECT * FROM [#HeldFunds2] WHERE [HeldAmount] > 0 DROP TABLE [#HeldFunds2] END
What it should look like is this: IF @CalculateHeld = 'Yes' BEGIN
...SELECT * FROM [#HeldFunds] WHERE [HeldAmount] > 0
...DROP TABLE [#HeldFunds]
END ELSE BEGIN
...SELECT * FROM [#HeldFunds2] WHERE [HeldAmount] > 0
...DROP TABLE [#HeldFunds2]
END
/ comments
I am on the latest (9.2.9.6459) and it wasn't formatting correctly on the previous version. In the previous version it was basically the opposite problem where everything was spread way out.In thi...
Correct / comments
Correct
ok, it may not necessarily be a bug, but less intuitive than what I was expecting. Do something simple like: SELECT * FROM Customers This will show squiggly lines under the * and "Customers". The light bulb is position sensitive which makes it appear to hide the other issue. / comments
ok, it may not necessarily be a bug, but less intuitive than what I was expecting.Do something simple like:SELECT * FROM CustomersThis will show squiggly lines under the * and "Customers". The lig...
I am on the latest. My clarification stated that it's not a bug, just not as intuitive as I was expecting. You have to put the cursor on the issue for the Bulb to show you that specific issue. It would be nice if the bulb also had a list of other issues (if more than one for that line). / comments
I am on the latest. My clarification stated that it's not a bug, just not as intuitive as I was expecting. You have to put the cursor on the issue for the Bulb to show you that specific issue. I...
The error is "A comparison or expression is using NULL without explicit provision for a NULL value.", yet in the example posted above (not sure why it has strike out in it), the CASE statement has an explicit check for NULL with WHEN NULL THEN... The case can also have an ELSE condition that should catch everything else, including a NULL value. So this error should only show up if none of the WHEN conditions don't explicitly check for NULL and there is no ELSE on the CASE. / comments
The error is "A comparison or expression is using NULL without explicit provision for a NULL value.", yet in the example posted above (not sure why it has strike out in it), the CASE statement has ...
Add me to the list that want it back. It's more useful than the open dialog because the filename doesn't necessarily reflect what is actually being compared.
In fact if you had an option to save it under what ever filename you wanted, it wouldn't bother me at all. If I can browse the projects I really don't care what it's called. / comments
Add me to the list that want it back. It's more useful than the open dialog because the filename doesn't necessarily reflect what is actually being compared.
In fact if you had an option to save i...
SQL Prompt Version 3.9.0.43.
Microsoft SQL Server Management Studio 9.00.3042.00
Operating System 6.0.6001
Maybe it's a bug related to Vista 64bit. / comments
SQL Prompt Version 3.9.0.43.
Microsoft SQL Server Management Studio 9.00.3042.00
Operating System 6.0.6001
Maybe it's a bug related to Vista 64bit.
tanya wrote:
Hi Brien,
This is not a VISTA bug as I did try this on a VISTA 64 machine and it does work fine. Do you have any other external SQL tools installed on your system?
Thanks,
Tanya
Project Manager
Red Gate Software Ltd
Sorry it took so long to get back to you. Been swamped. I misspoke about the enviornment before. It's not in MS SQL Server Management Studio , it's inside Visual Stuido 2008 (SP1).
When editing a stored procedure, it brings up the Canidate List and I can not get rid of it using the ESC key. / comments
tanya wrote:
Hi Brien,
This is not a VISTA bug as I did try this on a VISTA 64 machine and it does work fine. Do you have any other external SQL tools installed on your system?
Thanks,
Tanya
Pro...