To better clarify, not all 100 are running in parallel.  There success/completion constraints throughout, but as certain tasks are finishing there are definitely a lot of tasks that are hitting...

Hi Phil, thanks for your response.

Yes they are running in parallel and are hitting the same DB (Different tables though).

Thanks everyone for your responses.  It sounds like (based on a few of your responses), I'll need to:

1. recreate everything from scratch;

   1. aAnew partition scheme
   2. New partition function
   3. New table...

Thanks everyone.  This helped.

Hi Steve,

So even if though the index approach should be the way I go, why wouldn't Scott's earlier code not work for me if I at least implement it that...

Hi Scott,

Sorry, actually there was a typo.  I can see how the typo would create your assumption.  This is a Claim Line table so the ClaimHeaderID and ClaimLineID as actually...

Hi Scott,

Thanks for your response.  I am using your sample to learn this and am working through setting this up in our test environment.  A few questions.

1. In the create...

Hello and thanks for your response.

My requirement is for a specific field not a table.  They are asking for a partition key on the field ServiceStartDate.  I'm very ignorant to...

I actually tried it that way prior to the where clause way.  It does work, but the update will update all the matched records since there is no filter on...

Hi Phil,

Thanks for your response and that does make sense.  My only question though is what version of the .net framework wouldn't allow something as simple as a type cast?

DataTable...

Sure, so notice how the selected parameter correctly populates the 1st box.  It is using this as the expression: ="Remit to: " & Parameters!owner.Value

That dropdown is tied...

Yeah, I'm sure it's probably something I'm still missing.  To your point though, I know I can do it if I pull a tablix in.  But it just seems like...

Hello Ant,

Thanks for your response.  Unfortunately adding the column in the manner you mentioned produced no results.  I need both textboxes to populate based on the selected user parameter.  The...

Thanks for your response Steve.  Purchasing it is the only way?  There's no drivers/ODBC where I can just program it myself?  Most of the ones I'm seeing want to charge...

Thanks for your response Phil.  This would work, but I was attempting for it to be more dynamic.  Needed to be able to feed a parameter becasue there are a...