CREATE TABLE #PageIndexForUsers
		(
			IndexId int IDENTITY (1, 1) NOT NULL,
			UserName varchar(100),
			Email varchar(100),
			CompanyId varchar(100),
			FullName varchar(100),
			User bit,
			RoleName varchar(100),
			DivList varchar(200),
			RegList varchar(200),
			FacList varchar(200),
			Logout bit,
			URL varchar(200)
		)

		/*--------------------------------------- Insert records into Temp Table ------------------------------------------ */
	
		declare  @TempUsername varchar(100),
				 @TempDivList varchar(200),
				 @TempRegList varchar(200),
				 @TempFacList varchar(200),
				 @TempLogout varchar(20),
				 @TempURL varchar(200)

		set @TempUsername = 'replace(uc.UserName,''' + @UserNamePrefix + ''' + ''_'','''')'
		set @TempDivList = '(select DivList from ' + @DBPath + 'fn_GetLists(uc.userid))'
		set @TempRegList = '(select RegList from ' + @DBPath + 'fn_GetLists(uc.userid))'
		set @TempFacList = '(select FacList from ' + @DBPath + 'fn_GetLists(uc.userid))'
		set @TempDeleteOnLogout = 'convert(bit,0)'
		set @TempDirectAccessURL = 'dbo.fn_MakeUrl(' + convert(varchar(1),@modeBit) + '
									,''' + @CompanyCode + ''', uc.UserId, ' + convert(varchar(1),@Logout) + ')'
	
		set @sql =
			'Insert Into #PageIndexForUsers(UserName,Email,CompanyId,FullName,User,RoleName,
						 DivList,RegList,FacList,Logout,URL)
			 select '+ @TempUsername +' as UserName,
					m.Email,
	  			    c.CompanyId,
					uc.FullName, 
					uc.User, 
					r.RoleName,
					'+ @TempDivList +' as DivList,
					'+ @TempRegList +' as RegList,
					'+ @TempFacList +' as FacList,
					'+ @TempLogout +' as Logout,
					'+ @TempURL +' as URL
			from ' + @Aspnet_Membership + ' m
					inner join ' + @User_Config + ' uc
						on uc.userid = m.userid
					inner join ' + @Company + ' c
						on c.CompanyCode = uc.CompanyCode
					inner join ' + @Aspnet_UsersInRoles + ' ur
						on ur.userid = uc.userid
					inner join ' + @Aspnet_Roles + ' r
						on r.RoleId = ur.RoleId
			where c.CompanyCode = ''' + @CompanyCode + '''
			'

		If @UserName is NOT NULL
			set @sql = @sql + ' and uc.UserName = ''' + @UserName + ''' order by uc.UserName '
		Else If @RoleName IS NOT NULL
			set @sql = @sql + ' and r.RoleName = ''' + @RoleName + ''' order by uc.UserName'
		Else
			set @sql = @sql + ' order by uc.UserName'	


		exec sp_executesql @sql

set @TempDivList = '(select DivList from ' + @DBPath + 'fn_GetLists(uc.userid))'
		set @TempRegList = '(select RegList from ' + @DBPath + 'fn_GetLists(uc.userid))'
		set @TempFacList = '(select FacList from ' + @DBPath + 'fn_GetLists(uc.userid))'