Advanced SQL Querying

Advanced

• Creating Dynamic SQL statements that reflect user form selections at SQLBook.com

  A frequent business requirement is the implementation of a form that allows a user to filter data. This can require the developer to create dynamic SQL statements that reflect the filters specified by the user

• Creating a comma delimited list of column values without a SQL cursor at SQLBook.com

  There may be many reasons you want to build a comma delimited list of values from a table column. This article demonstrates how to build this list without using a cursor.

• Using SQL Cross Join - the report writers secret weapon

  The SQL CROSS JOIN is an often overlooked part of SQL but it can prove invaluable if you are aware of which situations it can be useful in.

• SQL Cursors - how to avoid them

  Whilst many SQL books advise you not to use SQL cursors, not many provide alternative solutions. This article shows how alternatives to cursors can be implemented.

• Using SQL to parse a comma delimited list - example code

  This example SQL script shows how to parse a comma delimited list using SQL