smuthcrmnl777
Technical User
I have a unit that will start off with zero or close to zero lbs and when it completes there will be either 1500 lbs or 2000 lbs. During the time it's weight is growing there are things that could go wrong and make the unit stop growing. This is indicated by either a Slow Stop or a Fast Stop. For every unit there is at least one Line_Start and one End of Reel. I need to separate this data and give each unit a number so I can easily call on this data. Can someone give me an idea of how to build a stored procedure to look at this data and then name the unit? Below is what the data looks like in an SQL table.
Code:
tRSSQL_TRANS nWEIGHT bLINE_START bSLOW_STOP bFAST_STOP bEND_OF_REEL nLINE
6/9/2006 0:58 0 1 0 0 0 1
6/9/2006 0:58 0 0 1 0 0 1
6/9/2006 0:59 2 1 0 0 0 1
6/9/2006 1:00 21 0 0 1 0 1
6/9/2006 1:02 25 1 0 0 0 1
6/9/2006 2:10 1140 0 1 0 0 1
6/9/2006 2:14 1144 1 0 0 0 1
6/9/2006 2:16 1178 0 0 1 0 1
6/9/2006 2:20 1182 1 0 0 0 1
6/9/2006 2:41 1517 0 1 0 1 1
***************************************************************************************
6/9/2006 2:43 0 1 0 0 0 1
6/9/2006 2:44 10 0 1 0 0 1
6/9/2006 2:48 16 1 0 0 0 1
6/9/2006 3:50 1028 0 1 0 0 1
6/9/2006 3:53 1033 1 0 0 0 1
6/9/2006 4:24 1517 0 1 0 1 1
***************************************************************************************
6/9/2006 4:26 0 1 0 0 0 1
6/9/2006 5:16 806 0 1 0 0 1
6/9/2006 5:19 810 1 0 0 0 1
6/9/2006 6:02 1517 0 1 0 1 1
***************************************************************************************
6/9/2006 6:04 0 1 0 0 0 1
6/9/2006 7:37 1516 0 1 0 1 1