i think they are ment if you have lots of quries ,
like i have a Stored procedure that gets all the listings between xx and yy for my tv guide.
and these hgave a few factors to it, day, time, week, etc .. instead of writing lots of queries i can write a Stored procedure that have the...