This is not directly related, but still worth mentioning.

We try to avoid using FORMAT() here because of its poor performance. Assuming tblWTHistory.EstCompDate is a date, please try changing those two...

If you are really sure that it's not going to cause issues, you can do this.

Disable the trigger, perform the deletion, then re-enable the trigger.

https://www.mssqltips.com/tutorial/sql-server-disable-and-enable-triggers/

OK, that explains it. The deletes are being blocked and instead the delete attempts are being logged in table JournalDeleteAudit.

Please right-click / Script as Create

and post the code here.

Weird. Are there any triggers on this table?

What does it say in the Messages tab after attempting the deletions?

Understood. But in your database, the function definition will exist. Otherwise the code you provide would not execute.

You need to provide that (in the form of CREATE FUNCTION oracle.xxxfloat AS...

Are you trying to rewrite the Oracle functions? In which case, you'll need their definitions, not just the code which is using them. If not, I don't really understand what...

OK (and good pun!). I...

DECLARE @first INT = 13
       ,@second INT = 2;

SELECT Result = CASE
         ...

That wasn't clear, given that the first two sentences of your original post were this:

Is there any circumstances...

• This reply was modified 7 months, 1 week ago by Phil Parkin.

You don't mention the error you are getting, but I think you might have missed a bit of syntax:

CREATE FUNCTION LoafIngredientCostsOverTime
(
    @StartDate DATE =...

• This reply was modified 7 months, 1 week ago by Phil Parkin.
• This reply was modified 7 months, 1 week ago by Phil Parkin.

The Morgan3445 post contained a spammy link, so I reported it.

Nice refinement, Jonathan.

Have a look at this. I used a temp table & added a PK for fun.

DROP TABLE IF EXISTS #temptable

CREATE TABLE #temptable
(
    SomePK INT...

• This reply was modified 7 months, 1 week ago by Phil Parkin.