Viewing 3 posts - 1 through 3 (of 3 total)
Wayne,
While Leju did nail the code (thanks again) and get me the desired results, I am still in a test environment. Now that I have the top 2 PO's...
June 2, 2011 at 7:31 am
#1333090
Leju,
You nailed it!!!! I don't fully understand the code, but thank you very much for being specific!!! I really appreciate your help and thanks again.
June 1, 2011 at 3:03 pm
#1332828
Unfortunately, yes I'm sure it's SQL Server 2000. In addition to TOP, MAX, etc... I also tried RANK, ROW_NUMBER and those were NOT acceptable commands.
June 1, 2011 at 2:28 pm
#1332799