If it is a regular temp table ie #Temp, then No, Temp tables are specific to each connection. so different connections cannot share a single temp table.

If your using global...

I think I know what you want to do.

Try Right clicking on the Cell Created when you grouped ColA, and Select Insert Row --> Inside Group Above.

And then add the...

Good DBA, Bad DBA, Ugly DBA. :w00t:

I've heard of it more as Production dba instead of administrative dba.

a quick google /Feeling lucky gives me this which about covers it, but...

You Can do a select top 1 order by DC_INDEX_FK desc.

What if you get 3 in one day? how do you make sure they all process?

What exactly are you trying to do here?

Can you please post better data, DDL and DML statements. You'll get more help if you follow the suggestions in this Post http://www.sqlservercentral.com/articles/Best+Practices.

Also...

What exactly are you trying to do here?

Can you please post better data, DDL and DML statements. You'll get more help if you follow the suggestions in this Post http://www.sqlservercentral.com/articles/Best+Practices%5B/url%5D.

Also...

The information supplied in the Provider adapter probably sucks, Even T-Sql queries with Nested subqueries and parameters in the query bomb.

This is the way to go.

how-to-use-a-variable-inside-sql-in-ssis-data-flow-tasks.html

I think you need to re-arrange your query to find sales that had no valid Member, then list those memebers.

but as GilaMonster states, Please create DDLs with temp tables, and...

Can you define what you mean by drill down parameters?

Create another report that has the detail data with a parameter of whatever that bar represents.

Then on the Chart data Series Properties, in Action, Change to Go to Report. Calling...

Your dealing with a scope issue.

SSRS Is evaluating your statement on each row for the dataset, not the min for all rows.

You can do a few different things.

The easiest is...

SSAS Does not have the capability to "convert" stored procedures or queries to Cubes [Measures, Dimensions].

You need to go through the exercise of modeling the data that better supports report...

The hanging in visual studio can be caused by a couple different things.

I've had it hang simply due to the report having to evaluate alot of rows.

and or alot of...

Ya, looks like it is satisfying your request. Is it the output you want?

Now, when using the query on your "Real" Table you may need to look at the table...

Wow, haven't touched sql 2000 in 8 years.

Can you elaborate more on what you mean you cannot even get all the tables?