|
Recurring Order Count Query - How many recurring orders have we had this month? Hi All, I'm trying to come up with a query that returns a count of recurring orders for a given month that were CAPTURED. Is it as easy as follows?
Select COUNT(o.OrderNumber...
Started by akamiller on
, 2 posts
by 2 people.
Answer Snippets (Read the full thread at aspdotnetstorefront):
First add to the ....
But I found this post query as written, because it queries the order date column twice requires a Clustered Index SCAN on the Orders table.
Recurring Order Count Query - Optimized Sorry to bring up an old thread.
|
|
What is the best structure for an Orders table having OrderNumber, ItemNumber and CustID that allows for 1 or more item numbers for each order number?
Started by ScottK on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Orders orderid custid
Order Items orderid itemnumber
basket/order - table
1 : order-id -- item-id -- item-count/Quantity
cust/order history table
2 : cust-id -- order-id -- status (when you find out who the cust....
|
|
Whats a good value for an identity increment for an 'Orders' table? (orders as in shopping cart orders)
I want the order numbers to appear so that we have more orders than we really do, plus make it harder for users to guess order numbers of other users...
Started by Simon on
, 10 posts
by 10 people.
Answer Snippets (Read the full thread at stackoverflow):
Of orders unguessable, and make it almost impossible to guess an order URL (obviously you'd still the order looks like:
http://example.com/orders?id=4567
Say I'm feeling mischievous and decide to start playing with that url....
|
Ask your Facebook Friends
|
I have a list of orders with suboperations. How can I create a list of finished orders? Finished order must have finished all suboperations.
Table "orders":
order_no | suboperation | finished 1 | preparing | 01/01/2009 1 | scrubbing | 01/05/2009 1 | painting...
Answer Snippets (Read the full thread at stackoverflow):
Create table #Orders ( order with this:
SELECT ....
This avoids having to do any table joins which is more efficient .
SELECT order_no, suboperation, finished FROM orders o1 WHERE NOT EXISTS( SELECT 1 FROM orders o2 .
|
|
I have to produce this CSV layout, but a little unsure how to do it.
I have a Order class that I have to convert into a CSV file.
public class Order { public int ID {get; set;} public int Created {get;set;} public List<Item> Items {get;set;} } public...
Started by mrblah on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Order> orders) { foreach (var order in orders) WriteOrder(order); } // returns the formatted CSV BuildOrdersCsv(List<Order> orders) { StringBuilder sb = new StringBuilder(); foreach (Order o would contain....
|
|
I haven’t done much Java programming and hence a lot of unanswered ORM questions revolve in my head that might seem as fairly straight forward to more seasoned folks.
Let's say we have two classes: Customer and Order. Customer class implements a method...
Started by Totophil on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
On the other hand, if most with business objects and not messing... .
It isn't an optimization to return an order id if every time, the caller is then going to have to look up every single order.
It always helps to know what the caller wants.
|
|
Hi
I'm just after a bit of advice - I am building an online store (using php/mysql) and at present can view current orders by clicking through to the relevant section and applying filters etc. An email is also sent to my inbox.
Because of the nature of...
Started by Tray on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Basically you have a Web page showing "live" orders that has an AJAX query constantly running and hitting a PHP page that effectively polls for live orders.
Using AJAX and a Comet based approach.
|
|
Recently a bug in our web store caused the prices to be doubled at checkout. This lead to a drop in orders from about 25 to 2 over a period of 19 hours. We have lost quite some money over this. What I wonder is: is there any way to measure how many of...
Started by AquinasTub on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Ask them to fill in the details of the order again, if it matches a previous....
This doesn't help you find out how many come back because you are changing the special offer, else put it up on your website somewhere .
If they finalise their order.
|
|
I need a way to automate test orders on our test and production web sites. I was thinking about using something like iMacro, but I thought there must be a better way. Any ideas?
Answer Snippets (Read the full thread at stackoverflow):
Another good.
I suspect that you don't really want to be creating test orders on a production system though.
Without knowing what kind of "order" you're talking about, it's really impossible to say.
|
|
I am trying to optimize how orders are filled at my work. Right now, an employee just grabs the latest 16 orders(sometimes 14 or 18) and fills them.
I am trying to change it so that instead of simply going by the latest list of orders, that it orders ...
Started by Echo on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
Is that right now, things are grouped in terms of orders, so they try to fill Order #1 by going to all, followed by the items for the order, packed, dropped in shipping bin Cycle through orders Complete would be pretty simple....
|
