pass-through query to make pivotchart/table problem

CoffeeGuru

Registered User.
Local time
Today, 04:57
Joined
Jun 20, 2013
Messages
121
Hi

I have some code that I need to produce a pivot chart from.
This works fine when I have the entire code as a pass through query but as soon as I call the same code as a stored procedure from within SQL server the pivot drop zones become grey out and unusable.

Has anyone any ideas why this may be as I would rather use the SQL server stored procedures to stop the possibility of SQL injection.

The query runs in both cases and the resultant tables are the same in both cases, so I am at a loss.

Anyone else come across this before.
 
I have been advised that Pass-through stored procedures return read only results.
This is why I cannot pivot within Access - really!

So I have to put my SP code into a query in order to pivot it into a chart and risk SQL injection.

Hmm can this really be right.
 

Users who are viewing this thread

Back
Top Bottom