Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
DTS Foxpro 2.6
Can DTS in SQL 2K converts SQL data to dbf file that is compatible to Foxpro 2.6 DOS version? Also can the DTS converts data to Foxpro index file (.cdx) and memo field (.fpt). If not, what are the alternatives? Converting to these files is necessary because the current dbf interfaces to few...- sac11585
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
-
Table design question related to time....
Currently I am developing a timekeeping system that requires it to display 15-increment time span for each employee in his/her timesheet/reports. This is what I've done in the SQL Server DB for looking up/display individual start/end time... TimeClock Lookup table Regular Decimal...- sac11585
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
-
Help writing a SQL
I have created a temp table (#TempTable) as follow... DATE HOURS TYPE TIME_BEG TIME_END Sep 1 2004 12:00AM 5.0 P 12.0 17.0 Sep 6 2004 12:00AM 2.0 W 0.0 0.0 Sep 6 2004 12:00AM 2.0 HP 17.0 19.0 Sep 6 2004 12:00AM 1.0 HP 19.0 20.0 Sep 6 2004 12:00AM 3.0 HP 20.0 23.0 Sep...- sac11585
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
