SQL - How to multiply a value in tandem with a range (EXCEL) -
i'm working excel's odbc sql driver gather data our erp system. end goal have query return stockcodes range of bom's, , multiply qtyrequired field forecast value. so, select bom#21, list of bom's stockcodes & qtyrequired fields, multiply unitqtyrequired field x , same next item in range. using command text can retrieve stockcodes range of bom's: "select bom, stockcode, description, qtyunitrequired dbo.invmaster invmaster, dbo.invwarehouse invwarehouse (bom in (" & strvals & "))" i can't seem find solution multiply qtyunitrequired result number next each bom. range looks similar this: ex. bom|qty bom21|100 bom66|150 bom12|75 i think may need change approach , loop query through each value instead i'm not sure how this. any suggestions?