I think that I would have to see the query to understand what you were getting at. Is the error your only problem with it then?

Steve Jones - Editor (4/7/2009)

---

That's a good idea as well. It gives you posts. Not sure there's a way to do the overall score.

If you're 11, does it matter where...

Execute this command and tell us the results:

SELECT *

FROM fn_trace_getinfo(default);

andrew gothard (4/15/2009)

---

Jeff Moden (4/14/2009)

---

Jim Russell (4/14/2009)

---

Charles Kincaid (4/13/2009)

---

Yes, Pete, many cuts. I saw a paper tape reader on a CDC mainframe that had a gear motor an optical...

And the [ code ] tags would make life easier for all of us.

Oh, sorry. i thought that you were doing "Contribute Article".

Bruce W Cassidy (4/16/2009)

---

Ow, now that burns!

Right Mike. And as the series goes on we will get to increasingly complex, difficult cases, so at some point it should reach a level where everyone can learn...

At worst a ZIP should always work.

Attach it as txt. I am sure that others have done it before.

This should do it:

INSERT TableTest(

ID

,AsOfDate

,Amount

)

SELECT ID = p.ID

, AsOfDate = dbo.fnsysMonthEnd(DATEADD(mm,mi.MonthIncr,@datAsOfDate))

, Amount = CASE WHEN s.BMV0 THEN ((p.BMV/s.BMV)*TQF)/3

ELSE TQF/3 END

FROM @tblPort p

...

Ther used to be an Access Upgrade tool that would do this for you. Not sure if Access still has it or not.

Code="plain" seems OK to me. Other than that, you could post a picture, or include it as an attachment.

Don't multiply the Order Quantity over the Phantoms, only apply that multiplication to the terminal line quantities.

As for your error, that's an entirely different matter. You will have to...

The EXISTS function is faster.