Query Help

[Hulicat]

I am running the following query: select sum(total) as 'Total QA Hours For F.I Centralized Alert Int', task.name as 'Project' from trans inner join task on task.name=trans.task where trans.project = '374' and [date] >= '1/31/2007' group by task.name The following error is returned. Msg 8114, Level 16, State 5, Line 1 Error converting data type varchar to bigint. Trans.task = bigint Task.Name = Varchar (250) trans.Total = float Prsumably I need to use cast? I have not been able to figure this one out. Any help would be greatly appreciated.

Regards, Hulicat

[M H 1 2 3]

select sum(total) as 'Total QA Hours For F.I Centralized Alert Int' , task.name as 'Project' from trans inner join task on task.name=Cast(trans.task as varchar(250)) where trans.project = '374' and [date] >= '1/31/2007' group by task.name

[Hulicat]

Thanks, I just read another one of your replies to someone elses problem that helped me with something else I am trying to do. I really appreciate the help!

Regards, Hulicat