Dynamics Community Forum Thread Details

How do I determine total quantity of an assembly as well as total number of parts per assembly along with total number of parts sold but not with an assembly

I have a very large list of assemblies and have now determined how many of each there were. I now need to determine the total amount of parts per assembly and if there were any parts that were sold as spares and not part of an assembly. I have included an example. I am interested in doing with SQL if possible, but am open to any solution.

I am lost with this query, completely over whelmd on this one.

Finished Good			Description
K24-026-RCSC	PN	Qty per Assy	Mount, H24-6 w/adapter, H24/UPA/T&E, Sand CARC
	M98-027-SCAR	1.	Bracket Assembly, H24-5 to T&E, Sand CARC
	M98-026-SCAR	1.	Bracket, H24-5 to UPA, Sand CARC
	M24-956-SCAR	1.	Bracket, Adapter, ACH, 6-Hole, 7.62mm, Sand CARC
	M24-955-BLOX	1.	Block, Guide, Right, H24 Mount
	M24-954-BLOX	1.	Block, Guide, Left, H24 Mount
	M24-950-BLOX	1.	Block, Travel Lock, H24-6
	M24-901-SCAR	1.	Cradle Assy H24-5, Sand CARC
	M24-515-BLOX	1.	Train Lock Block, H24-3/-5/-6 (Rev A)
	M24-296-SLOT	1.	Pintle, H24, Slotted for use with Adapter, H24/UPA