It is close. Had to remove TEXTIMAGE ON for the Parts table. That wasn't to big a deal.
The WOParts table just doesn't work well. You defined the primary key as WONo, EntryDate and there are dozens and dozens of duplicates. The best thing you can do is to test out your scripts in a test database.
Once you get the data sorted out we still need to know what you expect as output based on your sample data (this is another reason to keep the amount of sample limited as much as possible).
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/