USE [AIADatabaseV5]
GO
/****** Object:  StoredProcedure [dbo].[usp_GetModestyForThisLicense]    Script Date: 09/26/2018 08:02:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- ====================================================  
-- Author:  Magic Software  
-- Create date: 29-Jan-2018  
-- Description: To get a license information on the basis of LicenseId  
-- ====================================================  
ALTER PROCEDURE [dbo].[usp_GetModestyForThisLicense]
 -- Add the parameters for the stored procedure here  
	 @licenseId int,
	 @editionId tinyint
AS  
BEGIN  

Select IsModesty from LicenseToEdition WHERE LicenseId = @licenseId and EditionId = @editionId
end