fnPrime




<< Back to Facilities Management Building Automation Category Home

NFMT certificate

Key topics for facility professionals. Keywords for this topic:

Select Distinct at.Email, at.FirstName, at.LastName, at.SessionID, sh.showname, s.title, s.ceuLink, sh.Startdate from attendees at left join session s on at.SessionID = s.sessionid left join show sh on s.showid = sh.showid where at.Email = @EMAIL and sh.showid = @SHOWID Order by sh.startdate desc @@@@@ Select Distinct at.Email, at.FirstName, at.LastName, at.SessionID, sh.showname, s.title, s.ceuLink, sh.Startdate from attendees at left join session s on at.SessionID = s.sessionid left join show sh on s.showid = sh.showid where at.Email = @EMAIL and sh.enddate >= DATEADD(YEAR, -2, GETDATE()) Order by sh.startdate desc