I ended up using the SELECT MAX FROM VALUES option as shown below

 dbo.GetBusinessHoursOut ((SELECT MAX(f) FROM (VALUES ([ScheduledInDate]), ([ArrivalDate]), ([InsuranceApproved])) AS Fields(f)), 1)

Sorry, I don't see where your code fits into mine. I am not exporting a single image but rather on one of the columns in many rows. I want the image to show up in the Excel cell.

OK, but how does Excel know that it is an image? In my sample I was exporting the alternate text and I even tried the URL but both resulted in text displaying in Excel.

What if I use SQL Server login rather than windows authentication?

What about using an SQL Server user and password instead of windows user and password?

I think the problem with running it multiple times is the line below

cnt = COUNT(*) over (partition by OriginalTargetDate)

Because the OriginalTargetDate values are no longer unique. I changed that line to below and it seems to work.

cnt = COUNT(*) over (partition by DATEADD(d,DATEDIFF(d,0,OriginalTargetDate),0))

Good point.

I discovered a problem with this. If I run this query a 2nd time (it will run each time an OriginalTargetDate job is added) and has the same OriginalTargetDate then all times are set to 08:30.

Just a quick note to say that Erland has been a great help to me on this problem and others I have had in the past. For those of us that are not database administrators it is even more important. Thank you.

The table row was actually updated as the update trigger ran. The INTERSECT was added to avoid updating when none of the 3 columns changed.

So single-user is not an option?

What was the problem that needed fixing?
p.s. My testing so far has been good.

Thank you.

Yes, I have the text of "column encryption setting=enabled" in the additional connection parameters tab.

That box is not checked.