Well m not a newbie..wht i was wanting to know is how does SQL Sever processes a View and a Stored Procedure is it just processed and complied once and...
I understand that its cached hence i'd re-executed the queries a couple of time but still the the SP in which i called the view was consistently fetching records in...