Stored Procedure Icon dbo.forums_GetForumInfo

Stored Procedure Properties

Name Value
Owner dbo
Created 2004-05-31
Startup False
Encrypted False

Creation Options

Name Value
QUOTED_IDENTIFIER OFF
ANSI_NULLS OFF

Parameters

Name DataType Length Type
@ForumID int 4 INPUT
@UserName nvarchar 100 INPUT

Total: 2 parameter(s)

SQL

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO




CREATE           PROCEDURE forums_GetForumInfo
(
	@ForumID int,
	@UserName nvarchar(50)
)
AS
IF @UserName IS NOT NULL
	SELECT
		ForumID = @ForumID,
		ForumGroupId,
		ParentId,
		Name,
		Description,
		Moderated,
		DaysToView,
		DateCreated,
		Active,
		TotalTopics = TotalThreads,
		SortOrder,
		IsPrivate = ISNULL((SELECT DISTINCT ForumID FROM PrivateForums WHERE ForumID = F.ForumID), 0),
		DisplayMask
	FROM 
		Forums F (nolock)
	WHERE 
		ForumID = @ForumID AND
		(ForumID NOT IN (SELECT ForumID from PrivateForums) OR
		ForumID IN (SELECT ForumID FROM PrivateForums WHERE RoleName IN (SELECT RoleName from UsersInRoles WHERE username = @UserName)))
ELSE
	SELECT
		ForumID = @ForumID,
		ForumGroupId,
		ParentId,
		Name,
		Description,
		Moderated,
		DaysToView,
		DateCreated,
		Active,
		TotalTopics = TotalThreads,
		SortOrder,
		IsPrivate = 0,
		DisplayMask
	FROM 
		Forums F (nolock)
	WHERE 
		ForumID = @ForumID AND
		ForumID NOT IN (SELECT ForumID from PrivateForums)

























GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO


					

Generated on 26/08/2004 15:05:28 by DataAide.