USE [nominals] GO set dateformat ymd select * from ( select distinct account_title, (tran_amount + vat_amount) as total,project_code from nominalsview where managerid = 1052 and tran_date between '2013-04-01' and '2014-03-31' ) x pivot ( sum(total) for project_code in (CORP1, EMP01, FAC01, FAM01, FIN01, FIR01, MAR01, MAT01, MUN01, PLA01, PRIV1, PRO01, PRO02, REC01, REP01, RES01, ADMIN, CON01, COR01, HR001, IT001, LIT01, MIS01, PI001, PRF01, PRL01, PROP1, SSD01, TAX01, TRA01, TRU01) ) p;
|IIS Server infected with Ransomware - Postmortem investigation||12||133|
|Returning data in a different format||8||46|
|Upgrading an old legacy SQL server 20082 to 2014 - TSQL compatibility||3||37|
|Adding Subtracting values in sql server||5||19|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
21 Experts available now in Live!