hi arshad,

I would appreciate if you can put down a piece of code to how it was implemented in SQL Server 2005 ...It can be either using Temp tables or...

So whats the right approach when we have records in the header as opposed to not having them in details?