Jeff, your simple one line of code made it happen. This was a great learning exp for me, I kept making this thing way harder than it was.

Thanks again to...

Thank you to everyone. And to Phil, you're right, but its been a good while since I posted. I will follow your lead in the future.

Again, thanks for all the...

Eh, I figured it out...now to get the '#Sold' in ASC order by INT..its currently treating 1 then 11 then 12 then 2....so its reading an 11 as the successor...

SELECT
     [iv].[ItemNum]
    ,[ii].[DiffItemName]
    ,CONVERT(VARCHAR(8), SUM(CAST([ii].[Quantity] AS INT)))                                        AS [#Sold]
    ,'$' + CONVERT(VARCHAR(9), SUM(CAST([ii].[Quantity] * [ii].[PricePer] AS MONEY)))        AS [Total_Sales]
--MyTarget.[ListPrice],
--MyTarget.[Discount],

FROM
Invoice_Itemized as [ii]
JOIN Invoice_Totals...

DECLARE @Yesterday DATETIME = DATEADD(DAY,-1,CAST(GETDATE() AS DATE));
DECLARE @PeriodStart DATETIME = DATEADD(DAY,-6,@Yesterday),
   @PeriodEnd DATETIME = CAST(GETDATE() AS DATE),
   @MonthStart DATETIME =DATEADD(MONTH,DATEDIFF(MONTH,0,GETDATE()),0);
SET NOCOUNT ON;