Activity overview
Latest activity by BrienKing
The error has been submitted to Red Gate via the built in reporting tool many many times. / comments
The error has been submitted to Red Gate via the built in reporting tool many many times.
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?
Expand * doesn't pickup all the columns from a Temp Table
If you have something like this:SELECT [a].Field1, [a].Field2, [b].AnotherField1, [b].AnotherField2INTO #TempTableFROM TableA LEFT OUT...
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
SQL Prompt is not formatting IF statement correctly
The following SQL is not formatted correct.IF @CalculateHeld = 'Yes' BEGINSELECT * FROM [#HeldFunds] WHERE [HeldAmount] > 0DROP TABLE [#HeldFunds]END ELSE BEGINSELECT * FROM [#HeldFunds2] WHERE [...
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 ...
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...