Assuming more things than I care to list, a strored procedure might look like...

create procedure getThatWeek

(@inputDate datetime)

as

begin

set @inputDate = convert(varchar(10), @inputDate, 111)

select left(datename(dw,createdate),3) as ThatDay ,NumOfRequests

from YourRequestLogTable

where createdate >= dateadd(dd,...

or...

upper(coalesce(left([First name],1),'')) + upper(coalesce(left(surname,1),''))

...when you factor in Murphy's Law

Tip #9 opened my eyes. Triggers on views!!! I never thought to check if such a thing was possible. I have some apps that directly modify data...