Error with stuff function; its cutting of my commands.

Question

Error with stuff function; its cutting of my commands.

jancas08

SSC Veteran

Points: 266
More actions
June 28, 2013 at 3:55 pm

#279635

Hi, I am having an issue with the stuff function. I want to concatenate the strings but some the last string is being cut off and I know there is to be more commands than what is in the output screen.
Here is my code. Im basically checking a database file to run updates deletes and inserts on another database file.
Im using SQL Server 2008.
The database file that contains the instructions to run the commands is CY1Errors. The other database files that are to be affected by the
EDUCATION_CY1
FOURTEEN_ALL_CY1
HH_LISTING_CY1
HH_ALL_CY1
Declare @SQL varchar(max)
--First is the updates
select @SQL = stuff ((
select
'Update dbo.' +
case
when ERRORMESSAGE LIKE 'ED%' and CorrectedValue <> 'NULL' then 'EDUCATION_CY1'
when ERRORMESSAGE LIKE 'O14%' and CorrectedValue <> 'NULL' then 'FOURTEEN_ALL_CY1'
when ERRORMESSAGE LIKE 'HL%' and CorrectedValue <> 'NULL' then 'HH_LISTING_CY1'
when ERRORMESSAGE LIKE 'HL%'and CorrectedValue <> 'NULL' then 'HH_ALL_CY1'
end
+ ' set ' + ColumnsToFix + ' = ''' + CorrectedValue
+ ''' where zBarcode = ' + cast(zBarcode as varchar(20))
+ ' and PERSON_NUMBER = ' + cast(Person_No as varchar(20)) + ';'+ CHAR(13) as MyVal
from CY1Errors
where Command = 'UPDATE'
for XML PATH(''), type
).value('.','varchar(max)'), 1, 0, '')
--select @SQL
--First is the updates
select @SQL = @SQL + stuff ((
select
'Update dbo.' +
case
when ERRORMESSAGE LIKE 'ED%' then 'EDUCATION_CY1'
when ERRORMESSAGE LIKE 'O14%' then 'FOURTEEN_ALL_CY1'
when ERRORMESSAGE LIKE 'HL%' then 'HH_LISTING_CY1'
when ERRORMESSAGE LIKE 'HL%' then 'HH_ALL_CY1'
end
+ ' set ' + ColumnsToFix + ' = NULL' +
+ ' where zBarcode = ' + cast(zBarcode as varchar(20))
+ ' and PERSON_NUMBER = ' + cast(Person_No as varchar(20)) + ';'+ CHAR(13) as MyVal
from CY1Errors
where Command = 'UPDATE' and CorrectedValue = 'NULL'
for XML PATH(''), type
).value('.','varchar(max)'), 1, 0, '')
--select @SQL
--Now we append the deletes
select @SQL = @SQL + stuff ((
select
'DELETE dbo.' +
case
when ERRORMESSAGE LIKE 'ED%' then 'EDUCATION_CY1'
when ERRORMESSAGE LIKE 'O14%' then 'FOURTEEN_ALL_CY1'
when ERRORMESSAGE LIKE 'HL%' then 'HH_LISTING_CY1'
when ERRORMESSAGE LIKE 'HL%' then 'HH_ALL_CY1'
end
+ ' where zBarcode = ' + cast(zBarcode as varchar(20))
+ ' and PERSON_NUMBER = ' + cast(Person_No as varchar(20)) + ';'+ CHAR(13) as MyVal
from CY1Errors
where Command = 'DELETE'
for XML PATH(''), type
).value('.','varchar(max)'), 1, 0, '')
--Now we append the inserts
select @SQL = @SQL + stuff ((
select
'INSERT INTO dbo.' +
case
when ERRORMESSAGE LIKE 'ED%' then 'EDUCATION_CY1' +
+' VALUES('+
coalesce(CAST(ED_THREE AS varchar(10)),'99999') + ','
+ coalesce(CAST(ED_Four AS varchar(10)),'99999') + ','
+ coalesce(CAST(ED_Five AS varchar(10)),'99999') + ','
+ coalesce(CAST(ED_Six AS varchar(10)),'99999')+ ','
+ coalesce(CAST(Person_No AS varchar(7)),'99999') + ','
+ coalesce(CAST(zBarcode AS varchar(15)),'99999')+ ')'
/*when ERRORMESSAGE LIKE 'O14%' then 'FOURTEEN_ALL_CY1' +
' VALUES('+
coalesce(CAST(BatchNo AS varchar(7)),'99999') + ' , ' + coalesce(CAST(zBarcode AS varchar(15)),'99999') + ' , ' + coalesce(CAST(HHBarcode AS varchar(7)),'99999')
+ ' , ''' + coalesce(CAST(Person_No AS varchar(7)),'99999') + ''' , ' + coalesce(CAST(District AS varchar(7)),'99999') + ' , '+ coalesce(CAST(URBAN_RURAL AS varchar(7)),'99999')
+ ' , ' + coalesce(CAST(Cluster AS varchar(7)),'99999')
+ ' , ' + coalesce(CAST(HHNUM AS varchar(7)),'99999') + ' , ' + coalesce(CAST(Final_Result_Code AS varchar(7)),'99999') + ' , ' + coalesce(CAST(Q1_5 AS varchar(7)),'99999')
+ ' , ' + coalesce(CAST(Q1_5_KNS AS varchar(7)),'99999') + ' , ' + coalesce(CAST(Q1_7 AS varchar(7)),'99999') + ' , '''+ coalesce(CAST(Q1_8 AS varchar(7)),'99999') + ''' , '+
coalesce(CAST(Q1_9 AS varchar(7)),'99999') + ' , ' + coalesce(CAST(Q1_9_2 AS varchar(7)),'99999') + ' , ' + coalesce(CAST(Q1_10a AS varchar(7)),'99999') + ' , ' + coalesce(CAST(Q1_10b AS varchar(7)),'99999')
+ ' , ' + coalesce(CAST(Q1_10c AS varchar(7)),'99999') + ' , ' + coalesce(CAST(Q1_10_Total AS varchar(7)),'99999') + ' , ' + coalesce(CAST(Q1_11 AS varchar(7)),'99999') + ' , ' +
coalesce(CAST(Q1_12 AS varchar(7)),'99999') + ' , ' + coalesce(CAST(Q1_13 AS varchar(7)),'99999') + ' , ' + coalesce(CAST(Q1_14 AS varchar(7)),'99999') + ' , ' + coalesce(CAST(Q1_15 AS varchar(7)),'99999') + ' , ' +
coalesce(CAST(Q1_15a AS varchar(7)),'99999') + ' , ' + coalesce(CAST(Q1_16 AS varchar(7)),'99999') + ' , ''' + coalesce(CAST(Q1_17 AS varchar(7)),'99999') + ''' , ' +coalesce(CAST(Q1_18 AS varchar(7)),'99999') + ' , '+
coalesce(CAST(Q1_19 AS varchar(7)),'99999') + ' , ' + coalesce(CAST(Q1_20 AS varchar(7)),'99999') + ' , ' +coalesce(CAST(Q1_21 AS varchar(7)),'99999') + ' , ''' + coalesce(CAST(Q1_22 AS varchar(7)),'99999')+ ''' , '''
+ coalesce(CAST(Q1_23 AS varchar(7)),'99999') + ''' , ' + coalesce(CAST(Q1_24 AS varchar(7)),'99999') + ' , ' + coalesce(CAST(Q1_25 AS varchar(7)),'99999') + ' , ' +coalesce(CAST(Q1_26 AS varchar(7)),'99999') + ' , ' + coalesce(CAST(Q1_27 AS varchar(7)),'99999')
+ ' , ' + coalesce(CAST(Q1_28_MAIN AS varchar(7)),'99999') + ' , ' + coalesce(CAST(Q1_28_OTHER AS varchar(7)),'99999') + ' , ' + coalesce(CAST(Q1_28_PREVIOUS AS varchar(7)),'99999') + ' , ' +
coalesce(CAST(Q1_29_SEASONAL AS varchar(7)),'99999') + ' , ' + coalesce(CAST(Q1_29_YEARROUND AS varchar(7)),'99999') + ' , '''+ coalesce(CAST(Q1_30_MAIN AS varchar(7)),'99999') +''' , ''' +
coalesce(CAST(Q1_30_OTHER AS varchar(7)),'99999') + ''' , ''' + coalesce(CAST(Q1_30_PREVIOUS AS varchar(7)),'99999')+ ''' , ''' + coalesce(CAST(Q1_31_MAIN AS varchar(7)),'99999') + ''' , ''' +
coalesce(CAST(Q1_31_OTHER AS varchar(7)),'99999') + ''' , '''+ coalesce(CAST(Q1_31_Previous_AJ AS varchar(7)),'99999')+ ''' , ' + coalesce(CAST(Q1_32_MAIN AS varchar(7)),'99999') + ' , ' +
coalesce(CAST(Q1_32_OTHER AS varchar(7)),'99999') + ' , ' + coalesce(CAST(Q1_32_TOTAL AS varchar(7)),'99999') + ' , ' +coalesce(CAST(Q1_33_MAIN AS varchar(7)),'99999') + ' , ' +
coalesce(CAST(Q1_33_OTHER AS varchar(7)),'99999') + ' , ' + coalesce(CAST(Q1_33_TOTAL AS varchar(7)),'99999') + ' , ' + coalesce(CAST(Q1_35 AS varchar(7)),'99999') + ' , ' + coalesce(CAST(Q1_37 AS varchar(7)),'99999') + ' , '
+ coalesce(CAST(Q1_38 AS varchar(7)),'99999') + ' , ''' + coalesce(CAST(Q1_39 AS varchar(7)),'99999') + ''' , ''' + coalesce(CAST(Q1_40 AS varchar(7)),'99999') + ''' , ' + coalesce(CAST(Q1_41 AS varchar(7)),'99999') + ' , ' +
coalesce(CAST(Q1_41_DKNS AS varchar(7)),'99999') + ' , ' + coalesce(CAST(Q1_41a AS varchar(7)),'99999') + ' , ' + coalesce(CAST(Q1_41b AS varchar(7)),'99999') + ' , ' + coalesce(CAST(Q1_41b_DKNS AS varchar(7)),'99999')
+ ' , ' + coalesce(CAST(Q1_42 AS varchar(7)),'99999') + ' , ' + coalesce(CAST(Q1_42_DKNS AS varchar(7)),'99999') + ' , ' + coalesce(CAST(Q1_43 AS varchar(7)),'99999') + ' , ' + coalesce(CAST(Q1_44 AS varchar(7)),'99999') + ')'
*/
when ERRORMESSAGE LIKE 'HL%' then 'HH_LISTING_CY1'+ ' VALUES('''+
coalesce(CAST(Person_No AS varchar(7)),'99999') + ''' , ' + coalesce(CAST(HL_Three AS varchar (10)),'99999') + ' , ' + coalesce(CAST(HL_Four AS varchar (10)),'99999')
+ ' , ' + coalesce(CAST(HL_Five AS varchar(10)),'99999') + ' , '+ coalesce(CAST(HL_Six AS varchar(10)),'99999')+ ' , ' + coalesce(CAST(HL_Seven AS varchar (10)),'99999')
+ ' , ' + coalesce(CAST(HL_SevenB AS varchar (10)),'99999') + ' , ' + coalesce(CAST(zBarcode AS varchar(15)),'99999') + ' )'
when ERRORMESSAGE LIKE 'HL%' then 'HH_ALL_CY1'+ ' VALUES('+
coalesce(CAST(BatchNo AS varchar(8)),'99999') + ' , ' + coalesce(CAST(Cluster AS varchar (10)),'99999') + ' , '
+ coalesce(CAST(HHNUM AS varchar(10)),'99999')+ ' , ' + coalesce(CAST(zBarcode AS varchar(15)),'99999') + ' , '
+ coalesce(CAST(District AS varchar(10)),'99999')+ ' , ' +
coalesce(CAST(URBAN_RURAL AS varchar(10)),'99999') + ' , ' + coalesce(CAST(Final_Result_Code AS varchar(10)),'99999')
+ ' , ' + coalesce(CAST(Person_No AS varchar(7)),'99999') + ' )'
end
+ ';' + CHAR(13) as MyVal
from CY1Errors
where Command = 'INSERT'
for XML PATH(''), type
).value('.','varchar(max)'), 1, 0, '') ;
print @SQL
--select @SQL
exec (@SQL)
In the output screen the following is shown
Update dbo.EDUCATION_CY1 set ED_THREE = NULL where zBarcode = 133593 and PERSON_NUMBER = 5;
Update dbo.EDUCATION_CY1 set ED_THREE = NULL where zBarcode = 135443 and PERSON_NUMBER = 2;
Update dbo.EDUCATION_CY1 set ED_THREE = NULL where zBarcode = 135153 and PERSON_NUMBER = 4;
Update dbo.EDUCATION_CY1 set ED_FOUR = NULL where zBarcode = 135153 and PERSON_NUMBER = 4;
Update dbo.EDUCATION_CY1 set ED_FIVE = NULL where zBarcode = 135153 and PERSON_NUMBER = 4;
Update dbo.EDUCATION_CY1 set ED_THREE = NULL where zBarcode = 135092 and PERSON_NUMBER = 7;
Update dbo.EDUCATION_CY1 set ED_FOUR = NULL where zBarcode = 135092 and PERSON_NUMBER = 7;
Update dbo.EDUCATION_CY1 set ED_FIVE = NULL where zBarcode = 135092 and PERSON_NUMBER = 7;
Update dbo.EDUCATION_CY1 set ED_THREE = NULL where zBarcode = 135092 and PERSON_NUMBER = 8;
Update dbo.EDUCATION_CY1 set ED_FOUR = NULL where zBarcode = 135092 and PERSON_NUMBER = 8;
Update dbo.EDUCATION_CY1 set ED_FIVE = NULL where zBarcode = 135092 and PERSON_NUMBER = 8;
Update dbo.EDUCATION_CY1 set ED_THREE = NULL where zBarcode = 134996 and PERSON_NUMBER = 3;
Update dbo.EDUCATION_CY1 set ED_FOUR = NULL where zBarcode = 134996 and PERSON_NUMBER = 3;
Update dbo.EDUCATION_CY1 set ED_FIVE = NULL where zBarcode = 134996 and PERSON_NUMBER = 3;
Update dbo.EDUCATION_CY1 set ED_THREE = NULL where zBarcode = 134095 and PERSON_NUMBER = 3;
Update dbo.EDUCATION_CY1 set ED_FOUR = NULL where zBarcode = 134095 and PERSON_NUMBER = 3;
Update dbo.EDUCATION_CY1 set ED_FIVE = NULL where zBarcode = 134095 and PERSON_NUMBER = 3;
Update dbo.EDUCATION_CY1 set ED_THREE = NULL where zBarcode = 134095 and PERSON_NUMBER = 4;
Update dbo.EDUCATION_CY1 set ED_FOUR = NULL where zBarcode = 134095 and PERSON_NUMBER = 4;
Update dbo.EDUCATION_CY1 set ED_FIVE = NULL where zBarcode = 134095 and PERSON_NUMBER = 4;
Update dbo.EDUCATION_CY1 set ED_THREE = NULL where zBarcode = 134095 and PERSON_NUMBER = 5;
Update dbo.EDUCATION_CY1 set ED_FOUR = NULL where zBarcode = 134095 and PERSON_NUMBER = 5;
Update dbo.EDUCATION_CY1 set ED_FIVE = NULL where zBarcode = 134095 and PERSON_NUMBER = 5;
Update dbo.EDUCATION_CY1 set ED_THREE = NULL where zBarcode = 134095 and PERSON_NUMBER = 6;
Update dbo.EDUCATION_CY1 set ED_FOUR = NULL where zBarcode = 134095 and PERSON_NUMBER = 6;
Update dbo.EDUCATION_CY1 set ED_FIVE = NULL where zBarcode = 134095 and PERSON_NUMBER = 6;
Update dbo.EDUCATION_CY1 set ED_THREE = NULL where zBarcode = 134095 and PERSON_NUMBER = 7;
Update dbo.EDUCATION_CY1 set ED_FOUR = NULL where zBarcode = 134095 and PERSON_NUMBER = 7;
Update dbo.EDUCATION_CY1 set ED_FIVE = NULL where zBarcode = 134095 and PERSON_NUMBER = 7;
Update dbo.EDUCATION_CY1 set ED_THREE = NULL where zBarcode = 134095 and PERSON_NUMBER = 8;
Update dbo.EDUCATION_CY1 set ED_FOUR = NULL where zBarcode = 134095 and PERSON_NUMBER = 8;
Update dbo.EDUCATION_CY1 set ED_FIVE = NULL where zBarcode = 134095 and PERSON_NUMBER = 8;
Update dbo.EDUCATION_CY1 set ED_THREE = NULL where zBarcode = 133777 and PERSON_NUMBER = 3;
Update dbo.EDUCATION_CY1 set ED_FOUR = NULL where zBarcode = 133777 and PERSON_NUMBER = 3;
Update dbo.EDUCATION_CY1 set ED_FIVE = NULL where zBarcode = 133777 and PERSON_NUMBER = 3;
Update dbo.EDUCATION_CY1 set ED_THREE = NULL where zBarcode = 133821 and PERSON_NUMBER = 3;
Update dbo.EDUCATION_CY1 set ED_THREE = NULL where zBarcode = 135153 and PERSON_NUMBER = 4;
Update dbo.EDUCATION_CY1 set ED_FOUR = NULL where zBarcode = 135153 and PERSON_NUMBER = 4;
Update dbo.EDUCATION_CY1 set ED_FIVE = NULL where zBarcode = 135153 and PERSON_NUMBER = 4;
Update dbo.EDUCATION_CY1 set ED_THREE = NULL where zBarcode = 135092 and PERSON_NUMBER = 7;
Update dbo.EDUCATION_CY1 set ED_FOUR = NULL where zBarcode = 135092 and PERSON_NUMBER = 7;
Update dbo.EDUCATION_CY1 set ED_FIVE = NULL where zBarcode = 135092 and PERSON_NUMBER = 7;
Update dbo.EDUCATION_CY1 set ED_THREE = NULL where zBarcode = 135092 and PERSON_NUMBER = 8;
Update dbo.EDUCATION_CY1 set ED_FOUR = NULL where zBarcode = 135092 and PERSON_NUMBER = 8;
Update dbo.EDUCATION_CY1 set ED_FIVE = NULL where zBarcode = 135092 and PERSON_NUMBER = 8;
Update dbo.EDUCATION_CY1 set ED_THREE = NULL where zBarcode = 134996 and PERSON_NUMBER = 3;
Update dbo.EDUCATION_CY1 set ED_FOUR = NULL where zBarcode = 134996 and PERSON_NUMBER = 3;
Update dbo.EDUCATION_CY1 set ED_FIVE = NULL where zBarcode = 134996 and PERSON_NUMBER = 3;
Update dbo.EDUCATION_CY1 set ED_THREE = NULL where zBarcode = 134095 and PERSON_NUMBER = 3;
Update dbo.EDUCATION_CY1 set ED_THREE = NULL where zBarcode = 134095 and PERSON_NUMBER = 4;
Update dbo.EDUCATION_CY1 set ED_THREE = NULL where zBarcode = 134095 and PERSON_NUMBER = 5;
Update dbo.EDUCATION_CY1 set ED_THREE = NULL where zBarcode = 134095 and PERSON_NUMBER = 6;
Update dbo.EDUCATION_CY1 set ED_THREE = NULL where zBarcode = 134095 and PERSON_NUMBER = 7;
Update dbo.EDUCATION_CY1 set ED_THREE = NULL where zBarcode = 134095 and PERSON_NUMBER = 8;
Update dbo.EDUCATION_CY1 set ED_THREE = NULL where zBarcode = 133777 and PERSON_NUMBER = 3;
Update dbo.EDUCATION_CY1 set ED_THREE = NULL where zBarcode = 133821 and PERSON_NUMBER = 3;
Update dbo.HH_LISTING_CY1 set HL_FIVE = NULL where zBarcode = 133289 and PERSON_NUMBER = 1;
Update dbo.HH_LISTING_CY1 set HL_FIVE = NULL where zBarcode = 133289 and PERSON_NUMBER = 2;
Update dbo.HH_LISTING_CY1 set HL_FIVE = NULL where zBarcode = 133289 and PERSON_NUMBER = 3;
Update dbo.HH_LISTING_CY1 set HL_FIVE = NULL where zBarcode = 133289 and PERSON_NUMBER = 4;
Update dbo.HH_LISTING_CY1 set HL_FIVE = NULL where zBarcode = 133289 and PERSON_NUMBER = 5;
Update dbo.HH_LISTING_CY1 set HL_FIVE = NULL where zBarcode = 133289 and PERSON_NUMBER = 6;
Update dbo.HH_LISTING_CY1 set HL_FIVE = NULL where zBarcode = 133418 and PERSON_NUMBER = 1;
Update dbo.HH_LISTING_CY1 set HL_FIVE = NULL where zBarcode = 133418 and PERSON_NUMBER = 2;
Update dbo.HH_LISTING_CY1 set HL_FIVE = NULL where zBarcode = 133418 and PERSON_NUMBER = 3;
Update dbo.HH_LISTING_CY1 set HL_FIVE = NULL where zBarcode = 133418 and PERSON_NUMBER = 4;
Update dbo.HH_LISTING_CY1 set HL_FIVE = NULL where zBarcode = 133418 and PERSON_NUMBER = 5;
Update dbo.HH_LISTING_CY1 set HL_FIVE = NULL where zBarcode = 133340 and PERSON_NUMBER = 1;
Update dbo.HH_LISTING_CY1 set HL_FIVE = NULL where zBarcode = 133340 and PERSON_NUMBER = 2;
Update dbo.HH_LISTING_CY1 set HL_FIVE = NULL where zBarcode = 133340 and PERSON_NUMBER = 3;
Update dbo.HH_LISTING_CY1 set HL_FIVE = NULL where zBarcode = 133258 and PERSON_NUMBER = 5;
Update dbo.HH_LISTING_CY1 set HL_SEVEN = NULL where zBarcode = 133289 and PERSON_NUMBER = 4;
Update dbo.HH_LISTING_CY1 set HL_SEVEN = NULL where zBarcode = 133289 and PERSON_NUMBER = 3;
Update dbo.HH_LISTING_CY1 set HL_THREE = NULL where zBarcode = 133920 and PERSON_NUMBER = 1;
Update dbo.HH_LISTING_CY1 set HL_THREE = NULL where zBarcode = 133920 and PERSON_NUMBER = 2;
Update dbo.HH_LISTING_CY1 set HL_THREE = NULL where zBarcode = 133920 and PERSON_NUMBER = 3;
Update dbo.HH_LISTING_CY1 set HL_SEVEN = NULL where zBarcode = 133289 and PERSON_NUMBER = 4;
Update dbo.HH_LISTING_CY1 set HL_SEVEN = NULL where zBarcode = 133289 and PERSON_NUMBER = 3;
Update dbo.HH_LISTING_CY1 set HL_SEVEN = NULL where zBarcode = 133708 and PERSON_NUMBER = 2;
Update dbo.HH_LISTING_CY1 set HL_THREE = NULL where zBarcode = 133708 and PERSON_NUMBER = 2;
Update dbo.HH_LISTING_CY1 set HL_SEVEN = NULL where zBarcode = 134040 and PERSON_NUMBER = 2;
Update dbo.HH_LISTING_CY1 set HL_THREE = NULL where zBarcode = 134040 and PERSON_NUMBER = 2;
Update dbo.HH_LISTING_CY1 set HL_SEVEN = NULL where zBarcode = 133715 and PERSON_NUMBER = 2;
Update dbo.HH_LISTING_CY1 set HL_THREE = NULL where zBarcode = 133715 and PERSON_NUMBER = 2;
Update dbo.HH_LISTING_CY1 set HL_SEVEN = NULL where zBarcode = 134828 and PERSON_NUMBER = 2;
Update dbo.HH_LISTING_CY1 set HL_SEVEN = NULL where zBarcode = 134828 and PERSON_NUMBER = 1;
Update dbo.FOURTE
However when I check there are rows missing so I know somehow the stuff is cutting off the statements.
Please any assistance will be appreciated. I am really stuck.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Luis Cazares SSC Guru Points: 183698 More actions · Answer 1

Why are you using STUFF anyway?

SSMS won't show all the characters in a varchar(MAX), you need to export them to some client that will show them (or check this article http://www.sqlservercentral.com/articles/T-SQL/72129/).

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

jancas08 SSC Veteran Points: 266 More actions · Answer 2

Well on the forum, they suggested to use stuff. I will look at the link you provided. If I have any questions I will post back.

Luis Cazares SSC Guru Points: 183698 More actions · Answer 3

People usually use STUFF in the code you're using to eliminate the first comma. Since you're not eliminating any character, there's no need to use it.

Be sure to understand the code you're using. Ask as many questions as needed when obtaining a code from a forum. Here we are happy to help you.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

jancas08 SSC Veteran Points: 266 More actions · Answer 4

Thanks for some reason I thought stuff was similar to concatenate, but I I looked it up and I see what you are saying.