Re: Best Practices

2004-11-10 Thread Karma Dorji
Hello all, I am using this script and it takes 100 % of the process, can anyone tell me how to optimize this, insert into incoming select s.Date as Datein, s.Time as Timein, e.Date as Dateend, e.Time as Timeend, s.CallingStationId, s.CalledStationId, SEC_TO_TIME(unix_timestamp(concat(e.Date,' ',e

Re: HELP ME WITH THIS

2004-09-04 Thread Karma Dorji
and the query will probably > > be rough. > > > > Did you design the table? Can you create it so that your row has start and > > stop times, instead of creating another row? > > > > > -Original Message- > > > From: Karma Dorji [mailto:[EMAIL PROTECTED] &g

HELP ME WITH THIS

2004-09-03 Thread Karma Dorji
Hello can anyone help me with this, i have a table, like the one below, i need to find the time difference between the Start and Stop from a particular CallingStationId to particular CalledStationId. ++--++---+-- +---

msSQL-MySQL

2003-06-06 Thread Karma Dorji
Is there is utility which is free to convert ms SQL 7.0 running on windows NT into a mySQL format, i would be very grateful if someone in here could help me out. Thanks. Karma - Original Message - From: "Heikki Tuuri" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 06, 2