quote:

---

nope, i'm still getting this:

AMSTERDAM Admin ...

try this then...

select dt1.Vessel, dt1.Callid, sum(dt1.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 <>...

Don't know why I didn't see this sooner...

select SiteID, CallID, sum(total_minutes) as "Total_Minutes" from 

(

select Siteid as Vessel,callid,sum(airtime) as total_minutes into tempweek from oldbill02 with(index(siteid)) where...

quote:

---

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...

Unfortunately, nmoore is correct. About the only thing you can do, if the results of the select statement are being used in an update statement, is to concentrate efforts...

quote:

---

Hi, I have been monitoring locking on my Production database, it is a SQL Server 7.0 db. I am noticing in syslockinfo...

quote:

---

I'm trying to union 2 tables same structure and I need to add one column.doing this.

select Siteid as Vessel,callid,sum(airtime) as total_minutes into...

quote:

---

Hello

I need to know if is possible when i use an insert or update TSQL store in one column an uniqueidentifier...

quote:

---

which is better 'a' or 'b' ?

any good advice to improve the two stored procedures ?

---