Comments
Sort by recent activity
Done. Another bug with GROUP BY suggestions. When auto-completing non aggregate columns it did not include "s.dir" : SELECT ProductId ,
COUNT(*) * s.dir AS Qty ,
NULL AS LocationId
FROM dbo.SalesOrder_Product
CROSS APPLY ( SELECT [dbo].[fn_SalesOrderProductQtyChangeSignUnit](@PreviousStatusCode,
@OrderStatusCode) AS dir
) s
WHERE SalesOrderId = @SalesOrderId
AND s.dir IS NOT NULL
GROUP BY ProductId
(120,1): SQL72014: .Net SqlClient Data Provider: Msg 8120, Level 16, State 1, Procedure p_UpdateSalesOrderStatus, Line 28 Column 's.dir' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
David Priddle wrote:
Hi sdks,
If you could put this and any other formatting suggestions you have in our formatting survey, that would be great.
We're working on upgrading the formatter so that it is more powerful and flexible, so having your suggestions would help a lot.
Best regards,
David
/ comments
Done. Another bug with GROUP BY suggestions. When auto-completing non aggregate columns it did not include "s.dir" :SELECT ProductId ,
COUNT(*) * s.dir AS Qty ,
...
Another bug. SHIFT+F5 does not work then there are syntax errors in the window. For example:
SELECT 1
SELECT * FROM
If I just highlight "SELECT 1" I can execute it. However when the cursor is somewhere between "SELECT 1" statement and hit SHIFT+F5 it gives following error: ---------------------------
SQL Prompt - Execute current statement
---------------------------
SQL Prompt was unable to complete this operation.
Problem areas have been highlighted.
---------------------------
OK
---------------------------
/ comments
Another bug. SHIFT+F5 does not work then there are syntax errors in the window. For example:
SELECT 1
SELECT * FROM
If I just highlight "SELECT 1" I can execute it. However when the cursor is som...
Hi,
bad formatting (FOR XML PATH): SELECT @MissingProducts = STUFF(
(SELECT N', '
+ CAST(Id AS VARCHAR(30))
FROM @ProductsWithPrices p
WHERE NOT EXISTS ( SELECT
*
FROM
dbo.Product pp
WHERE
pp.Article = p.Id )
FOR XML PATH('') ,
TYPE).value('text()[1]',
'nvarchar(max)'), 1,
2, N'');
/ comments
Hi,
bad formatting (FOR XML PATH):SELECT @MissingProducts = STUFF(
(SELECT N', '
+ CAST(Id AS VARCHAR(30))
...
It's a bit different. In the uservoice it is stated "after the rest of my code is formatted". In this case UNION ALL section is wrongly formatted. It might be related. / comments
It's a bit different. In the uservoice it is stated "after the rest of my code is formatted". In this case UNION ALL section is wrongly formatted. It might be related.
There is no point to email. It is the same line repeated a lot of times:
2015-07-22 07:46 xxx.xxx.xxx.xxx Login failed for user 'DOMAINUSER'. Reason: Could not find a login matching the name provided. [CLIENT: xxx.xxx.xxx.xxx]
2015-07-22 06:33 xxx.xxx.xxx.xxx Login failed for user 'DOMAINUSER'. Reason: Could not find a login matching the name provided. [CLIENT: xxx.xxx.xxx.xxx]
2015-07-22 05:51 xxx.xxx.xxx.xxx Login failed for user 'DOMAINUSER'. Reason: Could not find a login matching the name provided. [CLIENT: xxx.xxx.xxx.xxx]
2015-07-22 05:25 xxx.xxx.xxx.xxx Login failed for user 'DOMAINUSER'. Reason: Could not find a login matching the name provided. [CLIENT: xxx.xxx.xxx.xxx]
Do not look to time. Mainly it differs milliseconds and in my case it generates about 30 records in 1 second.
And the query causing that (most probably) is:
SELECT
SCHEMA_NAME(s.schema_id) AS [Schema],
s.name AS [Name],
s.object_id AS [ID],
N'' AS [BaseDatabase],
N'' AS [BaseObject],
N'' AS [BaseSchema],
N'' AS [BaseServer],
CASE OBJECTPROPERTYEX(s.object_id,'BaseType')
WHEN N'U' THEN 1
WHEN N'V' THEN 2
WHEN N'P' THEN 3
WHEN N'FN' THEN 4
WHEN N'TF' THEN 5
WHEN N'IF' THEN 6
WHEN N'X' THEN 7
WHEN N'RF' THEN 8
WHEN N'PC' THEN 9
WHEN N'FS' THEN 10
WHEN N'FT' THEN 11
WHEN N'AF' THEN 12 ELSE 0 END
AS [BaseType],
s.base_object_name AS [BaseObjectName]
FROM
sys.synonyms AS s
ORDER BY
[Schema] ASC,[Name] ASC
so, everytime I am using synonym intellisense generates a lot of errors. I am not talking about the situation when I am trying to access object I do not have access to, it is just scanning all synonyms and for some of them I do not have permissions. / comments
There is no point to email. It is the same line repeated a lot of times:
2015-07-22 07:46 xxx.xxx.xxx.xxx Login failed for user 'DOMAINUSER'. Reason: Could not find a login matching the name prov...
Hi,
if "Load suggestions for synonyms/Load referenced databases" are enabled and user does not have permissions for some underlied objects then it is flooding error messages to the log for every synonym that user does not have permissions for. / comments
Hi,
if "Load suggestions for synonyms/Load referenced databases" are enabled and user does not have permissions for some underlied objects then it is flooding error messages to the log for every sy...
Tab coloring is not working on SSDT. Is it a bug or VS does not support such features? / comments
Tab coloring is not working on SSDT. Is it a bug or VS does not support such features?
Hi Aaron. Semicolon before SEND is exactly what I meant.
Aaron Law wrote:
Hi sdks,
I think this is the behavior we'd expect to see here. We don't place semicolons after the BEGIN keyword as semicolons are meant for terminating statements so we felt it was a bit strange to terminate a BEGIN…END block at the BEGIN. This is also the style Microsoft use in their examples e.g the example here.
While SEND ON CONVERSATION does require the previous statement to be terminated with a semicolon (which we would insert for you) I don't think it requires one after the BEGIN?
Thanks,
Aaron.
/ comments
Hi Aaron. Semicolon before SEND is exactly what I meant.
Aaron Law wrote:
Hi sdks,
I think this is the behavior we'd expect to see here. We don't place semicolons after the BEGIN keyword as semic...
another bug. Automatic semicolon insert does not insert it before SEND ON CONVERSATION. Example: IF ( 1 = 1 )
BEGIN
SEND ON CONVERSATION @conversation_handle MESSAGE TYPE @ResultMessageTypeName ('test');
END;
Expected result:
IF ( 1 = 1 )
BEGIN;
SEND ON CONVERSATION @conversation_handle MESSAGE TYPE @ResultMessageTypeName ('test');
END;
/ comments
another bug. Automatic semicolon insert does not insert it before SEND ON CONVERSATION. Example:IF ( 1 = 1 )
BEGIN
SEND ON CONVERSATION @conversation_han...
Small bug in formatting:
Open multistatement query that does not fit to 1 screen. Go to the top query and select it from the bottom to the top. Press format query. The selected query jumps to the top of the screen. I think that the query is supposed to stay on the same window position. / comments
Small bug in formatting:
Open multistatement query that does not fit to 1 screen. Go to the top query and select it from the bottom to the top. Press format query. The selected query jumps to the t...