Transact SQL
Interacting with the data and being able to answer the questions based on the information stored in the database is a must have skill for the digital era engineers. Below I'm presenting a data manipulation routine I created a while ago. This script is dealing with the inputs from the night shift operators breaking down activities which span over two days into two separate transactions.
The example below enables integration of the tooling database table with the front end used by the suppliers to enter a key characteristic of the produced tooling. The challenge during the database design was to create a table which will hold a data for the various tools. The description of characteristic is translated into a generic column name used for a given characteristic and tool allowing for the user input to be stored correctly.
Procedure to create a simple report which is triggering a maintenance routine to service production equipment based on the duration of the specific downtime declared by operators.