Sitan CSV TSQL tip

Treba vam CSV lista sa kolonama iz tabele?
Koristite CURSOR?
Nemojte više, može mnogo brže :)

USE Northwind
GO

DECLARE @Lista nvarchar(max) = ''

SELECT @Lista = @Lista + ', ' + CustomerID
FROM Customers
ORDER BY CustomerID

-- na kraju malo seckanja stringa i ispis
PRINT SUBSTRING (@Lista, 3, LEN (@Lista)-2)

Rezultat:

ALFKI, ANATR, ANTON, AROUT, BERGS, BLAUS, BLONP,...

Published Saturday, December 26, 2009 9:15 PM by Milos.Milosavljevic
Filed under: , ,

Comments

# re: Sitan CSV TSQL tip@ Monday, January 04, 2010 11:37 AM

Jos jedan od nacina je pomocu XML PATH...

SELECT REPLACE(LTRIM((SELECT + '  ' + CAST(CustomerID AS VARCHAR(10))  AS [text()]

FROM Customers

ORDER BY CustomerID

FOR XML PATH(''), TYPE).value('.[1]', 'VARCHAR(MAX)')),'  ',', ')

Pozdrav,

M.

by Milos Radivojevic

Leave a Comment

(required) 
(required) 
(optional)
(required) 
Are you a human?