>>That kills me!!!
>>
>>print 'Cart ID =' + RTRIM(CONVERT(varchar(30), @tnCartID)) + ' Error code = ' + RTRIM(CONVERT(varchar(30), @RetStat))
>>
>>Doesn't print anything. If I have Error code on the second line, it prints it, but not CartID
>
>I've no idea what you're talking about. :)
>
>>Also how can I get rid of 1 row affected message. It starts to get on my nerves...
>
>Add SET NOCOUNT ON at the beginning of sproc.

I added nice comment, but it now gives me an error.

Could you please help me to find, what's wrong?

/* **********************************************************************************
CREATED BY:     Nadya Nosonovsky
CREATED ON:     02/28/2003
PURPOSE:        This procedure Create a Shopping Cart Info for the given user
                It creates new CartID in Cart table, if it doesn't exist yet 
                Otherwise updates ModiDate field with current time
                Inserts info to CartContent and CartDetail tables  

INPUTS:         @tcUserID  varchar(20) - UserID 
                @tnNumOfRecords int - Number of selected child records
                @tcDescription text - "Bundle" description
                @tcCreditCategory char(1) - B/F/L (Bankruptcy/Foreclosure/Liens) 
            @tcSelectionCriteria text - User-defined criteria from the Search page
                @tcListOfCodes varchar(500) - comma-delimited list of CredIDs

OUTPUTS:        
    ( RETURN CODES ) 
                                0 - Successful
                                1 - UserID is NULL                                      
                                2 - Tables do not exist
                                Actual error code for updates/insert
                                
                                
                                @tnCartID int - CartID for this User
                                
USAGE EXAMPLE:
    declare @tnCartID int, @RetStat int 

EXECUTE @RetStat = USP_Insert_ShoppingCartInfo 
    '241111111111'  ,
        5 ,
        'Some descr'     ,
        'B' ,
    'some  crit' ,
        '1,2,3' ,
        @tnCartID OUTPUT


print 'Cart ID =' + RTRIM(CONVERT(varchar(30), @tnCartID)) + ' Error code = ' + RTRIM(CONVERT(varchar(30), @RetStat))
GO

UPDATES (date,name,details): 
    
********************************************************************************** */

It gives me an error
Server: Msg 113, Level 15, State 1, Procedure USP_Insert_ShoppingCartInfo, Line 12
Missing end comment mark '*/'.

May be you can spot the problem?