oh thank you very much,really helpful.

tnx for ur responding

following your questions:

a)is it on the one column:Exactly

b)wrong query,I amended it.

c)yes,it's Datetime

how many rows from the 5 million are being returned?

by executing above SP,it returns maximum 12...

unfortunately No,it is not.

look at my query,i've done it like this:

USE [MainTable]

GO

/****** Object: StoredProcedure [dbo].[ManagerTotalSendReceive] Script Date: 02/29/2012 15:45:37 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[ManagerTotalSendReceive]

(

@UserName...

No I don't need,it was a sample.

let me explain more.

I'll have new Database everyday,around 300,000 to 350,000 rows.

so,it stores users log,such as url,clientIP,Logtime and so on.

imagine that an admin wants...

yes.