In an Azure SQL database, I have a column that is storing json data. SELECT a.Response FROM [dbo].[Api] a The result of this query is json in columnar format { "PRODUCT": { "0": "a1", "1": "a2", "2": "a3", "3": "a4" }, "STOCK": { "0": 3.0, "1": 3.0, "2": 0.5, "3": 6.0 }, "SALES": { "0":… Read More T-SQL query that takes json columnar data and displays it in row format

I have column called "CustomerId" with value "1_Nissan_028" and "2_Ferrari_035". I would like to extract "Nissan" or "Ferrari" as "CustomerName". CustomerName is located in middle of CustomerId and lenght varies. Following SQL query return values like "Nissan_" or "Ferrar". How to write SQL statement? SELECT cast( SUBSTRING( CustomerId, 6, charindex(‘_’, CustomerId) ) as nvarchar(32) )… Read More How to extract value from middle of substring in SQL?

Other answers seem to be using JOIN, which correct me if I’m wrong you don’t need to use if you have a foreign key? If you do need to use JOIN would you mind showing what would work with this? CREATE TABLE Dogs ( DogID int NOT NULL, DogSize int NOT NULL, fName VARCHAR(255), ID… Read More SQL Query returning duplicate with any command with foreign keys

I have made two SQL queries both bring back the information i want which is great, i was wondering if i could combine the result into one instead of 2 separate results , i don’t know if this can be done but either show without headings or new custom headings. the SQL code i am… Read More Join two SQL Queries to produce one table without headings

I’m trying to have this result : Those two lines are from the same query, but I must duplicate the result (first called "CLI" and second "CPA"). Currently I do it with an UNION : WITH Temp AS (SELECT Code, Name, …) SELECT ‘CLI’ as RecordType, Code, Name, CONCAT(‘CLI’, Name) as TechnicalName, … FROM Temp… Read More Better way to do this (set and call parameters)

I have a scenario where I have duplicate data in a file – where the ‘unique’ identifiers equal the same. I am trying to identify which of the decimal values in the ‘Outcome1’ field is the MIN value, which will then give me results which are not duplicated. I have tried to use MIN, but… Read More Select MIN decimal value