Sorry about that

Procedure [dbo].[spReadUserMenuXML] @lngUserID Int, @intRoleID Int, @intLevelParentID Int

AS

My ultimate goal is to change the process all together, unfortunately, the log in process is maintained in a VB6 .dll that I really dont want to touch because its...

From the result set, looks like 1 vs more than one.

If its 1, there is a physical link in the result set to a page.

If there is more than one,...

Ya, its 2000. We have had an AFE in the accounting departments hands for 2008 since early last year. Given the market, I wouldnt expect that to get...

PROCEDURE [dbo].[spA_ReadMenuLevels]

@user-id Int,

@RoleID Int,

@LevelParentID Int

AS

SELECT

l.level_id,

l.level_parent_id,

l.level_desc,

l.level_order,

l.role_id

FROM

dbo.levels l

WHERE

l.level_parent_id = @LevelParentID

AND l.active = 1

AND ((l.specific = 0 AND l.role_id <= @RoleID) OR (l.specific = 1 AND l.role_id =...

Yup, all its doing is building a three tiered menu system with some authtenication built around a role.

[spA_ReadDataListForLevel] @lngUserID Int, @intRoleID Int, @intLevelID Int

AS

SET NOCOUNT ON

SELECT @intLevelID as LevelID,...