In my Azure SQL Managed Instance, I'm unable to create CONTAINED databases and use ordinary logins and passwords with them (not Azure AD users). In SSMS > New Database > Options, the Containment type option is grayed out. If I…
I have one table which contains one JSON string column. How can I extract the information this into several different columns? The json column values look something like this: [{"Name":"Id1","Value":"11ea1111-cc22-3bb3-a33d-62159f192eba"}, {"Name":"Id2","Value":"b2222222-7777-00eb-0cc1-12345687bbbb"}, {"Name":"Id3","Value":"5d65d2c1-151e-41b4-af00-12345687aaaa"}, {"Name":"Id4","Value":"5bbd0da5-7698-4fa6-a893-9874654123aa"}, {"Name":"Quantity","Value":"10"}, {"Name":"Id5","Value":"d22222-8877-4558-ah32-789456123"}] I would like to extract…
I have a table with data: create Table ProductSales ( Productname varchar(50), Year int, Sales int ); Insert into ProductSales values ('A', 2017, 100), ('A', 2018, 150), ('A', 2019, 300), ('A', 2020, 500), ('A', 2021, 450), ('A', 2022, 675), ('B',…
I have table rank and inside I have five different columns I want to fetch row record where I have maximun value for instance I have a column phd_ratio so I said: SELECT * FROM rank HAVING max(phd_ratio) Meaning I…
How can I insert a row per group member with a constant value? For example, the following table is a result of ranking hospital visits per user, from earliest to latest. name time lifetime_visit_at_hospital jack 2022-12-02 03:25:00.000 1 jack 2022-12-02…
I have several columns in my database. In one of these columns is a JSON string like: fyvfvv. [ { "Value": "0000138010687", "Name": "Code" } ] I need to select those rows from the database, whose JSON is filled with…
I have a table in Postgres with the following schema: create table if not exists cars ( id bigserial not null, tyre_code varchar(8) ); The tyre_code in the table should ideally not be more than 8 characters in length. But,…
I know there are a few other similar questions out there, but I cannot seem to make this query work. I have a Rails 7 app with Recipe and Ingredient models joined through a Portions table (see models below). Given…
I have two table 'affiliate_stats' and 'transaction', 'affiliate_stats' have column 'affiliate_sales' varchar(2000) (child table), and 'transaction' have column '_id' varchar(100) primary key (parent table) when I add foerign key to 'affiliate_sales' referenced to '_id' by ALTER TABLE affiliate_stats ADD CONSTRAINTfk_affili_sales…
I have a Postgres table like: id | value | category 0 | 10 | a 1 | 11 | b 2 | 50 | b 3 | 20 | a and I want the following (where the expression in…