SQL – Page 1056 – SQL Questions Answer

Eliminate the rows that becomes same after swapping as in original table in SQL Server

I have a table which contains data as follows: I want a table which do not have Mumbai—>Jaipur as it is present already before being swapped. Similarly, Lucknow—>Indore is not required. All other entries must come as it is which is there in the existing table. Can any body help. Note: Table must not have any id or S.No. in

SQL – Column containing current firmware string based on occational messages with several machines

azure-sql-database sql sql-server

I have a table called SessionEvents. I’m trying to create a column that represents the firmware that is on the machine to later be able to filter messages for only certain software. Currently my SQL query looks like this. (Based on answer by adamlamar in How do I efficiently select the previous non-null value? with slight modifications.) I’m using JOIN

Return word with the capital letter from string

sql sql-server

I have a column like: How to get: Assume there is only one word with the capital letter per string. Answer You would need PATINDEX (to find any of the capital letters within the string), CHARINDEX (to find the position of space after the capital letter or end of the string) and SUBSTRING (to get the part of the whole

Eliminate the rows that becomes same after swapping as in original table in SQL Server

SQL – Column containing current firmware string based on occational messages with several machines

Return word with the capital letter from string

Is there a way to use a table value attribute in where clause in SQL

APEX: Submit without refreshing the page

What’s the most efficient way of truncating the names in a first_name and last_name column to 1 character?

How to save SQL query analytics in the background while still delivering records to user?

SQL – Finding foreign key ID associated with a combination of multiple/variable table variable rows

SQL Query to get the compliance status