what i did here is create the array in sql server.
example
Table name : #tblInvoiceNumber
INV_NO
row1
row2
row3
I convert this in to a columnar with comma dilimeted to result it in 1 column
This is used to make it comma delimited
while @int_min <= @int_max
begin
select @var_InvoiceNumber = isnull(INV_NO,'') from #tblInvoiceNumber where ID = @int_min
if(isnull(@var_InvoiceNumber,'')<>'' )
begin
set @out_InvoiceNo = @var_InvoiceNumber + ',' + @out_InvoiceNo
end
set @int_min = @int_min + 1
end
select @out_InvoiceNo as out_InvoiceNo