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…
Tag: azure-sql-managed-instance
Azure SQL: Group a result based on a sub select statement
I have an issue with a query where I want to accumulate values and then group them PS: This is a simplified example CREATE TABLE [dbo].[OWNER]( [personId] [int] NULL, [ownerId] [int] NULL, …