Thanks all for the tips and responses...Worked like a charm..

Tried your suggestion with different permutaions and still no luck.  Seems like it accespts the @ as a reserved character unless I'm missing something.

Is the captial N required?  What does...

This is the query syntax that I've been trying to manipulate.

insert logfilehistory(file_name,size_K,full_date,char_date,char_time)

select fname,lsize/1024,file_date,crdate,crtime

from #logfiles

where not exist (select fname from #logfiles)