spPurgeExpiredShoppingCarts

      CREATE procedure [dbo].[spPurgeExpiredShoppingCarts] as      
                delete from dbo.ShoppingCart      
                from dbo.ShoppingCartPart scp      
                where scp.ID = ShoppingCart.ShoppingCartPartID      
                and scp.ExpirationDays > 0
                and ShoppingCart.UpdateDate < dateadd(d, -scp.ExpirationDays, getutcdate());