Learn how Concerto can help you.
--And now we're ready to put it all into one big table SELECT a.Id ,a.MembershipLevel ,a.ProfessionalOrganizations ,a.Department ,a.Gender ,a.Ethnicity ,a.Race ,a.YearOfBirth ,a.Title_id ,a.EmailAddress ,a.LastName ,a.Firstname ,a.PhoneNumber ,a.Institution ,a.MailingAddress ,a.OfficeAddress ,a.TitleOther ,a.PhdTraineeCount ,a.MscTraineeCount ,a.InstitutionOther ,a.MembershipReasonOther ,a.RaceOther ,a.MailingAddressLine1 ,a.MailingAddressLine2 ,a.MailingAddressCity ,a.MailingAddressState ,a.MailingAddressZip ,a.CommunityOrganization ,C.[Degree 1] ,D.[Membership Reason 1] ,E.[Membership Service Requirement 1] ,F.parentId as RchChildId--child Rch id INTO CtsiApplication FROM dbo.Applications a INNER JOIN dbo.Temp B on a.Id = B.tempId FULL JOIN dbo.CtsiDegree C on a.Id = C.ApplicationId FULL JOIN dbo.CtsiReasons D on a.Id = D.ApplicationId FULL JOIN dbo.CtsiRequirement E on a.Id = E.ApplicationId INNER JOIN dbo.CtsiRschInterest F on a.Id = F.ApplicationId ORDER BY a.Id GO DELETE FROM [CtsiMembershipProduction].[dbo].CtsiApplication WHERE [CtsiMembershipProduction].[dbo].CtsiApplication.Id IS NULL --some other code before this --Add the 4 Interest fields ALTER TABLE CtsiApplication ADD [Research Interest 1] VARCHAR(50) ALTER TABLE CtsiApplication ADD [Research Interest 2] VARCHAR(50) ALTER TABLE CtsiApplication ADD [Research Interest 3] VARCHAR(50) ALTER TABLE CtsiApplication ADD [Research Interest 4] VARCHAR(50)
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.