0 - 1 of 1 tags for PRINT in Stored Procedure

Hi ,
I need to display message when activity count is zero through a stored procedure . Please give me a sample script which will help me to rewrite for my reuirement .
But , if i use PRINT , i dont get any output .
Note :- I m using TD Studo express 15