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