that sp destroys all my table permissions, looking into others...

Looks like that will work, but I need to have it select all the situations where the owner id PRODCTL. The SP's syntax is: sp_changeobjectowner [ @objname = ]...

Found the problem, thanks for the guidance Steve. it was my original join, trying to join on illitm instead of ilitm. Those are both valid fields, but ilitm...

it is the join fields, just tried a select and join to the temp table without update... got the original error. experimenting...

I changed my original line to cast as a float...

select illitm,ilmcu,illocn,cast(sum(iltrqt) as float) as TotalSold into #SoldTable from proddta.f4111

then ran this...

select illitm, cast(TotalSold as float) from #SoldTable

with no errors.

:crazy:

I queried the temp table and sorted by the TotalSold column, found nothing but integers.

Could this error pertain to the join fields, or is it just for the...

Thanks for the help guys - sorry about the original message - I was really just trying to be funny but I have nothing but respect for you all. ...

I've settled on the following, which I've set to run each morning. Right now, I just get the email and glance at it to make sure the datediff is...

Sorry, I was able to figure out the tough part for myself, too quick to ask for help.

select

DATEDIFF(day,max(startedon), GETDATE()) AS NumberOfDays

from dbo.table

Looks like CAST will do the trick - thanks!

thx... hence the "syntax error" clue...

I thought that might be it, so I simplified it to:

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'NTSVR1 Mail',

@recipients = 'joe@web.com',

@query =...