Dataset command type: Text vs. stored procedure

Question

Dataset command type: Text vs. stored procedure

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply

MaricopaJoe Ten Centuries Points: 1190 More actions · Answer 1

My point was that the primary purpose of SPs, at least from a reporting point, is the reusability of the same code, from a single source. Shared datasets are quite similar to to sp's in that aspect. Being a SSRS persom, I have found some enviroments where the customer doesn't want the reporting person to write anything, yes anything, into the database. With read only permissions, it is not possible to create a SP. Shared datasets help in that aspect.

jcrawf02 SSC-Insane Points: 24198 More actions · Answer 2

Gotcha, in that context, yes, I see your point.

Thanks for the followup!

Jon

---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."