ALTER PROCEDURE [dbo].[HasPermission] 
	@mem_id INT,
	@perm_type VARCHAR(25),
	@perm_name VARCHAR(25)

AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
	
	SELECT 1 FROM dbo.group_permissions a WHERE  
		EXISTS
		(
			SELECT group_id FROM dbo.group_members b WHERE b.mem_id = @mem_id AND
			b.group_id =a.group_id 
		) AND
		EXISTS
		(
			SELECT perm_id FROM dbo.permissions c WHERE c.perm_type = @perm_type AND c.perm_name = @perm_name
			AND c.perm_id = a.perm_id
		);

/*
2  = can edit posts
4  = can move posts
8  = can delete posts
16 = can ban users
*/

DECLARE @permissions int

DECLARE @edit_posts   bit
      , @move_posts   bit
      , @delete_posts bit
      , @ban_users    bit
      
SET @edit_posts   = 0
SET @move_posts   = 1
SET @delete_posts = 0
SET @ban_users    = 1

SET @permissions = Power(2 * @edit_posts  , 1)
                 + Power(2 * @move_posts  , 2)
                 + Power(2 * @delete_posts, 3)
                 + Power(2 * @ban_users   , 4)

PRINT @permissions 

IF 2  & @permissions = 2  PRINT 'Can Edit Posts' 
IF 4  & @permissions = 4  PRINT 'Can Move Posts' 
IF 8  & @permissions = 8  PRINT 'Can Delete Posts' 
IF 16 & @permissions = 16 PRINT 'Can Ban Users'