dbo.GetLicenseBySiteId.StoredProcedure.sql
3.17 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
USE [AIADatabaseV5]
GO
/****** Object: StoredProcedure [dbo].[GetLicenseBySiteId] Script Date: 2/1/2018 12:15:55 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetLicenseBySiteId]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[GetLicenseBySiteId]
GO
CREATE PROCEDURE [dbo].[GetLicenseBySiteId]
-- Add the parameters for the stored procedure here
@sSiteId int
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
SELECT distinct License.AccountNumber, License.AccountTypeId, License.Address1,
License.Address2, License.City, License.CountryId, License.CreationDate,
License.EmailId, License.Id, License.InstitutionName, License.IsActive,
License.IsDistrictSiteLicense, License.IsTermsAccepted, License.LicenseTypeId,
License.LicenseeFirstName, License.LicenseeLastName, License.ModifiedDate,
License.NoOfRenewals, License.Phone, License.StateId, License.TotalLogins,
License.Zip, SiteToLicenseEdition.IsModesty FROM License INNER JOIN LicenseToEdition
ON License.Id = LicenseToEdition.LicenseId
INNER JOIN SiteToLicenseEdition
ON LicenseToEdition.Id = SiteToLicenseEdition.LicenseEditionId
INNER JOIN Site ON SiteToLicenseEdition.SiteId = Site.Id
WHERE Site.Id = @sSiteId
END
GO