thanks!  much appreciated.

Thanks!  i won't forget that one!

thanks!  i will give that a try!

Thanks . . but it appears that i can use decimal percentage . .  i thought i tried this, but now it works.

Select top .5 percent from ....

thanks, but when tested that with 
SELECT TOP 50 PERCENT FROM TOP 50 percent

I get an error near FROM . .

thoughts? thanks

FOLLOW UP!

How can i pull .5 percent? 

I get Conversion failed when converting from a character string to uniqueidentifier.

thanks again

oh PLEASE dont tell me that it is that easy!  lol
Thanks so much . . . 
Next question, where do i go to get my ego back?

Solved, i just removed line 3!  and now i get 0's instead of Null

thanks all

This code from another site (https://www.experts-exchange.com, to give proper credit) got me this far.
But now i get an error , invalid Column Name "Line Item Duty" on Line...

Sorry, Case didn't work for me. Same result.

Thanks Drew . . . i REALLY wish my company would hire a trained SQL person . . Lol.

Apologies.

cross apply didnt work either, so my co worker went back to this method.

first few lines of temp table:

USE GTM_ODS

IF OBJECT_ID('TEMPDB..#TEMP1') IS...

Temp table working correctly, now i am running this, but get zero results.

SELECT
.T.Part
,[COMPOSITE_PART]
,[ELIGIBILITY]
,[EFFECTIVE_FROM]
,[HTS_NUMBER]
,[CREATED_DATE]
,[HTS_DESCRIPTION]
,[PREF_PROGRAM_CODE]
,[COUNTRY_ORIGIN]
,[PTNR_SITE_ID]
FROM
#TEMP1...

Ok, my SELECT vanished. I am back to this . . .
I have my temp table working, so here is my select
FROM
#TEMP1 T
INNER...

thanks.
1. I fixed the TOO LONG error, i was missing a bracket.
i will review your suggestion about the alias, THANKS!