thanks John!

Thanks Scott!

I will review the function CHARINDEX!

Solved

Thanks, I concur with that . . . i lost sight of the big picture . . . .

Thom A - i totally agree that my large temp table isnt good code, but i need Duty Rates from Customs and that table is 9500 rows long.  My company...

I am thinking i can concat the BoM name and BoM Qty in a Unique value, then send them to a Tempt Table with the BoM qty in a column,...

That sir, is why your'e a GURU . . . . 🙂

Thanks . . . .Much appreciated.

Currently I use Excel 2013 . . but can get 2016 . . .

Ron, thanks! 
Funny you mentioned why the original coder used a HAVING clause when they weren't "HAVING" anything that was being grouped.
There are a couple aggregates in the Select:

Agreed . . . their concern is that if it isnt ".053" on a dollar part, why would it be it be ".053" on a million dollar part . ....

thanks, but do i HAVE TO round?????

Awesome! Works as entered!  Solved, thanks! 

I

Thanks for the reply.  I want to concat the Filer (code) with the Mode of Transportation . . . .I will then put it in SSRS and create table to...

Solved my issue . . . . in the second SQL, i changed table to #TEMP2

thanks

I tried that , but now i get  a : There is already an object named '#TEMP1' in the database. error

Do i need an END at the VERY...

lots of code, but here you go.
I get a SYNtAX ERROR NEAR ELSE

USE GTM_ODS

DECLARE @FTA VARCHAR (10)

SET @FTA= 'KOREA'

if...