Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.
INSERT INTO AG([GName],AG) SELECT DISTINCT AGmembership.[GName], AGmembership.AG FROM AGmembership LEFT OUTER JOIN ActiveAGs ON AGmembership.[GName] = ActiveAGs.[GName] AND AGmembership.AG = ActiveAGs.AG WHERE (ActiveAGs.[GName] IS NULL) AND (ActiveAGs.AG IS NULL)
SELECT [GName], AG, Status FROM dbo.AG WHERE (Status = 'Active')
Join the community of 500,000 technology professionals and ask your questions.