nkweke (6/5/2014)
Thanks again Koen, I am new here and still trying to grasp this sql stuff. Your suggestions are noted.
I added the Group By and it pops up another error:
Msg 4104, Level 16, State 1, Procedure GetTotalAmount, Line 10
The multi-part identifier "shippingcart.shippingcost" could not be bound.
Double check your alias. The error means SQL Server cannot find to which table the column shippingcost belongs.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP