exptrade2000

...

Can your OR Mapper do this?  I don't think so"

Nobody answered so far. This is the same question I have at my organization. We pull data from different disparate systems, with lot of DTS involved to create a data warehouse, and then tons of SP are executed to apply allocation logic, create report files, populate star schemas. I don't see that this could be done effectively with any kind of BLL that would sit separate from DB....

...well, the answer is... ...with SQL Sever 2005 all of that CAN be done in a BLL , which allows the use of .NET code (such as C#.NET or VB.NET) instead of SQL,... ...so there's an answer... ...any .NET language is MUCH preferable to SQL, in any case.... ...IMHO...