nope, i'm still getting this:

AMSTERDAM Admin 106

AMSTERDAM ...

only the first part works fine

something still wrong

select Siteid as Vessel, Callid, sum(total_minutes) as Total_Minutes from

(

select Siteid as Vessel,callid,sum(airtime) as total_minutes from oldbill02 with(index(siteid)) where callwhen >='12/31/2002' and substring(callnbr,5,3)<>'976' and siteid <> ' '...

No my friend, I need the vessel name and the callid for all vessels, not only for Amsterdam

thanks

Doesn't work: this is the error

Column 'oldbill02.callid' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

well my problem is the both they are not related, so is very hard to update the second table after the first been updated, I lost the variable to locate...

well now I'm getting an error:

Cannot Insert the NULL into column TIMESTAMP on trunk_lines

means that , the table I'm trying to update has a timestamp autonumber and do not accept...

1- Yes I change the view to details and right click,all tasks and nothing, hour glass only.

2- Yes I can restore from query Analyzer, I just want to fix the...

Not to individual files, but to individual records at the same file, what I need is a Query statment to do that.

ex:

Pell off 128 characteres and save it on line1

another...

Yes I know that..I can do programming, I'm try to know is If exist any way to do this in a querie statement

Sorry took me so long to answer I take vacations, so I'm back.

Yes when I copy and past and run from the query analyzer works fine, but the job...

NO NO, sorry there is no primary key and NO indexes

Yes the primary Key is siteid

nothing more, no indexes

not reason, the "BETWEEN" is working fine

just give that TIMEOUT EXPIRED, don't know why yet, If I refresh the page works

well I'm using the command "BETWEEN" and I'm getting "TIMEOUT EXPIRED" but when I refresh the page it's come on ok. every time I refresh I got it...is that any...