People may not know what is dbo.fnSplit that you use in this example...

You have mixed 'cl.' with 'c1.'. Are there 2 different tables?

Here are some changes, but it will be helpful if you can provide the full SELCT statement to proper fix...

When use CASE you have to put the value not the field name on THEN clause. So change it to this:

select distinct cl.table_name, field_name, t.name, inc, svalue = '(' +...

Ussualy what I do is to copy the code from sql_procedure and paste it into a blank New Query window and then change the parameters as variables at the begining....

You can create a trigger on sysobjects table, for INSERT when xType='P'.

This will give you the string in the right format:

--select all the rows into the variables

select

@Numbers = @Numbers + iNumber,

@Strings=CASE @Strings WHEN '' THEN sNumber ELSE @Strings + ',...