Ricky Valencia (10/26/2016)

---

Our client described to us how they wanted to migrate their data from one datacentre to another datacentre as follows:

•An application will generate csv files to a folder...

+1, this is the...

HanShi (10/26/2016)

---

The problem is that they probably...

Luis Cazares (10/25/2016)

---

Phil Parkin (10/25/2016)

---

Luis Cazares (10/25/2016)

---

However, the OUTPUT clause will generate an empty result set when no rows are updated, so that should work.

And with a single statement and...

Luis Cazares (10/25/2016)

---

However, the OUTPUT clause will generate an empty result set when no rows are updated, so that should work.

And with a single statement and the error handling just...

And I missed that. Definitely need the ORDER BY.

DesNorton (10/25/2016)

---

It can also be done without the CTE or the need for a @results table.

And since it's a single statement, there is no need for the explicit transaction.

CREATE PROCEDURE...

Try getting rid of the ON PRIMARY sections ... they're probably the default option, anyway. There's probably a bracket or a comma in the wrong place.

Multi-threaded testing suggests that READ COMMITTED works just fine, using your atomic code.

Thanks again.

What's the compatibility level of the database you're working in?

@Patrick123 (10/25/2016)

---

I am new to SSIS .I want to learn the difference between .DTSX and .ISPAC.I tried to google it but it some what hard to learn,Can anyone please let...

Thanks again.

I agree: time to attempt to crash it with some testing.

Nice, Luis.

Is SERIALIZABLE required in this case? Or would READ COMMITTED be enough?

You have your answer. Functions do not perform updates in T-SQL.

I'd welcome any helpful comments on the optimal handling of concurrency issues in this thread. Cheers!