Store proce. set number of record to 50 per page 1

[skitterpatch]

Dear Sir or Madam,
I have the following store prod. and I need to take that and limit the number of results to 50 per page. Thanks for your assistance. Regards, Jim.



CREATE PROCEDURE Forum_GetGroups @ThemeID int, @Days int = -1 AS
declare @@ThemeName varchar(50), @@Theme varchar(30), @@ThemeDescription varchar(4000), @@ThemeLogo int

set nocount on

select @@ThemeName = t.Name, @@Theme =t. Theme,
@@ThemeDescription = convert(varchar(4000), t.Description),
@@ThemeLogo = case when datalength(Logo) > 1 then
1
else
0
end
from NewsThemes t (nolock) where t.Id = @ThemeID


select g.ID, g.Moderated, g.Moderator, g.LastMessageDate, g.IsLocked,
CASE WHEN @@Theme = 'ARTFORUM' THEN
convert(varchar(50), g.Description)
ELSE
g.Name
END AS Name,
CASE WHEN @@Theme = 'ARTFORUM' THEN
''
ELSE
g.Description
END AS Description,
MessageCount = dbo.fForum_GetCount( '*', getdate(), 0, 1, @ThemeID, g.ID, @Days ),
TopMessageCount = dbo.fForum_GetCount( '*', getdate(), 1, 1, @ThemeID, g.ID, @Days ),
ThemeName = @@ThemeName, ThemeDescription = @@ThemeDescription,
CASE WHEN datalength(Logo) > 0 THEN
1
ELSE
0
END As Logo, ThemeLogo = @@ThemeLogo
from NewsGroups g (nolock)
where ThemeID = @ThemeID and
(@@Theme <> 'ARTFORUM' or exists(select ID from NewsMessages m (nolock) where m.GroupID = g.ID and m.Published = 1) )
order by Name

 

[SQLDenis]

>>Dear Sir or Madam, (or Menace)

scroll down for SQL solutions:

http://www.aspfaq.com/show.asp?id=2120

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/