Posted by Henrik Juul on 03/21/07 09:02

I have the following 2 tables:

(BATCHES)
BatchID [int] KEY
ID [int]
OrderID [int]
Action1DateTime [datetime]
Action2DateTime [datetime]
Action3DateTime [datetime]
Action4DateTime [datetime]
Action5DateTime [datetime]
Action6DateTime [datetime]
Action7DateTime [datetime]
Action8DateTime [datetime]

(ORDERS)
OrderID [int] KEY
ProductionLineID [int]
RecipeID [int]
OrderAmount [int]

Batches.Action1DateTime to Batches.Action8DateTime can have several entries
each day.
I need a query to count all Batches.Action1DateTime to all
Batches.Action8DateTime for each day in a specified period.
I also need to specifically use where clauses for Orders.OrderID and/or
Orders.RecipeID.

I need the data to draw a graph for each ActionXDateTime as a function of
date.

Any help appreciated.

/Henrik

• Next in forum: XML, schema collection and "large value types out of row" problem
• Prev in forum: Re: Multiple db query call from within different context into #temp table
• Thread view: Sub-Query / Cross Join / or something else?

[Reply to this message]