| INSERT into [&DashboardSchema].DashboardMonthlySummary_ChargeLag_ChargePostDate( | |
| encounterSK | |
| ,DatePostChargeSK | |
| ,dashDatePeriod | |
| ,ChargeLag_Actual | |
| ,providerBillingSK | |
| ,providerServiceSK | |
| ,PlaceOfService | |
| ,CPTClass | |
| ,reportGroupSK |
Most Exciting (in no particular order):
Less Exciting (in no particular order):
| var request = require('request'), | |
| username = '', | |
| password = '', | |
| url = 'http://company.mingle.thoughtworks.com/api/v2/projects/datariver/cards/execute_mql.json', | |
| auth = 'Basic ' + new Buffer(username + ':' + password).toString('base64'); | |
| var options = { | |
| method: 'GET', | |
| url: url, | |
| qs: { |
| # Docker file to build a CentOS LAMP Stack | |
| # (CentOS and Apache latest versions, PHP 5.6.16, mssql, freetds and wktmltopdf) | |
| FROM centos:latest | |
| MAINTAINER Marco Ramos <mramos29@sapo.pt> | |
| # Environment Variables | |
| # Install essential packages |
| <?php | |
| setcookie('sptfrUser', 'eqc\gortiz'); | |
| ?> | |
| <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" | |
| "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> | |
| <html xmlns="http://www.w3.org/1999/xhtml"> | |
| <head> | |
| <title>API Scenario</title> |
| SELECT current, | |
| avg(monthsTenure) as monthsTenure | |
| FROM UtahAgencyEmployees | |
| WHERE current != '' AND monthsTenure < 73 | |
| GROUP BY current | |
| HAVING count(*) > 2 | |
| ORDER BY monthsTenure DESC | |
| LIMIT 20 |
| SELECT education AS School, | |
| count(education) AS Employees | |
| FROM UtahAgencyEmployees | |
| WHERE education != '' | |
| GROUP BY education | |
| ORDER BY Employees DESC | |
| LIMIT 20 |
| SELECT latest_education_major AS Major, | |
| count(latest_education_major) AS Employees | |
| FROM UtahAgencyEmployees | |
| WHERE latest_education_major != '' | |
| GROUP BY latest_education_major | |
| ORDER BY Employees DESC | |
| LIMIT 20 |
| SELECT skill, | |
| count(*) as count | |
| FROM EmployeeSkills | |
| WHERE skill != '' | |
| GROUP BY skill | |
| ORDER BY Count DESC | |
| Limit 20 |
| SELECT current AS Agency, | |
| (count(current)/37*100) AS Percent | |
| FROM UtahAgencyEmployees | |
| WHERE latest_education_major = 'Graphic Design' | |
| GROUP BY current | |
| ORDER BY Percent DESC | |
| LIMIT 20 |