You have some columns that seem to be repeated in different tables such as DeptCode or MaterialName.
There aren't many to many relationships between two tables, you need to create...

Please disregard Joe Celko's rant. His design, although theorically correct, miss the physical design considerations. Using a CHAR(10) would add 6 bytes of storage to each row on Personnel and...

Here's an option on how to do it.
You might want to check the following articles to understand what's happening in the code and to get the function used.

There's another way, but as mentioned before, it's not completely necessary to avoid a cursor in this case.
Here's an example and a link on how to do it.

Here's another option. I hope that it helps.

SELECT t.ID,
  MAX( CASE WHEN d.RowNo = 1 THEN d.Description END) AS Desc1,
  SUM( CASE WHEN d.RowNo...

You probably need to do this in 2 steps.
First you need to split the values as shown here: http://www.sqlservercentral.com/articles/Tally+Table/72993/
Then you would need to transpose the rows...

This might work for a single read on the Contacts table, but I can't guarantee any improvement or even correctness.

SELECT S.Id,
 T.Id,
 SAC.Contacts_Id AS AssignedContacts_Id,

My preferred option is to add the character at the end of the string so it won't ever be 0.
DECLARE @Failed TABLE(
MachineNAme varchar(100))
INSERT INTO @Failed