Thank you very much sgmunson, this seems to work. I also...

For example I wanted to get the total quantity of Bids and Complete Orders separately for the dates between 6/1/17-8/30/17.
For between those dates I wanted to get BidQty =...

CREATE TABLE [dbo].[tblOrders](
    [OrderID] [int] NOT NULL,
    [JobStatus] [nvarchar](50) NOT NULL,
    [JobType][nvarchar](50) NOT NULL,
    [BidDate] [datetime] NULL,
    [BidTotals] [money] NULL ,
    [Qty] [int] NULL ,
    [OrderDate] [datetime] NULL,

how do I post the sample date. I can post the create statement but the insert into will be too much. If I just insert a sample data, it might...

There are actually rows within that date range

thanks for the reply but I found out that the problem was during execution. This is the correct one
Declare @ItemSubPartID_New int
Exec [dbo].[ItemSubPart_TEST1] @ItemSubPartID = 464, @ItemID_New =...