SELECT 		CASE soitem.fmultiple 
            		WHEN 1 then 
				(SELECT funetprice FROM sorels 
				WHERE (sorels.fsono = shmast.fcsono) 
				AND sorels.frelease 
				= SUBSTRING(shitem.fsokey,10,3) 
				AND sorels.fenumber 
				= shitem.fenumber) * shitem.fshipqty 
			ELSE 
				(SELECT top 1 funetprice FROM sorels 
				WHERE (sorels.fsono = shmast.fcsono)
				AND sorels.finumber 
				= soitem.finumber) * shitem.fshipqty 
		END as ExtPrice, 
		
		
		CASE CAST((shitem.fshipqty) as int) 
				% nullif(CAST(inmast.fnusrqty1 as int),0) 
            		WHEN 0 then 
				(CAST((shitem.fshipqty) as int) /
				nullif(CAST(inmast.fnusrqty1 as int),0)) 
            		ELSE 
				(CAST((shitem.fshipqty) as int) /
				nullif(CAST(inmast.fnusrqty1 as int),0)) + 1 
            	END as BoxCount 
            	
FROM 		shmast INNER JOIN shitem ON shmast.fshipno = shitem.fshipno 
            	INNER JOIN soitem ON (soitem.fsono = shmast.fcsono) 
		AND (Convert(Int,soitem.finumber) = Convert(Int,SUBSTRING(shitem.fsokey,8,10)) / 1000) 
            	LEFT JOIN somast ON (shmast.fcsono = somast.fsono) 
            	LEFT JOIN inmast ON (soitem.fpartno = inmast.fpartno) 
            	WHERE (shmast.fbl_lading='00000000000000003784')
		AND (shitem.fshipqty > 0) 

quote:

---

Originally posted by tkizer

You've edited your query in your post. So now you've got to remove those SUMs you just added in order for my solution to work.

---