Looks to me like you're missing something. Is there no "Account" table somewhere? If you think about a bank account, at its simplest, it's something like:

CREATE TABLE Account(

...

#1: one way is to use a value list of the possible values. If you create a dataset of the values you can just use it.

#2. You can use...

Maybe you should have explained that to begin with.

Bite me.

Why not just filter the dataset?

Where do you get the data from?

You could transpose it in SSIS or Excel (that's what I used) and then it would be easy to use in SSRS. Then...

duplicate post! oops!

Okay, I think I got it...

Here's the stored procedure (I'm sure Dwain will school me on doing it this way, but I was just trying to get it...

Robert,

Well, no wonder you're having such a horrible time of it. I wouldn't have a clue how to graph something like that. What are you starting with, something...

If that's the structure of your data, no wonder. Your structure looks wrong.

Got consumable data? (Something I can drop into SSRS and build a quick chart?)

Guess I'll have to check my syntax.

I would have thought EXISTS will work better because theoretically it stops looking as soon as the condition is false.

Thanks Wendell!

Pieter

What does your query/filter look like?

IF you can modify the stored procedure, you can use something like this:

SELECT city, companyname, custid

FROM ...

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