I appreciate the help. I talked with the lady that knows SQL here. I didnt even need to add the JOB side of the project. Just the PO side. Here...

lol wow. you were right.. it was as simple as:

SELECT fcpartno, ISNULL

...

I'm pretty positive I did. I may be mistaken though..

FROM (SELECT

dbo.invend.fpartno,

...

We are running on Compatability (80). I know such things as Pivot tables are not do-able at this level. What about CTE's ?. I tried this code on (80):

SELECT 'Priority'...

This part runs fine

SELECT *

FROM (SELECT

dbo.invend.fpartno,

...

edit

Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build...

Well your CTE looks like it would work. I wonder why I'm getting an error that says: 'Common Table Expression' is not available in this server version. I am...

I need them listed in 3 different columns. For instance, when looking at my purchasing queue.. When I want to order a particular part I want to be able to...

No. Because I need them listed in 3 different columns. For instance, when looking at my purchasing queue.. When I want to order a particular part I want to be...

Priority is either 1, 2, or 3 based on a couple of different things. The math for that is already done in the first view. this is the second view.

I...

Your code worked. I understand it too now. Thanks alot.

-Jeff

Finished the Project! I'm pumped haha. I'll post the code on monday and tell ya how I did it. Have a good holiday! 😀

Well your code returns all 0's for one year value and one year WTY. But another problem I seem to be facing is multiple orders of the same part. The...

WayneS (11/23/2010)

---

The problem is what you are doing in your case statement... specifically your date math.

You are taking the value returned from the GetDate() function, and subtracting one year from...