Wednesday, 2 September 2015

Get SQL multiple row value into one column

ALTER FUNCTION [dbo].[UDF_DETAILS]( @ID INT )
RETURNS VARCHAR(MAX) AS BEGIN
DECLARE @Suggestion VARCHAR(MAX)

SELECT  @Suggestion= COALESCE(@Suggestion + '$#$#','') +  Suggestion

FROM  Suggestion WHERE ID=@ID AND  Status='1'  order by SuggestionID desc

RETURN @Suggestion
END

No comments:

Post a Comment