like I said "Sharp as a MARBLE!!!"

Got it to work... Makes me feel like Ralph Wiggum "I'm learnding!!!" <with crayon in nose>

I looked there, but didn't see a link to download, so that's why I asked here. He explains the patterns, but without the database they're working from, I can't...

Are you doing a running total? Is this in SSRS that you need to do this? Or in T-SQL?

thanks for the data. Helps a lot, but really you should post it in a consumable format (because folks here are busy... so set the scenario up for them)....

Oh, ouch. That's painful slow. <hanging head>

Something like...

CREATE TABLE Actuals (

FY INT

,P1 SMALLMONEY

,P2 SMALLMONEY

,P3 SMALLMONEY

,P4 SMALLMONEY

,P5 SMALLMONEY

,P6 SMALLMONEY

,P7 SMALLMONEY

,P8 SMALLMONEY

,P9 SMALLMONEY

,P10 SMALLMONEY

,P11 SMALLMONEY

,P12 SMALLMONEY

CONSTRAINT pkActuals PRIMARY KEY (FY)

);

GO

-- insert some dummy values...

INSERT INTO dbo.Actuals(FY,P1,P2,P3,P4,P5,P6,P7,P8,P9,P10,P11,P2)

-- 2000...

That's what I thought... if they gave me the scripts to create a database and said "write a stored procedure that does X", then it would make sense. Otherwise, the...

John,

It's a recruiter, which makes me wonder, because the number of recruiters in this town that understand and can evaluate the "goodness" of T-SQL code is less than 5. In...

That's kind of what I was thinking. Without context, the solution is somewhat meaningless. For example, in a previous job, I had to summarize data in tables that I...

Sweetbea,

Maybe you should start by reading this article:

How to post a T-SQL question on a public forum

It's impossible to answer your question as stated, because we can't see the table...

So you need to use DATEPART() to get the time the user logged in:

SELECT LoginDate

, DATEPART(hour,LoginDate) AS LoginHour

FROM UserLogins;

Then it's just a count of Logins per LoginHour, and you're home...

Getting really good at double-posting, so I might as well fix up this reply with something useful....

Here's how to post some sample data:

CREATE TABLE Payments(

LoanID INT

,CollectorName CHAR(3) NOT NULL

,TransactionAmount MONEY

,PaymentType...

If I understand the question, this is trivial. You add a Row Group Total on [LoanID] or [CollectorName] (depends what you're getting totals on), and then you just use SUM([TransactionAmount])...

What if you set TimeOut for this report to 0? (It means "do not timeout"). I would do it on a Dev server first... you don't want it hogging up...

oops... double post...