I have a UNIONED view with the following fields/data:
TrainingDate: Trainee: TotalHours: SubDept:
1/1/2104 John 6.5 Milling
1/1/2014 John 2 Nailing
1/1/2014 Jill 7.5 Nailing
1/2/2014 Jill 4.5 Doors
1/2/2014 John 7.5 Doors
I need the view with this result set:
Training Date: Trainee: Milling: Nailing: Doors:
1/1/2014 John 6.5 2 0
1/1/2014 Jill 0 7.5 0
1/2/2014 Jill 0 0 4.5
1/2/2014 John 0 0 7.5
For every 'department' I would like it as a field (I believe pivot/unpivot works but I can't figure out the syntax) and for every date and trainee, there is an individual line item that shows the totals of the hours worked for that day/trainee.
Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.
by Mark Wills
Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server... So if you are the accidental DBA, or, simp…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online.
The email signature template has been downloaded from: