Splitting one row of data into two when exporting a SQL result into HTML...

Generate a resultset of incrementing dates in T-SQL...

How to generate a range of dates in SQL Server...

How do I format a number with commas in T-SQL?...

UPDATE row from query with multiple matches...

Generate financial summary report...

Adding 'and' at the end of a comma separated list...

T-SQL - Projecting multiple records into one row for each key...

How to select only the first rows for each unique value of a column?...

Pros & Cons of TRUNCATE vs DELETE FROM...

SQL: parse the first, middle and last name from a fullname field...

How can I escape square brackets in a LIKE clause?...

Generate SQL Create Scripts for existing tables with query...

Insert multiple rows WITHOUT repeating the "INSERT INTO ..." part of the statement?...

SQL "EXCEPT" vs "WHERE NOT IN"...

Drop schemas and tables automatically...

Analogue for regex '?' (preceding item optional) in T-SQL like?...

The most elegant way to generate permutations in SQL server...

Combine JSON objects from multiple rows into a single object...

Invalid length parameter passed to the LEFT or SUBSTRING function in Sql Server...

TSQL Email Validation (without regex)...

TSQL DATETIME ISO 8601...

Passing Dynamic parameter using STRING_SPLIT to IN parameter...

Difference between dm_exec_sql_text vs dm_exec_input_buffer...

I want to use CASE statement to update some records in sql server 2005...

I want to create View from the system tables...

How to set value to variable using 'execute' in t-sql?...

SQL Convert Milliseconds to Days, Hours, Minutes...

What is the equivalent of the Oracle "Dual" table in MS SqlServer?...

Why would I use an SSIS package in SQL Server 2008 as opposed to some other technology?...