declare @intpos int declare @intuser int declare @dtlastpost varchar(30) set @intuser = (select userid from [$dbname].[dbo].[users] where [name] = '$user') set @intpos = (select top 1 permissionid from [$dbname].[dbo].[security] where [userid] = @intuser order by permissionid desc) set @dtlastpost = (SELECT top 1 [PostDate] FROM [$dbname].[dbo].[Messages] where userid = @intuser order by postdate desc )