SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table junk(
	INVHDRBATCH varchar(15),
	FGBATCH varchar(15),
	FG decimal(20,10),
	FGMAT decimal(20,10),
	FGLABOR decimal(20,10),
	FGOH decimal(20,10),
	FGCOST decimal(20,10),
	FGWEIGHT decimal(20,10),
	MATLB decimal(20,10),
	LABORLB decimal(20,10),
	OHLB decimal(20,10),
	Component varchar(15),
	LOT varchar(15),
	LOTQTY decimal(20,10),
	LOTMATUNITCOST decimal(20,10),
	LOTMATWIPCOST decimal(20,10),
	LOTLABORWIPCOST decimal(20,10),
	LOTOHWIPCOST decimal(20,10)
);

insert into junk values('50418G12D','50418G12D',506,15425.19,277.21,1386.06,17088.46,2381.4,6.477362056,0.116406316,0.582035777,'1355','318061311',37,1.96,72.39,0,0);
insert into junk values('50418G12D','50418G12D',506,15425.19,277.21,1386.06,17088.46,2381.4,6.477362056,0.116406316,0.582035777,'1360','52218',54,1.42,76.76,0,0);
insert into junk values('50418G12D','50418G12D',506,15425.19,277.21,1386.06,17088.46,2381.4,6.477362056,0.116406316,0.582035777,'1370','42418',54,1.17,63.15,0,0);
insert into junk values('50418G12D','50418G12D',506,15425.19,277.21,1386.06,17088.46,2381.4,6.477362056,0.116406316,0.582035777,'1880','115021-0618',1056,0.55,575.52,0,0);
insert into junk values('50418G12D','50418G12D',506,15425.19,277.21,1386.06,17088.46,2381.4,6.477362056,0.116406316,0.582035777,'506N','506N418G06A-40',344,9.35,3215.37,40.04,200.22);
insert into junk values('50418G12D','50418G12D',506,15425.19,277.21,1386.06,17088.46,2381.4,6.477362056,0.116406316,0.582035777,'506N','506N518D18C-18',582,9.35,5439.95,67.75,338.74);
insert into junk values('50418G12D','50418G12D',506,15425.19,277.21,1386.06,17088.46,2381.4,6.477362056,0.116406316,0.582035777,'506N','506N518G07C-05',308,9.35,2878.88,35.85,179.27);
insert into junk values('50418G12D','50418G12D',506,15425.19,277.21,1386.06,17088.46,2381.4,6.477362056,0.116406316,0.582035777,'506N','506N518G07C-09',332,9.35,3103.2,38.65,193.24);
--NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1.520689655

8 rows affected

INVHDRBATCH	FGBATCH	FG	FGMAT	YIELD
50418G12D	50418G12D	506.0000000000	15425.19	1.520689655172413793