>I have one single dataset I am trying to return. I am returning Orders, and each order has a dealer ID. The SPROC returns data only from the order table. Now I want to show the DealerName with each Order (I need to join my Dealer table). Do I do the join in my SPROC and update all my existing GetOrder SPROCS, and the structure of my class or Strongly Typed DataSet (there really needs to be an acronym created for that)?
>
>I know what I CAN do, I just don't know what I SHOULD do.

So, it sounds like you simply want to add a new column, DealerName, to your existing Orders DataSet, right? I'd probably update the DataSet to add the column, and then update my Proc(s) to do the JOIN there to return the DealerName with the rest of the table.

I simply refer to them as either DataSets or Typed DataSets ... saying "strongly" is a bit redundant, IMHO. <g>

~~Bonnie