Jason A. Long questions

Jason A. Long answers

• [Azure/mssql]How do I get Insert query recordset
• Can I use dynamically LIKE and IN together?
• How to write a case when statement when there are overlaps in T-SQL
• Is there a way to specify the column length in a temp table through the use of a SQL parameter in SQL Server?
• How to Pivot/Transpose Top 5 Rows to Columns
• Split string by two delimiters into two columns
• Dimension for geozones or Lat & Long in data warehouse
• Guarantee random inserting
• Natural (human alpha-numeric) sort in Microsoft SQL Server