My solution where I posted the coalesce solution will eat up a cursor on performance. Another better solution than using a cursor is:

Declare @tblName Table

(

...

Here is alternative and the performance should be a little better as well:

Declare @locBclCodeList Varchar(Max)

Select @locBclCodeList = COALESCE(LTrim(RTrim(@locBclCodeList)) + ',' ,'') + [BclCode]

...

To all,

Here is an alternative to creating a Comma delimit list directly from a table.

-- Create a Comma Delimited List of Client Numbers (BclCode] in

-- ...

The tables I am using this particular function with:

Check_Main - 132,937 records

Check_Dates - 138,232 records

Check_Header - 10,469,471 records

Check_Detail ...

This is a function I use to return 0.00 for a null value. The use is

Declare Amt Decimal(10,2)

Select Amt = dbo.ConvertNullToZero(DbAmtVal)

From...