That will just return zero rows from the table.

So in SSMS I would see column headers, but I couldn't actually copy/paste that result into say notepad.

I thought there was an...

Yeah i am expecting some large variances so I figured start small and aggregate out.

The tsql isn't the issue (though thanks for above) I was just wondering if my approach...

Does that allow for tables with differing structures?

One issue is that on test we may have added a new column, but we would have not done so yet on production.

I...

Thanks!

I placed an order for the Kimball one, it appeared to be a more introductory approach to start with.

For this I just need to know about the warehouse structure. They are using Microstrategy so that will be our reporting tool. SSIS for the etl I expect.

GSquared (5/16/2011)

---

A dataset returned the calling proc is, by default, returned to the client.

Here's a proof-of-concept demo:

USE ProofOfConcept;

GO

CREATE PROC MyInnerProc

(@Param_in INT)

AS

SELECT @Param_in AS MyInnerProcValue;

GO

CREATE PROC MyOuterProc

AS

EXEC MyInnerProc 1;

GO

EXEC MyOuterProc;

Is there...

So what is the real benefit of doing this....

I ran across this: http://blog.effiproz.com/2011/03/grouping-join-clauses.html

Which was interesting, is this a sort of hold over from the older style of putting...

Looks like maybe this is a GROUPED JOIN.... http://www.bennadel.com/blog/1059-Grouping-JOIN-Clauses-In-SQL.htm

Though the code I'm looking at doesn't have any opening or closing ().

SQLRNNR:

Yes, I went and looked at it in more detail and realized it seemed to have nested joins going on.

It was just not formatted in a "friendly way".

Although I don't...

Makes sense, thanks!

Unrelated:

Also, I didn't know you considered yourself a "Ranger", awesome series.

(I also never noticed your tag line before... is that new as well?)

I am joining two CTEs and then UNION ALL and repeating.

So

CTE1 JOIN CTE2

UNION ALL

CTE1 JOIN CTE3

UNION ALL

CTE1 JOIN CTE4

etc..

The slowness is when I physically scroll through the TSQL text...

In this case CTE1 is

just a month/quarter table.

Quarter | Month

1 |1

1|2

1|3

2|4

2|5

...

4|10

4|11

4|12

then the other CTEs are just used later to join against that.

Though I suppose I could just create a quarter...

This would be more of a "once a quarter" or twice a year sort of setup.

If it was more frequent then I agree, replication, log shipping, etc, something like that...

Then why did setting the database as trusted allow this to function in the way I needed?

I think that perhaps I am still missing a piece of the puzzle here.

So, I'm not opening my database up to "any horrible pandora's box of pain" because of this?

Using that to allow me to do my EXECUTE AS scheme, is legit and...