hi thanks for that, I've also just found this... (I did see it earlier when searching but didnt follow it due to the shredding part....curiosity got the better of...

hi luke

yeah I kind of figured the processing was a bit insane, theres about 6 sub reports and some other sprocs, so I figured 261*11 (or so queries) was a...

hi thanks both for getting back to me,

i changed all the stored procs to get rid of the param sniffing, which unfortunately didnt make any diff here is the output...

in the end I rewrote the dtsx package as a query and stored proc and it works fine, i have no idea why the dtsx package was even there tbh,...

unfortunately dont have sql on the web box, otherwise this would be a lot simpler, the main problem is, is that the stored procedure that gets called generates the data...

hi

i figured it wasnt going to be easy.... anyway, I did start off down the route of temporary tables but that was looking decidedly bad news, I prefer the idea...