Search code examples
Interleaving values in single column of resultset...


sql-server-2008t-sql

Read More
More elegant way of performing math on columns...


sqlsql-servert-sqlsql-server-2012

Read More
Calculating the Nth Percentile Value from column...


sqlt-sql

Read More
Why IsNull(LTrim(RTrim(Lower(null))), -1) is *?...


sqlsql-server-2008t-sql

Read More
Display duplicated data in the list...


sqlsql-server-2008t-sql

Read More
What is the result of setting a variable equal to ISNULL in SQL?...


t-sqlvariable-assignmentisnull

Read More
Insert into Table B from Table A using Distinct...


sql-serversql-server-2008t-sql

Read More
Better way to calculate utilisation...


sqlsql-serversql-server-2008t-sql

Read More
Turning a Comma Separated string into individual rows...


sql-servercsvt-sqlsplit

Read More
MS SQL Server View not allowing CONCAT...


sql-servert-sqlviewcastingconcatenation

Read More
How to drop SQL default constraint without knowing its name?...


sqlsql-servert-sql

Read More
sp_delete_database_firewall_rule fails for greyed out firewall rules...


t-sqlazure-sql-database

Read More
Using Multiple And's in a Case expression instead of subqueries...


sqlsql-servert-sql

Read More
SUM until a certain point...


sqlsql-servert-sql

Read More
FOR XML PATH(''): Escaping "special" characters...


sql-servert-sqlsql-server-2005for-xml-path

Read More
NULL values inside NOT IN clause...


sqlsql-servert-sqlnullnotin

Read More
Why do SQL Server Scalar-valued functions get slower?...


sqlsql-servert-sqlsql-server-2005sql-function

Read More
Sleep Command in T-SQL?...


sql-servert-sqlasynchronoussleep

Read More
Is this a good or bad way of generating random numbers for each row?...


sqlsql-servert-sqlsql-server-2000random

Read More
An implementation of the Jaro Winkler distance algorithm in Transact SQL...


sqlalgorithmt-sqljaro-winkler

Read More
How can I convert bigint (UNIX timestamp) to datetime in SQL Server?...


sqlsql-servert-sqldatetimeunix-timestamp

Read More
WHERE clause with nvarchar can't distinguish between special characters...


sql-servert-sql

Read More
Using BizTalk 2013r2 to UPSERT via WCF-SQL stored procedure...


sqlt-sqlbiztalkupsertbiztalk-2013

Read More
How to fully print a VARCHAR(MAX) using the PRINT statement?...


sqlsql-serversql-server-2005t-sqlsql-server-2008

Read More
Convert week date to calendar date...


sqlsql-servert-sql

Read More
How to convert number of minutes to hh:mm format in TSQL?...


sql-servert-sqlsql-server-2008type-conversiondatediff

Read More
Should I run VACUUM in transaction or after?...


sqlmysqlt-sqlsqlitepostgresql

Read More
Matching on dates when a MM/DD combination needs to be excluded...


sql-serverdatet-sqlsql-server-2016

Read More
Generate a payment schedule and calculate a running total...


sqlsql-servert-sqlstored-procedures

Read More
Using different order by with union...


sqlsql-servert-sql

Read More
BackNext