Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Stephen Lasham

SQLServerCentral.com profile

Born in England in 1966 (I'm now 38). I moved to New Zealand at 18 and qualified with a New Zealand Certificate in Data Processing (NZCDP). I worked for Nestle New Zealand for three years, then as a consultant for several software houses, and for the last ten years I've worked in local government. For 18 of these years I worked with IBM System/38 and AS/400's programming in RPG/400. For the last year I have been writing SQL and using Crystal Reports, after the council changed its core software to Pathway by Geac. I am married with three children.

   Items 1 to 6 of 6   
 

A Function Gotcha with the Use of an Asterisk

This article describes and demonstrates the problem of using asterisk to select all fields from a table within a table function. (from Apr 2008)   Read more...
By Stephen Lasham 2009/09/11 (first published: 2008/04/30) | Source: SQLServerCentral.com | Category: user defined function (udf)
Rating: |  Discuss |   Briefcase | 17,986 reads

Converting Hexadecimal String Values to Alpha (ASCII) Strings

In an interesting exercise in data conversion, Stephen Lasham brings us a nice article on basic manipulations.   Read more...
By Stephen Lasham 2007/05/17 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 10,876 reads

Finding Gaps in a Sequential Number Sequence

Do you use identity values? Do missing values ever cause problems? Maybe you need to look for missing invoices? Stephen Lasham brings us a technique for finding those missing values in a sequence.   Read more...
By Stephen Lasham 2006/04/03 | Source: SQLServerCentral.com | Category: sql puzzles
Rating: |  Discuss |   Briefcase | 13,090 reads

Reporting a menu structure using a recursive UDF

Selecting a menu structure from a series of tables is pretty easy. If you bound the number of levels in the menu. However if you have potentially variable numbers of levels. Stephen Lasham brings us a new piece on using recursion to select the data.   Read more...
By Stephen Lasham 2005/10/11 | Source: SQLServerCentral.com | Category: sql puzzles
Rating: |  Discuss |   Briefcase | 8,521 reads

Extracting a String Within Delimeters - Part 2

T-SQL can be a complex language to work within and code solutions with. Author Stephen Lasham brings us a twist on his last solution of extracting a string from within another string. Read about his method of working with strings in T-SQL.   Read more...
By Stephen Lasham 2004/09/13 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 7,818 reads

Extracting a String From Between Two Delimiting Characters

String manipulation in SQL Server or T-SQL can be a challenage. There are multiple ways to accomplish every task and often learning a new one may spark some creativity in yourself or teach you a better way to accomplish an old task. New Author Stephen Lasham brings us his technique for extracting a string that is delimited from within a larger string. Something I'm sure we'll all have use for in the future.   Read more...
By Stephen Lasham 2004/06/14 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 12,212 reads
   Items 1 to 6 of 6