Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
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.
--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)
|SQL Server 2012 r2 - Calulations within stored procedure involving temp tables||6||40|
|Sum particular field in database||2||16|
|Finding gaps or missing dates in a date range using TSQL||3||24|