Nice article!

Just a quick point.

I know the author isn't from a .Net background, but a slight improvement to the code would be to use a class level variable to store...

Which bit?

All of it or just the implementation?

How about some XML?

DECLARE @idoc int

DECLARE @doc varchar(1000)

DECLARE @list varchar(100)

DECLARE @xpath varchar(50)

DECLARE @lookupID char(2)

SET @lookupID = '25'

SET @xpath = '/ROOT/Code[@codeID=' + @lookupID + ']/Alternate'

SET @list = ''

SET @doc ='

...