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?...

Assuming 'NaN' is a string, the way I would...

I can't imagine...

philand3 (9/18/2016)

---

I want to display image based on another templatefield value.

Example person num(0010200) and image saved in folder is 00102000.jpg , if person num(01234) and image saved in folder is...

You got me. I feel a Jack Bauer "DAMN IT!" coming on 🙂