just noticed this was part of a SQL Agent step.

word of advise - NEVER EVER use powershell directly on a step - either code it in C# on a SSIS...

change process so that you use staging tables (not tempdb!!!) for each task - and you switch in/out of these and it is also where you do your inserts (so...

it is possible to load a DLL that is NOT in the GAC - have a look at the following

https://cultivatingsoftware.wordpress.com/2018/08/21/ssis-load-dll-gac/

https://blog.matrixpost.net/load-an-custom-assembly-in-sql-server-integration-services-ssis-script-task-that-is-not-or-cannot-be-stored-in-the-gac/

There is an app that was sending DML requests from a SQL2016 to SQL2008, and we saw lots of issues and it could have been driver related where record...

instead of trying now to follow a different approach why don't you tell us, very detailed, what you are trying to accomplish with having some software inserting those sql statements...

too many things to consider in order to say if there is a more efficient way - depends on volumes and number of times it is executed as well if...

works fine with a few caveats

performance impact will depend on your activity and server spec - bad server with lots of activity and it will be noticeable.

using a custom view/proc...

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