Comments by Rajath Savanth (Top 3 by date)

Rajath Savanth 18-Sep-24 8:15am View

Richard. Sorry it was my mistake. Your solution works like a charm. Thank you so much. You are amazing.

Rajath Savanth 18-Sep-24 7:59am View

Ah ok.
Then here is an example of the data -

ALLOCATED_QTY LENGTH RESULT
6 0.03234 0.19404
5 0.145 0.725

It's basically
6 * 0.03234 = 0.19404

And data_type of CBM_Out column is DECIMAL. Please let me know if you need any more info.
Thanks

Rajath Savanth 18-Sep-24 7:28am View

Hi Richard, thanks for the reply. I did try the query provided by you. But I am not getting the expected result in my CBM_Out column. For a better understanding, I just ran the select query and provided the result of the same V/S the result I am getting after replacing the query with yours.

Expected result -
DATE_TIME_STAMP COMPANY WAREHOUSE (No column name) CBM_Out (No column name) BRANCH IP_ADDRESS INTERNAL_SHIPMENT_NUM
2024-09-18 11:04:14.510 Federal Foods G NULL 0.0336400000 NULL DIC Federal Foods-Grp 11254624
2024-09-18 11:04:14.713 Federal Foods G NULL 0.9082800000 NULL DIC Federal Foods-Grp 11254624
2024-09-18 11:04:14.727 Federal Foods G NULL 0.9923800000 NULL DIC Federal Foods-Grp 11254624

Current result -
Trans_Date Company Warehouse CBM_In CBM_Out Total_CBM Branch Group_Company ISN
2024-09-18 11:04:14.510 Federal Foods G NULL 0 NULL DIC Federal Foods-Grp 11254624
2024-09-18 11:04:14.713 Federal Foods G NULL 1 NULL DIC Federal Foods-Grp 11254624
2024-09-18 11:04:14.727 Federal Foods G NULL 1 NULL DIC Federal Foods-Grp 11254624

The column CBM_out is actually decimal values which is a result of multiplication seen above in the select query.
It would be really helpful if you could help me get this resolved. Thanks