locked
CRM 2011 - Set based update using SDK RRS feed

  • Question

  • This is a CRM 4 and CRM 2011 question, especially if you use CRM online.  I want to do a set based update of hundreds or possibly thousands of records based on a simple attribute check.  In SQL you can obviously do something like:

    Update dbo.Account set custom_followuprequired = 1 where custom_followupdue = 0

    It seems like if I try to do this with the SDK, I need to do a for loop checking each row individually, updating the value if appropriate, then saving the row.  Or even just a query of the ones to be updated, update the record, then save it, move to the next row, etc.

    Anything more than a few rows and this can get pretty time consuming. 

    Ideas?  Am I missing something?

    Tuesday, October 11, 2011 1:53 PM

All replies