Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
USE [CtsiMembershipProduction] GO IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CtsiApplication]') AND type in (N'U')) DROP TABLE CtsiApplication --IF EXISTS(SELECT CtsiApplication FROM INFORMATION_SCHEMA.TABLES -- WHERE TABLE_NAME = 'CtsiApplication') GO /****** Object: StoredProcedure [dbo].[GetData] Script Date: 10/16/2008 19:21:43 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO Create PROCEDURE [dbo].[Ctsi_GetData] AS SELECT [dbo].[Applications].[Id] ,[MembershipLevel] ,[ProfessionalOrganizations] ,[Department] ,[Gender] ,[Ethnicity] ,[Race] ,[YearOfBirth] ,[Title_id] ,[dbo].[Applications].[EmailAddress] ,[LastName] ,[Firstname] ,[PhoneNumber] ,[Institution] ,[MailingAddress] ,[OfficeAddress] ,[TitleOther] ,[PhdTraineeCount] ,[MscTraineeCount] ,[InstitutionOther] ,[MembershipReasonOther] ,[RaceOther] ,[MailingAddressLine1] ,[MailingAddressLine2] ,[MailingAddressCity] ,[MailingAddressState] ,[MailingAddressZip] ,[CommunityOrganization] , tblDegrees.Name as [Degree 1] , dbo.ApplicationResearchInterests.ResearchInterestId as RchChildId--child Rch id , dbo.MembershipReasons.Name as [Membership Reason 1] , dbo.MembershipServiceRequirements.Name as [Membership Service Requirement 1] INTO CtsiApplication FROM dbo.ApplicationDegrees, dbo.[Degrees] as tblDegrees, dbo.ApplicationMembershipReasons, dbo.ApplicationMembershipServiceRequirements, dbo.ApplicationResearchInterests, dbo.ResearchInterests as tblRschInt, dbo.MembershipReasons, dbo.MembershipServiceRequirements, [dbo].[Applications] inner join (SELECT min([Id]) AS Id, [EmailAddress] from [dbo].[Applications] group by [EmailAddress]) AS B ON B.Id = [dbo].[Applications].Id --filter our duplicate email address record, get the lowest id Where dbo.Applications.Id = dbo.ApplicationDegrees.ApplicationId and dbo.Applications.Id = dbo.ApplicationMembershipReasons.ApplicationId and dbo.Applications.Id = dbo.ApplicationMembershipServiceRequirements.ApplicationId and dbo.Applications.Id = dbo.ApplicationResearchInterests.ApplicationId and dbo.ApplicationDegrees.ApplicationId = tblDegrees.Id --Get degree name and dbo.ApplicationMembershipReasons.MembershipReasonId = dbo.MembershipReasons.Id and dbo.ApplicationMembershipServiceRequirements.MembershipServiceRequirementId = dbo.MembershipServiceRequirements.Id
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Query - Duplicate dates with different activities counts||10||59|
|MSSQL join different row from other table||14||84|
|SQL Query Works in SQL 2008 & 2012 But Not SQL 2016||15||101|
|Creating a View from a CTE||15||50|
Join the community of 500,000 technology professionals and ask your questions.