Matt questions

Matt answers

• How to find gaps in a sequence of numbers in SQL Server
• Convert rows to columns with pivoting
• Limiting GROUP BY based on COUNT() values in mySQL
• How to make a SQL Server agent job step failure on purpose
• Conflicting assembly names after copying script components in SSIS
• SQL Hierarchy - Resolve full path for all ancestors of a given node
• Using datetime in SQLite for getting values this month and last month
• SQL Updating Optional Parameters PHP
• Does DISTINCT rule out Nulls
• SQL Job executing SSIS - Could not complete cursor operation because the table schema changed after the cursor was declared