Grouping SQL Server Data by Time with DATEPART or DATENAME

by Al Beecy January 22, 2009
How to group data in SQL Server by date/time using the DATEPART and/or DATENAME functions. [More]

Tags: ,

SQL Server

How to encrypt a SQL Server stored procedure

by Al Beecy January 22, 2009
How to encrypt a stored procedure in SQL Server 2005. [More]

Tags: ,

SQL Server

Recursive SQL Queries Using Common Table Expressions

by Al Beecy December 18, 2008
How to use a CTE to recursivly query SQL Server data. [More]

Tags: , ,

SQL Server

Powered by BlogEngine.NET1.5.0.7 | Theme by Mads Kristensen