SELECT CONVERT(DATE, GETDATE())
How to solve "TableAdapter can't see stored procedure returned fields when using temp table" problem
How to concatenate text from multiple rows into a single text string in SQL server?
Date and Time Conversions in SQL Server
"ORDER BY" with CASE and UNION in SQL Server
Create, Alter, Drop and Execute SQL Server Stored Procedures