Skip to content
Advertisement

Tag: azure-sql-data-warehouse

Azure SQL Does not allow login for Created Clients

I created several users for Azure SQL using the free acccount in a database in Azure Data Studio following the recommended procedure: add client ip addresses to firewall create login on the master database create users add appropriate roles that at least encompass db_accessadmin Despite this, my attempts to login with Azure Data Studio and SSMS continue to fail unless

Merge groups of consecutive rows in T-SQL and sum values from each group

Updated 10/08/2019: @Gordon Linoff: I have tried to applied your solution but I realized that is not working as expected. I have added an example with expected result with comments here (https://dbfiddle.uk/?rdbms=sqlserver_2017&fiddle=1b486476d6aeab25997f25e66ee455e9) and I would be grateful if you could help me. — I have a table of transactions with schema: Here are some row examples: What I want is

Advertisement