Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.
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;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Using a SUBQUERY for the set variable||10||30|
|sql server query||9||27|
|SQL CAST in a Where Statement--that deals with non-numeric entries||3||24|
|Sql group by orderdate and ordertotal||3||12|
Join the community of 500,000 technology professionals and ask your questions.