The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.
select hhicusn, hhiclsn, (CASE HHICRDC WHEN 'DAM' THEN sum(hhiexsg) end) as DAM, (CASE HHICRDC WHEN 'CON' THEN sum(hhiexsg) end) as CON, (CASE HHICRDC WHEN 'MIS' THEN sum(hhiexsg) end) as MIS from pwrdta.hhiorddp where hhifspd in ( 1, 2, 3) and hhifsyr = 2017 and hhicrin = 'Y' and hhiclsn in (' 1', ' 2', ' 3', ' 4', ' 5', ' 6', ' 7', ' 8', ' 9', ' 10', ' 12', ' 13', ' 30', ' 31') and hhicrdc in ('DAM', 'CON', 'MIS') group by hhicusn, hhiclsn, hhicrdc order by hhicusn, hhiclsn
|Exporting image to excel from php document||10||28|
|Help with query||3||25|
|MS SQL tables, .net application and ETL connundrum||3||55|
|Please help with the below query - SQL Server||11||18|