--Our system doesn't use hours in the date, so I can use end date today, midnight.

DECLARE @Today DATETIME

SET...

I'm not kidding. He's using the same base table for all 4-5 selects. I don't see why I he can't do a single scan (or big range seek)...

Are you talking sub reports or drill through?

That's great, but if you removed the inner joins altogether, this would run probably 5 times faster that it is at the moment...

The way this is coded, as soon as 1 period does not return something, the whole row is filtered out in the join.

option 1 would be to use left joins...

This is just to make it easier for us to read.

SELECT

--INS.CARRIER_ID

CHARG.ACCT_PLAN1

, ZERO.BAL0 AS ZERO_30

, ONE.BAL1 AS THIRTYONE_SIXTY

, TWO.BAL2 AS...

You can add a filter on the application name, or anything else you want actually.

It's in the same screen as the events and columns at the bottom right of the...

I meant make A NEW dataset. Make sure it runs in only a few seconds and see if you have other problems besides the timeout.

From there on out you...

Try using a dataset that runs instantly to make sure that part works.

Next step is to speed up that query. I'm pretty sure you can change the timeout for...

How long to run the query straight from management studio?

How did you develop the report?

In visual studio you have a very handy "deploy" function that handles all those pesky little details for you. I'd have a serious...

Try rdl (without the C at the end).

In cases like this I usually do the pivoting in a matrix in SSRS (assuming you are doing some sort of report).

Maybe you need to head out that way.

Not sure I get your question.

Are you having trouble building a valid select statement in dynamic sql?

DECLARE @Exec VARCHAR(MAX)

SET @Exec = ''

SELECT

@Exec = @Exec + 'SELECT...

You'll need to use dynamic sql to build the sql statement with all the union alls. This assumes that the # of db can change at any time and...