Here is one that use partitions:

USE AdventureWorks2012;

GO

SELECT SalesOrderID, ProductID, OrderQty

,SUM(OrderQty) OVER(PARTITION BY SalesOrderID) AS Total

,CAST(1. * OrderQty / SUM(OrderQty) OVER(PARTITION BY SalesOrderID)...