We can't go on pre-processing (I can't forward this idea to upper management), also there is no specific time for pulling out report. We don't know when and from which...

Few of procs were already written as you mentioned above like calling sub procedues but it does not produce any desired performance that we say YES, here is the performance gain:

IF

In short I'm sending you a sp similar (tables and fileds are changed) like below:

ALTER PROCEDURE [dbo].[SP_caller_Usage]

-- SP_Caller_Usage @ToDate = '12-July-2007',...

Thanks Jeff for your reply and taking interest in my problem.

Well, I won’t give you exact scenario according to existing database/nature of business. But I can give you...

Peter, I found out the clue, here was a little mistake making V table

the last row of populating v table was missing 20 and it was 22 twice.

Old:

From

Please see post 10. following are 12 hits logged in to LoginTrack table for 01-Jan-2007 with the help of following query:

Declare

 @todate datetime, 

 @fromdate datetime,

Again, Again, in my second last reply i checked actual rows in table were 12 and the count is giving me 13 rows with your given query output. that should...

SQL Server 2000 SP4

Peter, once again thanks for your support and help.

I have following query and results, that are showing me actual data with date/ time:

Declare

 @todate datetime, ...

wat if the sql user has no permit to master.. permit?

Furthermore, I require percentage per hr. how to do this?

Great !!!

Thanks you all for ur time and help.

Shamshad Ali.

Thanks Peter, Your help is appreciated. Further more there are TOP 1000 rows. For real scenario If i have no hit during 7 to 9 it should return me 0 againt 7...

Steve, Thanks for your comment. My situation is with Windows Server 2003. I hope the sp1 of windows 2000 should be already included in my Win2K3s. Here one question is do I need to...

Distributed Transactions

Distributed transactions span two or more servers known as resource managers. The management of the transaction must be coordinated between the resource managers by a server component...

Thanks for your reply. But I don't understand explaination from BOL. There must be an easy/simple management in SQL Server itself to handle multiple resourse and commit them as one...