Database

<br />
set ANSI_NULLS ON<br />
set QUOTED_IDENTIFIER ON<br />
GO<br />
CREATE FUNCTION [dbo].[ConcatNotes](@TicketId BigInt) <br />
RETURNS NVarChar(4000)<br />
AS<br />
BEGIN<br />
<br />
	-- Declare the return variable here<br />
	DECLARE @Narrative NvarChar(4000)<br />
	DECLARE @Notes NVarChar(2000)<br />
	DECLARE notes_cursor CURSOR FOR SELECT [Text] FROM Notes WHERE TicketId = @TicketId ORDER BY NoteId ASC<br />
	OPEN notes_cursor<br />
	FETCH NEXT FROM notes_cursor INTO @Notes<br />
	SET @Narrative = ''<br />
	WHILE @@FETCH_STATUS = 0<br />
		BEGIN<br />
			IF LEN(@Narrative) > 0<br />
				BEGIN<br />
					SET @Narrative = @Narrative + ' ¦ '<br />
				END<br />
			SET @Narrative = @Narrative + @Notes<br />
			FETCH NEXT FROM notes_cursor INTO @Notes		<br />
		END<br />
<br />
	CLOSE notes_cursor<br />
	DEALLOCATE notes_cursor<br />
	-- Return the result of the function<br />
	RETURN LTRIM(@Narrative)<br />
END<br />
<br />

<br />
SELECT TOP(@N) web_News.ArticleDate, web_NewsLocalized.ArticleTitle,<br />
web_NewsLocalized.ArticleText<br />
FROM web_News INNER JOIN web_NewsLocalized ON<br />
web_News.ArticleId=web_NewsLocalized.ArticleId<br />
WHERE ((web_NewsLocalized.ArticleCulture)=[@Culture]) ORDER BY web_News.ArticleDate DESC;<br />

<br />
SELECT web_News.ArticleDate, web_NewsLocalized.ArticleTitle,<br />
web_NewsLocalized.ArticleText, (SELECT COUNT(*) FROM web_News AS B WHERE B.ArticleDate>=A.ArticleDate) AS RowNumber<br />
FROM web_News AS A INNER JOIN web_NewsLocalized ON<br />
web_News.ArticleId=web_NewsLocalized.ArticleId<br />
WHERE ((web_NewsLocalized.ArticleCulture)=[@Culture] AND RowNumber<=@N) ORDER BY web_News.ArticleDate DESC;<br />