Mark, I am slapping myself in the forehead right now! I had been trying to get this to work, but I was doing it like this:

SELECT Dept,EmpNum,

...

Thank you very much. Your help is greatly appreciated.

Steve

Thanks. I apologize for that. I am used to working in 2005 and 2008. I forgot this was 2000. I appreciate your efforts on this.

SQL 2000

Okay, we're almost there. Combining our codes, I now have:

--===== If the test table already exists, drop it

IF OBJECT_ID('TempDB..#mytable','U') IS NOT NULL DROP TABLE #mytable

IF...

Perfect! Thanks, Mister Magoo.

Thanks, Craig. This seems to work. My concern was that, the way you constructed it, sinced it didn't pull the price along with the max date and the item that...

Got it. Thanks, Ninja's_RGR'us.

Steve,

Thanks for the link. I have bookmarked it and will reference it before my next post.

One more silly question: How do you create the blue boxes that you use to...

Mr. Jones, you hit it on the head! That worked. Thank you very much.

I apologize for being vague initially. In the future I will provide more information so that you...

Maybe I am going about this all wrong. What I am expecting to pull from this SET statement is all of the items int he item master. Then, in the...

I am trying to pull all records from the ItemMaster table. There are about 38,000 records. I am also trying to pass a variable so I can use this in...

This is part of a Stored Procedure. I am just working on the SELECT statement separately right now. Sorry, I forgot to clarify that.

Thank you very much! That did it.

Thanks. This gets me closer, but I have to pull from over 3,000,000 records. I am trying fit fit the column name in your solution somehow, but I am not...