SQL Server database programming

I was just curious on the pros and cons of returning a value via a return value vs a select statement in my Stored Procedure. For example, I have a SP: ************************************************************************************* CREATE PROCEDURE CopyFromTemplate ( @ClientID varChar(20),@PositionIDFrom int,@PositionIDTo int ...

/* ********************************************************************************************************************* 2005-04-22 11:34:40.78     spid4    Wait-for graph 2005-04-22 11:34:40.78     spid4    2005-04-22 11:34:40.78     spid4    ... ...

Hello -- I understand from other posts in this group that my query must use the CASE structure to make the calculations I need, so I can't use a SQL2000 View.  I think I can handle the coding of the query. ...