Hi Jeff - thanks for the offer of help. I've followed your guide (as far as I was able to) and created the following to mimic my data source:

--truncate table tstStreamlineCode

--===== Create the test table with

CREATE TABLE tstStreamlineCodes

(ID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED,

NHScode varchar(7),

sl1 varchar(5),

sl2 varchar(5),

sl3 varchar(5),

sl4 varchar(5),

sl5 varchar(5),

sl6 varchar(5),

sl7 varchar(5),

sl8 varchar(5),

sl9 varchar(5)

)

--===== All Inserts into the IDENTITY column

SET IDENTITY_INSERT tstStreamlineCodes ON

--===== Insert the test data into the test table

INSERT INTO tstStreamlineCodes

(ID, NHScode, sl1 ,sl2 ,sl3 ,sl4 ,sl5 ,sl6 ,sl7 ,sl8 ,sl9)

SELECT '1','10002K','4068','4065','4086','4069','4096','4120','4121','4097','4353' UNION ALL

SELECT '2','10006P','4068','4065','4086','4069','4096','4120','4121','4097','' UNION ALL

SELECT '3','1003T', '3632','','','','','','','','' UNION ALL

SELECT '4','1007B','3633','','','','','','','','' UNION ALL

SELECT '5','1024X','1589','2044','','','','','','','' UNION ALL

SELECT '6','1037N','1589','2044','','','','','','',''

--===== Set the identity insert back to normal

SET IDENTITY_INSERT tstStreamlineCodes OFF