SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[usp_DeleteLicenseUserGroup]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[usp_DeleteLicenseUserGroup]
GO

-- ====================================================  
-- Author:  Magic Software  
-- Create date: 14-Feb-2018  
-- Description: To insert or update a user group users of a license
-- ====================================================  
create PROCEDURE [dbo].[usp_DeleteLicenseUserGroup] 
	-- Add the parameters for the stored procedure here
	@UserGroupId int, @Status bit out
AS
BEGIN
SET NOCOUNT ON;  

 set @Status = 0;  
 BEGIN TRY  
  BEGIN TRANSACTION  

		delete from UserGroupToAIAUser where UserGroupId = @UserGroupId;
		delete from UserGroup where Id = @UserGroupId;

  COMMIT TRANSACTION  
  set @Status = 1;  
 END TRY  
 BEGIN CATCH  
  IF @@TRANCOUNT > 0  
   ROLLBACK TRANSACTION  
 END CATCH  
  
END  

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO