Slap a TOP predicate on top of your query...

SELECT TOP 10

vPerf.DateTime,

vPerf.SampleCount,

cast(vPerf.AverageValue as numeric(10,2)) as AverageCPU,

vPerformanceRuleInstance.InstanceName,

vManagedEntity.Path,

vPerformanceRule.ObjectName,

vPerformanceRule.CounterName

FROM Perf.vPerfHourly AS vPerf INNER JOIN

vPerformanceRuleInstance ON vPerformanceRuleInstance.PerformanceRuleInstanceRowId = vPerf.PerformanceRuleInstanceRowId INNER JOIN

vManagedEntity ON vPerf.ManagedEntityRowId = vManagedEntity.ManagedEntityRowId...

Robert,

I'm taking a few steps backwards...

Here's your data...

CREATE TABLE AdmitDischarge(

TheHour TINYINT,

ADType VARCHAR(10),

TheCount TINYINT

CONSTRAINT AD_PK PRIMARY KEY (TheHour,ADType)

);

GO

INSERT INTO AdmitDischarge(TheHour, ADType, TheCount)

VALUES (0,'A',2),(0,'D',6),

(1,'A',6),(1,'D',3),

(2,'A',4),(2,'D',4),

(3,'A',1),(3,'D',2),

(4,'A',3),(4,'D',9);

By the looks of things, you could do the...

Careful. Using brain dumps is cheating. If you get caught, your exams get invalidated. I think it's ALL of them, so it could be costly.

For what it's worth, I would probably build this as a stored procedure in SQL Server. Then you can do something like include the columns you're filtering on in...

I've been trying to figure out how to answer this for a couple of days at least...

I faced a situation like this once, but it was in Access (yup,...

also note that this thread is almost six years old?

you can use STUFF and FOR XML PATH to do it. There are articles on here that show how -- I'm sure because I've read them. Just don't...

There's pretty much no way I would need them. The company is tiny (like 10 people), and they don't generate data like it's going out of style. I could...

I was trying to do the latter. Not the size restrictions etc. The idea was to upsize the Access back end to SQL Server (Express) and then use...

Not enough information. Show us what you tried first.

Some days, it helps if you think before typing...

you could do it in batches and use a TRY CATCH block for the failure, and write the failed group of records...

maybe

http://www.sqlservercentral.com/articles/Hierarchy/94040/

Found this article:

http://www.sqlservercentral.com/scripts/LAG/89769/

If you had 2012, you could use LAG or LEAD to look at previous/next records and do math on values between records, but since you can't...

Task 2: Use REPLACE. Look it up in Books On Line.

Task 1: Find all records that begin with 'THE '. Play with RIGHT() to strip it off.

...

Here's a solution... tried it and it looks like it works:

https://skamie.wordpress.com/2012/05/21/ssrs-format-option-for-milliseconds/