UPDATE BV_W001S SET
D1U=W1U1,D2U=W2U1,D3U=W3U1,D4U=W4U1,D5U=W5U1,D6U=W6U1,D7U=W7U1,D8U=W8U1
,D1M=W1M1,D2M=W2M1,D3M=W3M1,D4M=W4M1,D5M=W5M1,D6M=W6M1,D7M=W7M1,D8M=W8M1
,D1D=W1D2,D2D=W2D2,D3D=W3D2,D4D=W4D2,D5D=W5D2,D6D=W6D2,D7D=W7D2,D8D=W8D2
WHERE
SSID = 'i5ro7ik1jpi78xvocf78u4sd840i3z68'
AND JOBNO = 0

UPDATE BV_W001S SET


D1D=CASE WHEN D1D=0 THEN 0 ELSE D1U/D1D*100 END,D2D=CASE WHEN D2D=0 THEN 0 ELSE D2U/D2D*100 END,D3D=CASE WHEN D3D=0 THEN 0 ELSE D3U/D3D*100 END,D4D=CASE WHEN D4D=0 THEN 0 ELSE D4U/D4D*100 END,D5D=CASE WHEN D5D=0 THEN 0 ELSE D5U/D5D*100 END,D6D=CASE WHEN D6D=0 THEN 0 ELSE D6U/D6D*100 END,D7D=CASE WHEN D7D=0 THEN 0 ELSE D7U/D7D*100 END,D8D=CASE WHEN D8D=0 THEN 0 ELSE D8U/D8D*100 END
WHERE
SSID = 'i5ro7ik1jpi78xvocf78u4sd840i3z68'
AND JOBNO = 0

UPDATE BV_W001S SET
C1U=NVL (GET_COLOR_NO('001',1,0,D1U),509),CW1U=NVL (GET_COLOR_CODE('001',1,0,D1U),' '),C2U=NVL (GET_COLOR_NO('001',1,0,D2U),509),CW2U=NVL (GET_COLOR_CODE('001',1,0,D2U),' '),C3U=NVL (GET_COLOR_NO('001',1,0,D3U),509),CW3U=NVL (GET_COLOR_CODE('001',1,0,D3U),' '),C4U=NVL (GET_COLOR_NO('001',1,0,D4U),509),CW4U=NVL (GET_COLOR_CODE('001',1,0,D4U),' '),C5U=NVL (GET_COLOR_NO('001',1,0,D5U),509),CW5U=NVL (GET_COLOR_CODE('001',1,0,D5U),' '),C6U=NVL (GET_COLOR_NO('001',1,0,D6U),509),CW6U=NVL (GET_COLOR_CODE('001',1,0,D6U),' '),C7U=NVL (GET_COLOR_NO('001',1,0,D7U),509),CW7U=NVL (GET_COLOR_CODE('001',1,0,D7U),' '),C8U=NVL (GET_COLOR_NO('001',1,0,D8U),509),CW8U=NVL (GET_COLOR_CODE('001',1,0,D8U),' ')
,C1M=NVL (GET_COLOR_NO('001',3,0,D1M),509),CW1M=NVL (GET_COLOR_CODE('001',3,0,D1M),' '),C2M=NVL (GET_COLOR_NO('001',3,0,D2M),509),CW2M=NVL (GET_COLOR_CODE('001',3,0,D2M),' '),C3M=NVL (GET_COLOR_NO('001',3,0,D3M),509),CW3M=NVL (GET_COLOR_CODE('001',3,0,D3M),' '),C4M=NVL (GET_COLOR_NO('001',3,0,D4M),509),CW4M=NVL (GET_COLOR_CODE('001',3,0,D4M),' '),C5M=NVL (GET_COLOR_NO('001',3,0,D5M),509),CW5M=NVL (GET_COLOR_CODE('001',3,0,D5M),' '),C6M=NVL (GET_COLOR_NO('001',3,0,D6M),509),CW6M=NVL (GET_COLOR_CODE('001',3,0,D6M),' '),C7M=NVL (GET_COLOR_NO('001',3,0,D7M),509),CW7M=NVL (GET_COLOR_CODE('001',3,0,D7M),' '),C8M=NVL (GET_COLOR_NO('001',3,0,D8M),509),CW8M=NVL (GET_COLOR_CODE('001',3,0,D8M),' ')
,C1D=NVL (GET_COLOR_NO('001',8,1,D1D),509),CW1D=NVL (GET_COLOR_CODE('001',8,1,D1D),' '),C2D=NVL (GET_COLOR_NO('001',8,1,D2D),509),CW2D=NVL (GET_COLOR_CODE('001',8,1,D2D),' '),C3D=NVL (GET_COLOR_NO('001',8,1,D3D),509),CW3D=NVL (GET_COLOR_CODE('001',8,1,D3D),' '),C4D=NVL (GET_COLOR_NO('001',8,1,D4D),509),CW4D=NVL (GET_COLOR_CODE('001',8,1,D4D),' '),C5D=NVL (GET_COLOR_NO('001',8,1,D5D),509),CW5D=NVL (GET_COLOR_CODE('001',8,1,D5D),' '),C6D=NVL (GET_COLOR_NO('001',8,1,D6D),509),CW6D=NVL (GET_COLOR_CODE('001',8,1,D6D),' '),C7D=NVL (GET_COLOR_NO('001',8,1,D7D),509),CW7D=NVL (GET_COLOR_CODE('001',8,1,D7D),' '),C8D=NVL (GET_COLOR_NO('001',8,1,D8D),509),CW8D=NVL (GET_COLOR_CODE('001',8,1,D8D),' ')
WHERE
SSID = 'i5ro7ik1jpi78xvocf78u4sd840i3z68'
AND JOBNO = 0