Post date: Aug 27, 2009 8:18:26 AM
CREATE Function GetThatTableAsString (@ID INT)
RETURNS varchar(1000)
AS
BEGIN
DECLARE @result varchar(1000)
SET @result = ''
Select @result = @result + RTRIM(ap.value) + ', '
FROM dbo.table ap
WHERE ap.id = @ID
IF @result <> '' SET @result = LEFT(@result , LEN(@result) - 1)
RETURN (@result)
END
GO