Yea. Select works multiple times in an SP.

The difference between using PRINT and SELECT is simply the difference of a SQL DBA's(or developers) thinking and any other developer's thinking.

SQL was designed to be a Relational Set based Language. The best results from SQL can be obtained when it is used in that Relational Set based way.

Select returns(prints) what you want as a column ie: in a relational format.

Whereas, Print would just give you a message.

That is why to someone who works with SQL, PRINT is just like an alert or an Error Message Whereas SELECT is the PRINT.

This makes me remember Jeff Moden's signature....."NO RBAR, NO CURSORS, NO LOOPS.....ONLY SET BASED SOLUTIONS"