Squirrel questions

Squirrel answers

• Join tables with condition that all row values are unique
• SQL - Never select another record with the same id sorted by date
• Create table in SQL Server using union
• How to write SQL to calculate running average with some additional formulae?
• SQL Aggregation for a smaller result set
• Passing variable into xp_cmdshell
• Using wildcards with SET
• Loop through CTE results and run a query for each
• SQL: find count of duplicates, new values added, and values removed in the same table (dynamically)
• Return only databases name that have stored procedures