Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ragh
Starting Member
34 Posts |
 Posted - 2005-06-22 : 03:51:15
|
| Hi,I have a table something like thisID Date Time1 01/01/05 09001 01/01/05 10001 01/01/05 11002 01/01/05 12002 01/01/05 1300The Problem: I want to read the data in this way....ID Date InTime OutTime1 01/01/05 0900 10001 01/01/05 1100 0000 (Since no another even row)2 01/01/05 1200 1300How can i accomplish this ? Please help me !!!!Ragh |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
ragh
Starting Member
34 Posts |
Posted - 2005-06-23 : 00:16:41
|
| Thank you guys....Since the application will be using MS Access version also, how could i accomplish this ?so i thought to do this job in front end (VB).i've done pretty well and working fine, then problem arises only when i dont find even swipe.ex:An employee swipes a card when he enter inside and swipes when he goes out, (my code works well here).suppose he forgets to swipe when he is out or in, ODD Entry (My code Fails here)help me !Ragh |
 |
|
|
jonasalbert20
Constraint Violating Yak Guru
300 Posts |
Posted - 2005-06-23 : 00:21:46
|
| Try this...http://sqlteam.com/item.asp?ItemID=2955This one helps me a lot with the same problem as yours.:DWant Philippines to become 1st World COuntry? Go for World War 3... |
|
|
|
|
|
|
Table Reading Problem