chuckles1066
Banned
- Joined
- Dec 20, 2004
- Messages
- 372
So I've managed to put together some code which passes three parameters to a stored procedure and populates Sheet1 with the output.
My problem is the raw data returned is 130,000 rows - once it's grouped by day it's 900 rows.
I don't have write access to the stored procedure (if I did, I'd simply add a GROUP BY clause at the end to return the consolidated view).
Is there a way from within Excel to generate only the 900 rows?
My problem is the raw data returned is 130,000 rows - once it's grouped by day it's 900 rows.
I don't have write access to the stored procedure (if I did, I'd simply add a GROUP BY clause at the end to return the consolidated view).
Is there a way from within Excel to generate only the 900 rows?
