Stuart Ainsworth questions

Stuart Ainsworth answers

• Query insisting on columns in the 'Order By' clause match columns in the 'Group by' clause
• Single transaction for multiple steps (scheduled job t-sql)
• Suggestions for creating a Unique ID when doing a UNION of more tables
• SQL Server 2008 autocomplete for "TOP" keyword
• Show comma instead of point as decimal separator
• Insert multiple rows into table in SQL Server
• SQL -How to add an auto incremental id in a auto generated temporary table
• Check if a SQL Select statement returns no rows
• How can I write a T-SQL query to do a "like in"?
• Central SQL Server development database server