Hi, I have a table name as "MasterInComingData", where i receive all kind of data from my machinery, Table design as follows:-
Column Name DataType
No int (primary key)
My questions is, how to segregate in programmability in MSSQL 2005. Upon data receive in "MasterInComingData". I wanted to segregate the data into a table "Alarm" and "Temp".
Where "Alarm" table get data from "MasterInComingData" only the MachineNo, TimeRec and Alarm.
For Temp table get data from "MasterInComingData" only the MachineNo, TimeRec and Temp.
how to do in program method in MSSQL 2005.