SitePoint Sponsor |
|
User Tag List
Results 1 to 3 of 3
Thread: creating stored procedure
Threaded View
-
Jul 13, 2004, 06:46 #1
- Join Date
- Feb 2004
- Location
- Michigan
- Posts
- 256
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
creating stored procedure
hello all,
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.
Code:/* 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.
Thanks
Matt
Bookmarks