Search code examples
Check if a group contains all items from another table...


sqlsql-serversql-server-2019relational-division

Read More
How to create a SQL query that generates a JSON array of two different objects?...


jsonsql-servert-sqlsql-server-2019for-json

Read More
Get most common value over group by for multiple columns...


sql-servert-sqlsql-server-2019

Read More
Can't select, update or delete from a table because of a 'JSON text is not properly formatte...


sql-serversql-server-2019

Read More
Why does my SQL scalar function sometimes throws "Subquery returned more than 1 value. This is ...


sqlexceptionsql-server-2019

Read More
Assign numeric values for the alphanumeric cases based on maximum value...


sqlmaxsql-server-2019

Read More
Conditional Filtering in SQL Server Based on Multiple Parameters...


sqlsql-serverdatabasesql-server-2019

Read More
Grant Access to user for using any schema objects with denying for direct using objects from other s...


sql-serversql-server-2019rights

Read More
Latest number of sequential records...


sqlsql-servert-sqlsql-server-2019

Read More
Work out in SQL the total money made from increments...


sqlsql-serverlogicwhere-clausesql-server-2019

Read More
SQL count the number of comma-separated string match in another string...


sqlsql-serversql-server-2019

Read More
Show column name along with column value in SQL Server...


sqlsql-serverpivotsql-server-2019

Read More
SQL DISTINCT MIN() - What am I doing wrong?...


sqlsql-serverdistinctsql-server-2019

Read More
Randomise while keeping ascending inside the group...


sql-serversql-server-2019

Read More
Converting a string to a datetime in MS SQL Server showing 19th Century date...


sql-serversql-server-2019

Read More
T-SQL STRING_SPLIT to get first and last item from array...


t-sqlsql-server-2019

Read More
Find the reference_id belonging to a package...


t-sqlssissql-server-2019ssis-2019

Read More
Ignore custom RAISERROR in WHILE loop...


sql-servert-sqlsql-server-2019raiserror

Read More
Transpose rows to column without numbers to aggregate...


sqlsql-serversql-server-2019

Read More
Deleting tokens shorter than 24 hours in SQL...


c#sqlsql-serversql-server-2019

Read More
Add single value from stored procedure to Select query...


sqlsql-server-2019

Read More
Unpivot columns to rows...


sql-serverunpivotsql-server-2019

Read More
Remove duplicate value available in all order...


sqlsql-serversql-server-2019

Read More
Compare value between row and increment another column...


sqlsql-serversql-server-2019

Read More
Import XML data into SQLSERVER using TSQL...


xmlt-sqlxquerysql-server-2019

Read More
Remove leading zeros with special character...


sqlsql-serversql-server-2019

Read More
Select tables for display column as rows...


sql-serverselectpivotsql-server-2019

Read More
SQL Error (137): Must declare the scalar variable "@sql"...


sqlsql-serversql-server-2019heidisql

Read More
Get element with newest date...


jsonsql-servert-sqlsql-server-2019open-json

Read More
STContains, STIntersects and STWithin return wrong result for geography...


sqlsql-serverleafletsql-server-2019geography

Read More
BackNext