Here are some common queries from 360 Activate:
1. Pull list of Store Associate information by Program:
SELECT * FROM [QtraxCore].[Activate].[vContacts] C INNER JOIN [QtraxCore].[Activate].[vProgramLocations] PL ON C.PLID=PL.ProgramLocationID WHERE C.ProgramId IN ( SELECT ProgramID FROM [QtraxCore].[Activate].vPrograms WHERE ProgramName LIKE '%whirlpool%' AND isActive=1 ) AND C.isActive=1