Articles on Queries

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

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

Dates in SQL Server ( 1 August 2000 - Bill Graziano

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

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

SQL Subqueries from ASP ( 9 August 2000 - Bill Graziano

Computed Columns ( 10 August 2000 - Bill Graziano

Comparing Dates ( 21 August 2000 - Bill Graziano

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

Using ISNULL ( 25 August 2000 - Bill Graziano

Cursors: An Overview ( 30 August 2000 - Bill Graziano

Group By using Weeks ( 2 October 2000 - Bill Graziano

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

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

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

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

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

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

More Recordset Paging ( 9 March 2001 - Rob Volk

OLE DB Connectivity ( 22 March 2001 - Bill Graziano

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

Trees in SQL ( 7 June 2001 - Bill Graziano

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

Cursor Performance ( 17 September 2001 - Bill Graziano

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

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

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

Case sensitive queries ( 21 June 2002 - Bill Graziano

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

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

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

Common Table Expressions ( 15 August 2006 - Bill Graziano

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

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

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

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

Aggregating Correlated Sub-Queries ( 23 October 2007 - Jeff Smith

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

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

Using Dynamic SQL in Stored Procedures ( 7 March 2011 - Bill Graziano