Hi There!I wrote the below case statement. But it is not giving the required results. I WANT 93,855 BUT I'M GETTING 938.5566666666666666666 like this.  (SELECT CASE (MAIN.RECEIPT+MAIN.ISSUE) WHEN 0 THEN 0.0 ELSE MAIN.AMOUNT/(MAIN.RECEIPT+MAIN.ISSUE) ...

Hi There!I wrote this query to achieve the attached output... But it is giving me improper/duplicated results. The data have 464 rows but i'm getting 1008 rows. Kindly let me know what mistake I made in the join conditions.  Thanks in advance. select...

Hi There!Can anyone plz let me know the table and field name for BALANCE QUANTITY in SAP.

Hi Guys,Can anyone tell me the receipt and issue field names and from which table I can get those? Actually, I've a requirement to replicate the SAP output in the DB I don't know about SAP. However, I need tables and fields to replicate the output in...