Batch invocation of Drillthrough action

Does anyone happen to have an example of a batch invocation of a drillthrough action?

Essentially, what I'd like the ability to do is use the results of the drillthrough to feed into another process (i.e., to use as input to an SSIS package or load into a relational table.) However, I've found no examples of what the action settings would need to be in the Application field, for example.

Maybe drillthrough isn't the proper action to define it (although it would be the easiest.) Maybe a regular action returning a dataset or rowset? Any help or idea is a appreciated.

Not sure what you trying to achieve. The drillthrough is invoked in a content of the particular cell.

You can also take a look at the syntax of the DRILLTHOUGH statement http://msdn2.microsoft.com/en-us/library/ms145964.aspx

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

I think what he means is doing individual drillthroughs on a bunch of cells, and then combining all the drillthrough results.

I had a similar need for this as well, awhile back

Thanks,

JGP

|||JGP, you're situation is another aspect of what I'm attempting to accomplish.

As an example (using Adventure Works), let's say I have the customer.education on the Y-axis and something else, say Product Categories, on the X-axis. My measure is Internet Order Quantity. My filter criteria is Customers in the US. I've sliced it up until I had found that 461 orders for Mountain Bikes were placed by Customers with a Graduate degree.

Now, that could be one customer purchasing 461 mountain bikes, or 461 customers purchasing one each. Regardless, there are customers associated with each order represented in that cell and I want to create a list of those people from my grid. With an action, I was hoping to do maybe a batch drillthrough that, rather than having the results back to the screen, output to a table. So far, I've not found how to do that, or if it even can be done.

Really, I can't find any examples of what a mechanism a batch action uses. All examples are of interactive reports, URLs, and drillthroughs.

Basic Table update/append question

I'm new to SQL server. I want to add or append a unique set of rows to a destination table from a source table, they are essentially the same table by definition. The source table is updated every hour via DTS, all rows deleted and new set added. Both tables have the same primary key. Approximately 40 unique rows are created each hour and I would think the best approach would be to append the new rows to the destination table. I think an Append query will run into a primary key conflict.

In Access, I did this within VB by checking the max value of the primary key and then running the append for any values greater than that.

In SQL, I'm not sure if this should be done as a stored procedure or if there is an easier approach altogether.In SQL Server (or in Access...) you are better off using a LEFT OUTER JOIN against your destination table, and filtering where the destination table key is null:

select [YourFields]...
from SourceTable
left outer join DestinationTable on SourceTable.PKey = DestinationTable.PKey
where Destination.PKey is null

You could also use NOT EXISTS, but I prefer this method.|||Thanks, that worked really well!