newQty is in the same table. The application will update the value.

Got it! Thanks. I found the issue, it was in my test value. My code reply is correct.

select s.partNo, p.descript,

sum(case when battState = '99' then qty else '0'end) as CLNT,

sum(case when battState = '1' then qty-newQty else '0' end)...

GO

Drop view AssemblyDefects

GO

create View AssemblyDefects AS

(select p.model, i.defect_title, p.item, d.sn, d.dateinspected, t.type, i.defect_id

from productiondefect as d, assignworkorder as p, tlkp_defects as i, tlkp_item as t

where substring(d.sn, 7, 5) = p.workorder

and...

thanks Luis.

Below are my results:

yield

94.4000000000000000

97.6000000000000000

98.4000000000000000

96.8000000000000000

Now, I need to get rid of the zeros and show dates.

Ok. I got the below to run. The formula returns weekly defects / overall production totals. I want to calculate weekly defect / weekly production. Is this possible?

;with totalcount as...

The first characters will always be letters.

I resolved this issue by using EXCEPT in 2005 and creating Maintenance Plan in SSIS to run on a schedule. Thanks!

it worked. :w00t: Thanks!!!

Yes, I am using SELECT From OPENQUERY. I'll try that. Thanks!

Lynn,

Thanks for your help. I came up with a solution.

insert into recvLogTest

(ordno, itnbr, house, poisq, blcod, b_blksq, cmpdt, itdsc, engno, itcls, duedt, umord, qtyor, stkqt, staic, vndnr, vname, b_relqt, b_reldt,...

select count(distinct c.sn) as qty, sum(cast(l.labor as decimal(18,2))) / 1000 as labor, sum(cast(l.labor as decimal(18,2)))* count(distinct c.sn) / 1000 as laborhour, sum(cast(l.labor as decimal(18,2))) / 1000 * count(distinct c.sn)...

Drew,

This looks like it works. I'm tweaking it to get the correct results however, no longing throwing aggregate error.

Thanks,

DJ Khalif

Threw an error near Line 12 ')'