I have the following table: CREATE TABLE [dbo].[PRC_Tutors] ( [ID] [int] NOT NULL, [UserID] [int] NOT NULL, [LivelloZoom] [int] NULL, [PosizioneGIS] [nvarchar](max) NULL, CONSTRAINT [PK_PRC_Tutors] PRIMARY KEY CLUSTERED ([ID] ASC) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,…
I need remove the all comments in a SQL view created in Azure SQL Data Warehouse. Create the query without comments (/* */ ; -- , ...); regular expression functions not working Query: CREATE VIEW [dimension].[v_dim_customer] AS SELECT -- primary…
I need help to construct a TSQL query (SQL Server 2016) that can produce the following JSON structure. The structure is as follows.The root is called "Agreement". Each agreement got the main attributes AgreementDate, Position, OrganizationName. It is then followed…
I have rows containing Json like: [{"Qty": 1, "Amt": 2.99},{"Qty": 3, Amt": 4.50}] How do I get a sum of Amt per row? Reproduction Code: DROP TABLE IF EXISTS dbo.SqlQueryResults; CREATE TABLE dbo.SqlQueryResults( Id INT, Result nvarchar(max) ) GO INSERT…
I need to remove some values in a JSON array if they match with values from another table, if match id and pax: Here is some data declare @T1 Table (id int ,pax int ,rooms nvarchar(512)) declare @T2 Table (id…
This is my query: SELECT a.Id, a.Title, (SELECT m.Id, m.Name, m.MobileNo FROM [msm].[MsmMember] AS m WHERE m.Id = a.MemberId AND m.OrganizationId = @OrganizationId FOR JSON PATH, WITHOUT_ARRAY_WRAPPER) AS Member FROM msm.MsmArticleSubmission a WHERE a.OrganizationId = @OrganizationId AND a.Id = @Id…
I have this JSON: [{ "id": 1, "meta": [{ "key": "key1", "value": "ValueKey1" }, { "key": "key2", "value": "ValueKey2" } ] }, { "id": 2, "meta": [{ "key": "key2", "value": "ValueKey2" } ] }, { "id": 3, "meta": [{ "key":…
I am having problems when "migrating" my query in which I parse a column with XML stored in it, i "migrating" from T-SQL to Postgres, since my current development requires it. In T-SQL this is my current query: My query…
In Synapse dedicated pool, I'm trying to create an external table, and a dedicated table, and then insert the external table into the dedicated table but I keep getting the following error: Explicit conversion from data type bigint to date…