I wrote the SQL Server stored procedure usp_getrowcounts, shown below, that dynamically gets a row count from each table, as tables come and go, and need the equivalent dynamically generated and executed PL/SQL to work in PostgreSQL. However, working with…
This is the code that is supposed to return an html report by and ssms job. DECLARE @DataInicialMesAnterior DATE, @DataFinalMesAnterior DATE; SET @DataInicialMesAnterior = DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()) - 1, 0); SET @DataFinalMesAnterior = DATEADD(DAY, -1, DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()),…
I have a table (code_table) with a lot of different types of records and values. One of the type of records contains a json field (but not all). The following returns the records with json fields: select code_data from code_table…
Does anybody knows how to get @odata.etag value from a JSON into a SQL Server table? Many thanks! JSON string: { "@odata.context": "https://mycompany.com/Tenant/ODataV4/$metadata#Company('mycompany')/ServiceHeader/$entity", "@odata.etag":"W/"JzQ0O0NLZ0lhMkdDdkw3ZU1PbUx6M1M5V1Y4OUtUZUI5OXZOUCtjM2FRZmQ1N0E9MTswMDsn"", "Document_Type": "Order", "No": "1234", "Customer_No": "1234", "Your_Reference": "", "Payment_Terms_Code": "01", "Name": "Company ABC", "Contact_No": "4567", "Status":…
Trying to figure out how to convert multiple rows of data to a single row of KeyValue array Setup: using MS SQL SERVER 2017 raw data: Select s.id, s.FkId, s.name ,s.value from tbl s where FkId = 1024180 id |…
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…
Im running the latest version of XAMPP and its connecting to a MSSQL DATABASE with the most current drivers for PHP 7.3.8 the queries are being issued using sqlsrv_query() + sqlsrv_fetch_array() Ok so I have a SQL Query I need…
I have a query that dynamically builds a SELECT statement in SQL, and outputs as per the example below (note there can be as many as 50 select statements, each unique per email); Email Age Gender [email protected] 96 Male Email…
Physical row movement during a scan can cause missed rows and duplicate reads (same row appearing twice in the result) in SELECT queries under certain conditions. For MS SQL Server this is well documented in connection with the NOLOCK hint.…