Very nice, but...
I used that in my production database.
Query:
DECLARE @listValues VARCHAR(8000)
DECLARE @how_much int
SET @how_much = 0
SELECT @listValues = ISNULL(@listValues + ';' + rTRIM(CAST(inv.NUMBER AS VARCHAR(8000))),
rTRIM(CAST(inv.NUMBER AS VARCHAR(8000)))),
@how_much = @how_much + 1
FROM INVOICE AS inv
ORDER BY inv.NUMBER
SELECT list = @listValues, how_much = @how_much
and I've got:
list=ZZ/1573/04/10
how_much=1
but with query:
DECLARE @listValues VARCHAR(8000)
DECLARE @how_much int
SET @how_much = 0
SELECT @listValues = ISNULL(@listValues + ';' + rTRIM(CAST(inv.NUMBER AS VARCHAR(8000))),
rTRIM(CAST(inv.NUMBER AS VARCHAR(8000)))),
@how_much = @how_much + 1
FROM INVOICE AS inv
SELECT list = @listValues, how_much = @how_much
I've got:
list=FV 1/2009;FV 2/2009;P 1/2009;P 2/2009;FV 3/2009;FK 1/2009;FV 4/2009; FV 574/09;1498222;FV 5/2009;425/09/RA;FV 6/2009;FV 7/2009;FV 8/2009;FV 9/2009;FV 10/2009;FV 11/2009;FV 12/2009;FV 13/2009;FV 14/2009;FV 15/2009;FV 16/2009;FV 17/2009;FV 18/2009;FV 19/2009;FV 20/2009; ...
and much more:-)
because the how_much was 5272