Thank you Jonathan, but this resulted in an out of range datetime value. Any ideas why that would come up?

That didn't work for me. I wasn't able to remove the spaces. Another option is to seperate the month, day, and year with DATEPART, and then string them...

Is there a way to remove the spaces between the month, day, and year?

Where is this being placed within the code?

If I already have the vendor numbers in a permanent table, why would I need to put them in a temporary table?

Got it...thanks...

what is BOL 2000? I can't believe that I brain farted on the 'CONVERT' feature...thanks for all the help!

Thanks a lot...that came right through!!!

SUM(a.FUEL_SALES*.0775) AS FUEL_TAX,

b.AMOUNT AS FUEL_MAN

FROM CSCSHBAL a LEFT OUTER JOIN CSCRDTTL b ON

(b.CARD_NAME='FUELMAN' AND a.DBR_DATE=b.DBR_DATE AND a.STORE_ID = b.STORE_ID)

WHERE (a.STORE_ID LIKE @STORE_ID AND a.DBR_DATE>=@START_DATE

AND a.DBR_DATE<=@END_DATE)

This code got...

The code changed because I was trying out left and right joins, and I was swapping the table names back and forth. I'm getting desperate! 🙂 I...

STORE_ID DBR_DATE TAXABLE_SALES NON_TAXABLE_SALES FUEL_SALE FUEL_TAX FUEL_MAN

-------- --------------------------- ----------------- ----------------------------------

7704 2003-03-27 .0 ...

Thanks for replying...when I join by store ID and by busines date, all I get is the one store (7704) that has the (Fuelman) sales...I need all the stores, plus...