SQL function to consolidate detail rows into a string
Posted in Uncategorized on November 2nd, 2009 No Comments »
Or, how to convert a jagged result set into a CSV from within MS SQL server (2005+):
CREATE FUNCTION
dbo.GetKeywordList(@VideoModuleID uniqueidentifier)
RETURNS VARCHAR(Max)
AS
BEGIN
DECLARE @csv VARCHAR(MAX)
SELECT @csv [...]