All Articles -> SQL Server Queries

Joining to the Next Sequential Row ( 2 April 2008 - Paul Alcon - 20 Comments)

Writing Outer Joins in T-SQL ( 11 February 2008 - Kathi Kellenberger - 13 Comments)

Aggregating Correlated Sub-Queries ( 23 October 2007 - Jeff Smith - 2 Comments)

How to Use GROUP BY with Distinct Aggregates and Derived tables ( 31 July 2007 - Jeff Smith - 4 Comments)

How to Use GROUP BY in SQL Server ( 30 July 2007 - Jeff Smith - 7 Comments)

Returning Complex Data from User-Defined Functions with CROSS APPLY ( 11 June 2007 - Jeff Smith - 4 Comments)

Returning a week number for any given date and starting fiscal month ( 2 May 2007 - Paul Alcon - 5 Comments)

Common Table Expressions ( 15 August 2006 - Bill Graziano - 0 Comments)

Using CROSS APPLY in SQL Server 2005 ( 4 May 2005 - Bill Graziano - 18 Comments)

Regular Expressions in T-SQL ( 24 June 2003 - Guest Authors - 45 Comments)

Spotting breaks in data sequences ( 16 July 2002 - Bill Graziano - 11 Comments)

Case sensitive queries ( 21 June 2002 - Bill Graziano - 0 Comments)

Statistics in SQL (Sample Chapter) ( 27 May 2002 - Bill Graziano - 3 Comments)

Generating ADO Parameters with Information Schema Views ( 10 December 2001 - Garth Wells - 8 Comments)

Displaying Images that Reside in a Database ( 13 November 2001 - Bill Graziano - 0 Comments)

Cursor Performance ( 17 September 2001 - Bill Graziano - 13 Comments)

Using Len() in a Select Statement ( 1 August 2001 - Damian Maclennen - 15 Comments)

Trees in SQL ( 7 June 2001 - Bill Graziano - 0 Comments)

Answering a SQL Query Question from a Recruiter ( 28 March 2001 - Bill Graziano - 7 Comments)

OLE DB Connectivity ( 22 March 2001 - Bill Graziano - 0 Comments)

More Recordset Paging ( 9 March 2001 - Rob Volk - 0 Comments)

Another Recruiter Asks a SQL Question ( 7 March 2001 - Bill Graziano - 14 Comments)

Quoted Identifiers in SQL Server 2000 ( 11 December 2000 - Brent Huscher - 2 Comments)

Returning a Row Number in a Query ( 5 December 2000 - Bill Graziano - 26 Comments)

String Functions: Incrementing a Number in a Char ( 27 November 2000 - Bill Graziano - 9 Comments)

Let SQL Server Write SQL Statements ( 10 November 2000 - Bill Graziano - 6 Comments)

SQL Query asked by a recruiter ( 7 November 2000 - Bill Graziano - 14 Comments)

Group By using Weeks ( 2 October 2000 - Bill Graziano - 15 Comments)

Cursors: An Overview ( 30 August 2000 - Bill Graziano - 1 Comment)

Using ISNULL ( 25 August 2000 - Bill Graziano - 5 Comments)

Keeping Data in Temp Tables ( 21 August 2000 - Bill Graziano - 2 Comments)

Comparing Dates ( 21 August 2000 - Bill Graziano - 4 Comments)

Converting Multiple Rows into a CSV String ( 15 August 2000 - Chris Miller - 9 Comments)

Computed Columns ( 10 August 2000 - Bill Graziano - 1 Comment)

SQL Subqueries from ASP ( 9 August 2000 - Bill Graziano - 0 Comments)

Using VBScript to make a new SQL Server Database ( 2 August 2000 - Bill Graziano - 0 Comments)

Dates in SQL Server ( 1 August 2000 - Bill Graziano - 7 Comments)

Dynamic SQL or How do I SELECT TOP @var records? ( 1 August 2000 - Bill Graziano - 12 Comments)

Writing dyanmic SQL in an ASP page ( 29 July 2000 - Bill Graziano - 3 Comments)