Re: My SQL Query to find the status of the SKU items manufactured

[Peter Brawley]

The requirement is clearly laid out, but this sort of detailed business logic looks rather more like a contract job than a help question on a community forum.

How it's approached depends somewhat on what coding standards and conventions are in place in your organisation, but I would think the best approach would be to write a stored procedure---or a small cascade of them---so that database errors and business logic exceptions can be handled with a combination of GET DIAGNOSTICS, SIGNAL and DECLARE EXIT HANDLER FOR SQLEXCEPTION.