Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.
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
|Need help with fine tuning the windows batch script to change password||9||23|
|Correct Thousand and decimal separator in sql server 2008||3||18|
|SQL Pivot add row totals||2||13|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
21 Experts available now in Live!