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 am making a web store in ASP.NET with a SQL Server database. I'm currently working on a "edit users" part of control panel. I have list of all users and "edit" and "delete" buttons for each row of a…
I have a problem statement: Write a Stored Procedure that populates a table with certain date attributes. The data would be populated for 1 year. For example the date 14-07-2020 is passed as an input parameter, then the stored procedure…
I have this case where we have different queries we want to run in SQL Server then save it in an Excel file. I parameterized the Excel dataset I have then assigned it in the "Sheet name" property but I…
I have an Azure WebJob that needs to change which DB it connects to based on the queue message it is processing: This queue message needs to access database CustomerOneDb: {"FormId":1, "DbName":"CustomerOneDb"} This queue message needs to access database CustomerTwoDb:…
I'm trying to deploy a .bacpac to my Azure Subscription, the database has some Azure AD users. I can generate the .bacpac with SSMS, but when I deploy the replicated database on Azure, I'm getting this error: Could not import…
I have a source table/excel/csv data and done ETL to target SQL table. Now if there is a new column introduced in the source data, how to replicate the data in target. Assume that there was already one load of…
I am trying to execute a while loop in a SQL Server statement. This statement is placed in PHP and contains several PHP variables. I receive parsing error which does not makes any sense to me. I provide a array…
I wrote a SQL query to get a overview of sales revenue per car manufacturer. Simple enough: select sum(s.Price * s.NumberOfCars) as Revenue, m.Name from Sale as s join Car as c on c.Id = s.CarId join Manufacturer as m…
Here is the scenario: we are using Azure Synapse analytics with 100 DTU, we have several tables. All tables are round robin distributed and clustered columnstore because data is loaded once in a day and we want it to be…