Hi Paul,

The following chunk of code worked fine for me.

CREATE TABLE CaseDetail (CaseId INT IDENTITY(1,1), QTY NUMERIC(14,4), weightedQty NUMERIC(14,4), ShipmentId INT)

--We assume that these cases belongs to Shipment with id 1

DECLARE @count INT

SET @count =15000

WHILE (@count >0)

BEGIN

INSERT INTO CaseDetail VALUES(200,300,1)

SET @count = @count -1

END

select count(caseid) from CaseDetail

Thank you and have a nice day,

Sreeju