Dataset command type: Text vs. stored procedure

• MaricopaJoe

  Ten Centuries

  Points: 1190

  More actions

  June 17, 2010 at 9:30 am

  #1181654

  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

  June 17, 2010 at 9:41 am

  #1181663

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