Can you paste the text of the error message, please?

GilaMonster (9/21/2016)

---

I strongly recommend you reconsider the entire process.

Leave .net out, other than to call the stored procedure. Write the load process in T-SQL in a single batch. Do the...

Sue_H (9/20/2016)

---

Phil Parkin (9/20/2016)

---

Sue_H (9/20/2016)

---

You could try changing your temp tables to global temp tables and see if that makes a difference. What you are seeing can often happen with...

This feature is deprecated (see here).

So I suggest you consider an SSIS/CDC solution, as recommended by MS, instead.

Sue_H (9/20/2016)

---

You could try changing your temp tables to global temp tables and see if that makes a difference. What you are seeing can often happen with DBMail as it...

Sue_H (9/20/2016)

---

You could try changing your temp tables to global temp tables and see if that makes a difference. What you are seeing can often happen with DBMail as it...

If you execute the proc in SSMS, presumably no results are returned either?

TomThomson (9/20/2016)

---

Phil Parkin (9/20/2016)

---

BrainDonor (9/20/2016)

---

New t-shirt for dress-down Fridays - https://www.amazon.com/Trend-Could-Thinking-Would-Great/dp/B01M0TJS26

But I don't know if I can - shouldn't the first full-stop be a comma? I think it would read...

dbodell (9/20/2016)

---

You know that is an interesting comment because I recently changed the code to use MERGE instead of separate INSERT and UPDATE processes. Removing and rebuilding the indexes was...

If you are dropping the index before doing the...

BrainDonor (9/20/2016)

---

New t-shirt for dress-down Fridays - https://www.amazon.com/Trend-Could-Thinking-Would-Great/dp/B01M0TJS26

But I don't know if I can - shouldn't the first full-stop be a comma? I think it would read better and it...

jay-125866 (9/20/2016)

---

Thanks,Phil. I've tried your code and it worked as expected. However, in my case, there are still some problems. In the original post, I over simplified the SP...

dbodell (9/20/2016)

---

I have an ETL process for which the processing time is varying wildly and with no apparent cause. I am looking at a graph of the amounts of time...

Your begins and ends may be confusing things. Try this:

CREATE PROCEDURE MyStoredProcedure2

AS

BEGIN

SET NOCOUNT ON;

INSERT ...

I know technically a table without a clustered index is considered a heap, but I believe that most people would assume that it has no order to it then, right?...