hop of those help? Yes it is. A view (not persisted) is nothing more than a query stored on your DB. If you have a view called view1 as select * from table1 and do select * from view1, SQL Server will automatically transform that to select * from table1 and then build a execution plan Same rule applies if you increase the chain of objects adding more views.
SQL server 2008: join 3 tables and select last entered record from child table against each parent record
To fix the issue you can do I have following 3 tables and last entered reasoncode from Reasons table against each claimno in claims table. , Is this what you want?
select claimno, enterydate, user, reasoncode
from (select c.claimno, r.*,
row_number() over (partition by c.claimno order by r.entrydate desc) as seqnum
from charges c join
on c.chargeid = r.chargeid
where seqnum = 1;