By Burton Roberts, 10/23/2002
Trying to keep up with changing data in your reports? You can provide variable-width crosstab reports by using dynamic SQL. But ADO.NET's relational features provide a more ...
By Burton Roberts, 12/01/2001
A reader shares a tip for using fn_Split() to create a table-valued function that transforms row- and column-delimited strings into tables.
By Burton Roberts, 06/20/2001
This copycat UDF, created in the image of VB's Split() function, helped the author parse thousands of query lines and emulate variable-length parameter arrays