>>First, there's garbage at the end of your sproc. Second, double click on the error message and QA will bring you to the line with error.
>Why SELECT @CartID = @@SCOPE_IDENTITY gives
>
>Server: Msg 137, Level 15, State 2, Procedure sp_InsertShoppingCartInfo, Line 60
>Must declare the variable '@@SCOPE_IDENTITY'.
>
>My variable is declared at the top with DECLARE @CartID int
SELECT @CartID = SCOPE_IDENTITY()
You should read BOL not just glance over.
--sb--
