Also, I have checked all of the SQL server protocols to ensure TCP/IP is running, the SQL browser is running. What is weird when I went to "check" the settings,...

:hehe: No worries...if you can't tell, I don't take constructive critizism well:P

It's all good...we all have senior moments.

Actually we are only on SQL 2000, and I have actually never even used 2005, so I am not sure what line looks like it should be used in 2005,...

HI Sergiy,

The values that I was using as an example was just to show an example of data that I was using. I actually never evaluated that data, nor did...

Well with the help of some folks here and over at tek tips I was able to resolve this. It ended up my ERP vendor didn't give a clear explanation...

Well I am still stuck on this. Neither method has given me results that I need.

I have managed to get good data (Top 3) if I hard code in the...

http://wiki.lessthandot.com/index.php/How_Can_I_Select_Multiple_TOP_N_Data_Sets_With_SQL_Server_%282000_and_earlier%29

I am going to try figuring this out in this manner. It should be possible either way, but this is a nice tutorial. Let me know what you...

Yes exactly. I have over 25 customers in my database, so we would like to put the "None payers" up to the top of the list. The Fast Slow days...

I think I am getting closer:

Select customer_id,

(select top 3 avg(AVG_Fast_Slow_Days)

from table1 X

Where x.customer_id = Y.customer_id)

from table1 Y

Group by customer_Id

Order by 1 asc

Though the values still aren't the same...

Sure no problem,

I am just looking for a report with one line per customer and avg number of the top 3 most recent months of avg slow fast days.

So

Cust ID...