I am trying to implement a stored procedure that gets the two parameters @startsWith and @endsWith and constructs this query string: @startswith + ‘%’ + @endsWith To search for entries of a single …
Tag: sql-server-2019
SQL Query on Json object inside multiple JSON objects
I have the below Json string. I need to write a query to get the TP records. Without providing the index value, we need get the result. How do I query to get the TP values. Expected Result: Answer You can use OPENJSON function containing WITH Clause added as many CROSS APPLY Clause as upto see all sub-arrays : Demo
Show Unique values only
I am using SQL Server 2019 and looking for a way to show ONLY the latest value for each AOC based on its latest FW_Version. Here is my query I have so far but this shows everything: What I would like to show ONLY items marked in yellow… How can I make this happen? Here is the list of my
Trying to connect Polybase to Oracle leads to Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication
I’m using SQL Server 2019 and try to connect to a Oracle DB via Polybase: I’m getting the error: Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication. However the user is not a domain user and oracle does not use integrated authentication. Answer As I mentioned in my comment above, you get