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…
I have a Flutter app that runs a stored procedure in SQL Server using the sql_conn package. This SP will return the login state of the user. If they are suddenly restricted from being logged in, I want the Flutter…
Following is the given JSON data: DECLARE @Jdata NVARCHAR(MAX) = '{ "EmployeeDetails": { "BusinessEntityID": 3, "NationalIDNumber": 509647174, "JobTitle": "Engineering Manager", "BirthDate": "1974-11-12", "MaritalStatus": "M", "Gender": "M", "StoreDetail": { "Store": [ { "AnnualSales": 800000, "AnnualRevenue": 80000, "BankName": "Guardian Bank", "BusinessType": "BM",…
I am getting 0 row when selecting from OPENJSON below. I am expecting to get all 3 values "AA" for different as_of_date for CREDIT_RTG . I tried different select statements. I am running in SQL 2016. Expected result should be…
I need help in transforming a string to json to put the values in separated lines. Using tsql (2019) How do I have to transform the provided data (payload) into a json to create the expected result or is there…
I have a SQL table containing 2 columns - first Column is the ID of the users and the second column holds the JSON Phone information. The phone information consist of Work, Home phones and whether it is a mobile…
I'm trying to extract data from Json stored in a column and save as relational data in tables. The Json represents submissions of a pre-start checklist by a driver. The input data is stored in a table, with SubmitId being…
I am trying to convert a JSON object with "keys" as columns and each value in the list as a row. I have managed to create the table structure I want, however I am getting the wrong number of rows.…
I need to update the table which is in the on-premises sql server database using dataflow in azure data factory I have self hosted Integration Runtime Linked services created based on this self hosted Runtime Dataset connection works fine However…
I have installed Sql Server 2019 Developer Edition and mssql-tools on my Ubuntu 20.04 minimal. I can connect to my localhost with no issue, but when I want to remote to another sql server: sqlcmd -S <server> -U <username> -P…