Interleaving values in single column of resultset...
Read MoreMore elegant way of performing math on columns...
Read MoreCalculating the Nth Percentile Value from column...
Read MoreWhy IsNull(LTrim(RTrim(Lower(null))), -1) is *?...
Read MoreDisplay duplicated data in the list...
Read MoreWhat is the result of setting a variable equal to ISNULL in SQL?...
Read MoreInsert into Table B from Table A using Distinct...
Read MoreBetter way to calculate utilisation...
Read MoreTurning a Comma Separated string into individual rows...
Read MoreMS SQL Server View not allowing CONCAT...
Read MoreHow to drop SQL default constraint without knowing its name?...
Read Moresp_delete_database_firewall_rule fails for greyed out firewall rules...
Read MoreUsing Multiple And's in a Case expression instead of subqueries...
Read MoreFOR XML PATH(''): Escaping "special" characters...
Read MoreWhy do SQL Server Scalar-valued functions get slower?...
Read MoreIs this a good or bad way of generating random numbers for each row?...
Read MoreAn implementation of the Jaro Winkler distance algorithm in Transact SQL...
Read MoreHow can I convert bigint (UNIX timestamp) to datetime in SQL Server?...
Read MoreWHERE clause with nvarchar can't distinguish between special characters...
Read MoreUsing BizTalk 2013r2 to UPSERT via WCF-SQL stored procedure...
Read MoreHow to fully print a VARCHAR(MAX) using the PRINT statement?...
Read MoreConvert week date to calendar date...
Read MoreHow to convert number of minutes to hh:mm format in TSQL?...
Read MoreShould I run VACUUM in transaction or after?...
Read MoreMatching on dates when a MM/DD combination needs to be excluded...
Read MoreGenerate a payment schedule and calculate a running total...
Read MoreUsing different order by with union...
Read More