Anyone have any idea how this SQL 2008 functionality would/could/can be harnassed within application development ie ASP.net, vb.net, c# ...

Clive,

Thanks for your help

rgds

Andrew

The table is used to store each level of a hierarchy in a particular transaction to make it easy for reporting.  Whenever a new level(/depth) to the hierarchy is created...

Ideally I just want them to access a single stored procedure which would give the limited functionality required.

Just an update

I removed the 'Order By ' in the views and all seemed to work correctly.

Thanks for your help

I will do some testing over the week end.  I'll post what I find out.

Thanks for your help.

I am only showing 4 entries because I was trying to find when the update stopped working.  The live Update command uses all of the fields so I can't modify...

Your right in your assumption there are no errors reported by query analyser

The views are quite complicated

The related views and tables are as follows

CREATE VIEW dbo.vw_BudgetTotalPricesRevenuesTonnes

AS

SELECT     TOP 100 PERCENT...

Yes David I see your point I think when I simplified the code I should have put another Id in the tblRequirements table which would be the Id from the original...

Sorry David

Looking at it again and I can see it now.

Thanks

paramind

What are your concerns regarding the other solution ?

Andrew

Thanks to you all

I've done some simple tests on both solutions and think both seem to meet the 'goal' bearing in mind the 'tweek' Ryan identified.

Whats your thoughts on the relative...