-- ================================================ -- Template generated from Template Explorer using: -- Create Procedure (New Menu).SQL -- -- Use the Specify Values for Template Parameters -- command (Ctrl-Shift-M) to fill in the parameter -- values below. -- -- This block of comments will not be included in -- the definition of the procedure. -- ================================================ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: -- Create date: <07/17/2017> -- Description: -- ============================================= CREATE PROCEDURE GetSubscriptionDetailsByLicenseId -- Add the parameters for the stored procedure here @iLicenseId INT AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT OFF; -- Insert statements for procedure here SELECT Id, LicenseId, SubscriptionPlanId, SubscriptionValidFrom, SubscriptionValidThrough, RenewalDate, PaymentMode, TotalAmount, AmountPaid, AmountPending,NoofImages FROM LicenseSubscriptionDetail WHERE (LicenseId = @iLicenseId) END GO