Stuart Ainsworth questions

Stuart Ainsworth answers

• Is there a better approach than a SQL Stored Procedure?
• Sql query needs to include bank holidays
• 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