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 1 years, 1 months 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 1 years, 1 months ago by Phil Parkin.
• This reply was modified 1 years, 1 months 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 1 years, 2 months ago by Phil Parkin.

Hello,

I have tried various methods to accomplish this using functions like PATINDEX, DIFFERENCE, and the Levenshtein Distance function, but I haven't been successful.

I have two columns of type VARCHAR, and I...

Can you confirm you have downloaded and installed version 1.5 of Microsoft.DataTools.IntegrationServices.exe?

It should appear in your Programs and Features list. Also, have you rebooted since installing?

Although it does not directly address your question, my suggestion would be that you learn how to use Tabular Editor (link) rather than VS to modify your tabular models....

Here is one way. There may be more elegant ways, but I'm short on coffee at the moment.

• Create an SSIS variable 'ConnectionOK', or similar.
• Add a script task before...

• This reply was modified 1 years, 2 months ago by Phil Parkin.

Why have you posted a random query? Please ask a question.

Can you somehow modify the process to make it incremental, or are all the rows always new?

If you have space, perhaps you could try running the insert to a staging...