Database

Shopping Cart History
date ------- PN  ---------- Qty    
08/29/2013 - 8AM  06-CR10   1
08/29/2013 - 9AM  06-CR10   1
08/29/2013 - 10AM 06-CR10   1
08/29/2013 - 11AM 12-ZZZ1   2
So the Qty would be 3

the result set would be

Items requiring fulfillment today
PN --------Qty
06-CR10    3
12-ZZZ1    2

DECLARE <a href="/Members/Year">@Year</a>AS int;
DECLARE <a href="/Members/month">@Month</a>AS int;
DECLARE <a href="/Members/Day">@Day</a>AS int;
SET <a href="/Members/Year">@Year</a>= 2013;
SET <a href="/Members/month">@Month</a>= 8;
SET <a href="/Members/Day">@Day</a>= 29;
 
DECLARE @startDate AS DATE;
DECLARE @stopDate AS DATE;
SET @startDate = DATETIMEFROMPARTS(@Year, <a href="/Members/month">@Month</a> <a href="/Members/Day">@Day</a> 0, 0, 0, 0);
SET @stopDate = DATETIMEFROMPARTS(@Year, <a href="/Members/month">@Month</a> <a href="/Members/Day">@Day</a> 23, 59, 59, 999);

SELECT PartNumber, ThumbNail, SDescription, sum(Qty) Qty, Cost, Price, SUM(Qty * Price) SubTotal From CompletedOrdersCart 
WHERE OrderDate > @startDate AND OrderDate < @stopDate
GROUP BY PartNumber, Thumbnail, SDescription, Cost, Price

jkirkerx wrote:

I tried between, but I would of had to deduct a day, and add a day for start and stop.

WHERE OrderDate BETWEEN @StartDate AND @StopDate

WHERE OrderDate >= @startDate AND OrderDate <= @stopDate

WHERE OrderDate > @startDate AND OrderDate < @stopDate

"DECLARE @startDate AS DATE; " & _
        "DECLARE @stopDate AS DATE; " & _
        "SET @startDate = DATETIMEFROMPARTS(@Year, @Month, @Day, 0, 0, 0, 0); " & _
        "SET @stopDate = DATETIMEFROMPARTS(@Year, @Month, @Day, 23, 59, 59, 999); " & _
        "DECLARE @SummaryItems TABLE(" & _
            "PartNumber VarChar(80), " & _
            "ThumbNail VarChar(250), " & _
            "SDescription VarChar(250), " & _
            "Qty INT, " & _
            "Cost Decimal, " & _
            "Price Decimal, " & _
            "SubTotal Decimal " & _
        ") " & _
        "INSERT INTO @SummaryItems (PartNumber, ThumbNail, SDescription, Qty, Cost, Price, SubTotal) " & _
        "SELECT PartNumber, ThumbNail, SDescription, SUM(Qty), Cost, Price, SUM(Qty * Price) From CompletedOrdersCart  " & _
        "WHERE OrderDate > @startDate AND OrderDate < @stopDate " & _
        "GROUP BY PartNumber, Thumbnail, SDescription, Qty, Cost, Price " & _
        "SELECT PartNumber, Thumbnail, SDescription, Qty, Cost, Price, SubTotal FROM @SummaryItems;"

DisIsHoody wrote:

it does contain an entry for localhost.

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Eddy Vluggen wrote:

Can you ping localhost?

jschell wrote:

That isn't really going to tell you anything.

jschell wrote:

But still says nothing about the database.

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Eddy Vluggen wrote:

It's going to tell me whether the DNS and the host-file know what IP I'm talking about.