So far, nothing.

I did consider this but given that the locations are all within...

Mr Celko,

I have great respect for your knowledge in relational theory, I even own two of your books. However, since database and query design are not my primary responsibility so...

Worked perfectly. Thanks.

Simpler than I thought. I generally don't consider cross join because of the volume ramifications but the entire table is 36 rows and the matching entries by state/city are in...

Runs once a year

:w00t:

Thanks.

Here's the final entire thing. Went from minutes to milliseconds. Much thanks.

Declare @counts table (ID int, Entries int)

truncate table dbo.DrawingPool2

-- Get players and compute # entries based on position (1=100,...

Looks like it might do the trick. I'll give it a shot.

Thanks.

I think I see where you're going. Two things:

1. What is dbo.Tally?

2. Do I just add an Insert above the Select from the CTE to actually perform the insert?

I found that solution in the SSRS Forum on MSDN. Fortunately when you open a new question they look at the subject you entered and list what they think may...

It was Parameter Sniffing. Check here:

http://www.sqlpointers.com/2006/11/parameter-sniffing-stored-procedures.html

I changed the single SP parameter to assign it to a local variable and it fixed the problem. Go figure..

Without posting all the code which is sizable, here is an outline of the SP:

DECLARE @Temp TABLE (BusinessUnit varchar(255), Leader varchar(100), [Level] int,

Sublevel int, Staff int, Emps int, Resps int,...

Fairly certain. It's a simple read of a couple of tables into a table variable, compute some additional fields in...

There's no direct correlation between the tables. The only thing is the BinPath. I could join Leaders to ReportingHierarchy based on the "LEFT(r.BinPath,LEN(r.BinPath)) = l.BinPath" understanding that using LEN in...

Jeff,

Thanks for all your work on this.

I already have a function similar to your dbo.GetEmployeeDownLine(ID) function. My end use case is that I need a table of all the employees...