GilM questions

GilM answers

• TSQL: Update values by using With statement?
• Escape sequence for $ (dollar sign) in T-sql script
• 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