ds_SnowSports
query
RESULTSET
query
  CELLPHONE EMAIL EMPID EMPSTATUS FNAME HIREDATE HOMEPHONE LNAME MNAME NICKNAME PRIMECERTNAME PRIMEDIS PSIAAASICURRENT SECONDCERTNAME SECONDDIS
1 777-777-4444 [empty string] 0 PT 30 bob 2024-01-10 00:00:00.0 [empty string] smith [empty string] [empty string] Level 1 Snowboard 1 Level 1 Telemark
2 [empty string] [empty string] 1 PT 16 steve [empty string] [empty string] sams [empty string] [empty string] Level 2 Alpine 0 Level 2 [empty string]
3 [empty string] [empty string] 2 Flex 12 larry [empty string] [empty string] toms [empty string] [empty string] [empty string] Telemark 1 Level 0 Adaptive
4 [empty string] [empty string] 3 [empty string] Michael [empty string] [empty string] Atwater [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string]
5 [empty string] [empty string] 4 [empty string] Deb [empty string] [empty string] Bee [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string]
6 [empty string] [empty string] 5 [empty string] Rachel [empty string] [empty string] Frew [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string]
7 801-547-2601 atwatertrucking@gmail.com 9 [empty string] Michael [empty string] [empty string] Atwater [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string]
8 801-547-2601 atwatertrucking@gmail.com 10 [empty string] Michael [empty string] [empty string] Atwater [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string]
9 801-547-2601 atwatertrucking@gmail.com 11 [empty string] Michael [empty string] [empty string] Atwater [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string]
10 801-940-7484 dbee0624@hotmail.com 12 [empty string] Deb [empty string] [empty string] Bee [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string]
11 801-821-6033 thefrews2006@gmail.com 13 [empty string] Rachel [empty string] [empty string] Frew [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string]
12 801-547-2601 atwatertrucking@gmail.com 14 [empty string] Michael [empty string] [empty string] Atwater [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string]
13 801-940-7484 dbee0624@hotmail.com 15 [empty string] Deb [empty string] [empty string] Bee [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string]
14 801-821-6033 thefrews2006@gmail.com 16 [empty string] Rachel [empty string] [empty string] Frew [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string]
CACHED false
EXECUTIONTIME 26
SQL SELECT employee.empId, employee.fName, employee.mName, employee.lName, employee.nickName, employee.email, employee.cellphone, employee.homePhone, employee.hireDate, employee.psiaAasiCurrent, cert.certName as primeCertName, disipline.disipline as primeDis, employeeStatus.empStatus, c.certName as secondCertName, d.disipline as secondDis FROM employee left join cert on employee.primaryDisCertID = cert.certId left join disipline on employee.primaryDisiplineID = disipline.disID left join employeeStatus on employee.empStatusID = employeeStatus.empStatusID left join cert as c on employee.secondaryDisCertID = c.certID left join disipline as d on employee.secondaryDisiplineID =d.disID
NAME STATUSCELL PHONE HOME PHONE EMAILPRIMARY CERTSECONDARY CERTPSIA CURRENT
bob  smithPT 30777-777-4444 Snowboard Level 1Telemark Level 11
steve  samsPT 16 Alpine Level 2 Level 20
larry   tomsFlex 12 Telemark Adaptive Level 01
Michael  Atwater   
Deb  Bee   
Rachel  Frew   
Michael  Atwater801-547-2601 atwatertrucking@gmail.com  
Michael  Atwater801-547-2601 atwatertrucking@gmail.com  
Michael  Atwater801-547-2601 atwatertrucking@gmail.com  
Deb  Bee801-940-7484 dbee0624@hotmail.com  
Rachel  Frew801-821-6033 thefrews2006@gmail.com  
Michael  Atwater801-547-2601 atwatertrucking@gmail.com  
Deb  Bee801-940-7484 dbee0624@hotmail.com  
Rachel  Frew801-821-6033 thefrews2006@gmail.com