your problem is that your "ltrim" is on the wrong place, and the string compare inside does not find the required matches)

following works

drop table if exists #employee
CREATE...

you have 2 issues to address.

1 - if your destination datatype is a date then your variable assignment needs to cast it as a datetime, not as a string -...

you most likely have the Azure agent still active on your server (these are installed by default on the azure vm's depending on how they are created - or on...

Hello all,

I would like to create an INSERT statement and use a UDF as part of the VALUES() set.  The UDF generates a unique product code based on the

search these forums for PIVOT or CROSSTAB queries and you will find a few answers - google also has plenty of examples.

then get back to us with issues if any...

I am trying to set a date filter on several  large transaction tables to limit the years loaded.

When I use a hardcoded filter like:

DATEFROMPARTS ( DATEPART(yyyy, GETDATE()) - 4,...

when I do listen (mostly when working late hours on projects) is this one https://www.mixcloud.com/ovat83/best-90s-megamix-2hour-party-mix-track-select-list-available-in-description/

not quite what most would listen to "smooth" the spirit

did you look at

https://w3sniff.com/code?id=95&title=The-database-principal-owns-a-service-in-the-database-and-cannot-be-dropped

being VMWare I would speak with the team that maintains it and check config of new vm vs old - as well as server specs itself.

things to look at

• Memory...

similar hardware does not mean similar performance - so I would check those.

you say they are VM - details? onprem, cloud, vendor (AWS, MS, VMWare) - VM type if cloud

Disks...

substring vs like is only "better" if the like contains a wildcard at the start of the string.. e.g. like '%abc%'

on the case above both substring and like will do...

Somewhere I found that substring is not necessary, when you compare 2 values from tables, and one of the values has just 10 symbols, and the other has more...

one other thing that can cause differences is the timezone of the server and the time /day the job runs on the server.

you need both Oracle client and Microsoft Connector - but Microsoft Connector requires Enterprise edition - so if you have Standard you can't use it and you need to use...

can you also get the explain plan using the CASE method from Jeff Moden article?

curious to compare.

regarding the process - as I don't know Databricks I can't say if this...