I have created a linked server on a SQL Server connecting to an Azure SQL datawarehouse. When I execute a stored procedure of SQL DW via SSMS as below, it is getting executed as expected. But when I try to have that stored procedure executed as a part of trigger definition And when I try to insert a record in…
Tag: azure-sql-data-warehouse
SQL Query doesn’t work in Azure SQL Data Warehouse (Synapse) why not?
I have an SQL query that works in an on-premise SQL Database, but when I try to execute it on an Azure SQL Data Warehouse, I get an error. Does anyone know another way of writing this SQL Query so …
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 l…
How do I do SQL sum across a table diagonally?
I have this table: I want to get this: The idea is to sum up the Col B of Quarter 1 with Col C of Quarter 2… and group by Col A Answer Very strange, but you can use conditional aggregation:
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…