Top Answers

1. Sql agent job last run status
   9 votes
2. Aggregate column from CTE cannot be used in WHERE clause in the query in PostgreSQL
   4 votes
3. SQL Server - Convert record per day into date range (with gaps)
   3 votes
4. Is it possible to create a view in other database with EXEC?
   3 votes
5. Pick random element by percentage weight
   3 votes