Results 1 to 3 of 3
Thread: creating stored procedure
Jul 13, 2004, 06:46 #1
- Join Date
- Feb 2004
- 0 Post(s)
- 0 Thread(s)
creating stored procedure
I am working my way through a book using SQL Server and ASP to create an ecommerce website. The book is a little old and now I see the code for creating a SQL stored procedure has an error.
/* Retrieves the last basket for the shopper */ Create Procedure sp_RetrieveLastBasket AS /* Pass in the ID of the shopper */ @idShopper int AS /* Select the basket data for all baskets assigned to the shopper and where the order was never finished. We sort the data in descending order so that the last basket is returned first. */ select * from basket where idShopper = @idShopper and intOrderPlaced =0 and intTotal =0 order by dtCreated DESC
and another error that happens where @idShopper is referenced.