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 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.