Why the extra step of replacing the concatenated CR and LF?  Doesn't replacing the individual CHARs suffice?  That's how I've done it, and I'd like to know if there is...

I guess the follow-up question is "what can I do about this?" I don't know the answer to that unfortunately. I don't use procs that update millions of rows (usually)...

Regarding why it's slower in SSIS...SSIS needs to "validate" your query (in this case a stored procedure). It has to get metadata about the query in order to validate that...

I sent you a private message earlier, wasn't able to reply in forum due to getting an error.

What exactly did you try and what are you using (what tool/app) to...

Yeah I went through this with SSIS/SSDT.

That error refers to the "Microsoft Access Database Engine 2010 Redistributable" I think. You can download that from here:

https://www.microsoft.com/en-in/download/details.aspx?id=13255

There are different versions of...

Yeah, like THROW...try putting one in a BEGIN/END block and see SQL Server complain.

To err is human. To really foul up - it takes a computer.

I have seen it said that EXISTS/NOT EXISTS can be faster because it can "short circuit". That is, as soon as it find a case satisfying its condition, it's done,...

I used to have an old IBM Selectric keyboard...I loved typing on that thing, my hands must have bounced 6 inches off the keyboard with every touch. I can't say...

And the problem with a stored procedure is that you have to work around Entity Framework (with different code) to get it to work, whereas a view appears to EF...

If you're using Entity Framework (not EF Core) I'd consider using a view, not a stored procedure, for the select. If you shape the view the way the entity expects...

I kinda disagree with #27 and 30, though I guess it depends on what version of SQL Server we're talking about. I wouldn't use @@ERROR, I'd use ERROR_NUMBER() and the...