GilM questions

GilM answers

• Pass a Parameter(s) to SQL Agent Job
• how use SQL WHERE CASE with NOT IN or equals at the same time?
• Refactoring a tsql view which uses row_number() to return rows with a unique column value
• Relative path in t sql?
• Combine continuous datetime intervals by type
• Transact-SQL to sum up elapsed time
• undocumented CONVERT styles - datetime 23
• Finding duplicate values in different columns on the same row
• Simulate a table with multiple rows just with SELECT statement
• How to control nullability in SELECT INTO for literal-based columns