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
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