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...

Not really. This assumes that nobody has a name like "Billy Joe" or a last name with spaces in it either... which is a gross simplification.

SELECT LEFT(FullName,CHARINDEX(' ',FullName)-1) AS...

I am designing an application where multiple users can be assign to a product for review. If a user doesn't have access to the product, they are not allowed to...

What did you try?

Did you try using CHARINDEX?

Can you subclass the entities? Essentially, the "main" table has an autoincrement primary key, and the "child"/subclass tables just inherit that key from Main. There's a really simple...