Multiple column SQL pivot

Here is an example of a pivot query that will show up to 3 contractors and their address by projects These are the tables: Contactors ProjectContactors table SQL to pivot data and show contractors and address for the projects in one row of data: Here are the result when the query is executed:

Typescript Unit Testing using Jasmine and Chutzpah

I recently set up my Visual Studio 2015 environment so I could create unit tests for Typescript.   I am to blogging the steps I took, so I have a reference.  I am using Chutzpah as the test runner and Jasmine for unit testing. Step 1:  In Visual Studio 2015 go to Tools>>Extensions and Updates… Step […]