As I said import everything into Staging table using Data Flow and then run MERGE by Execute SQL Task.

Or if by ssis you mean specifically Data Flow then use OLE...

From your explanation it look's like that your database design is very poor.

If you still want to perform the task, then I would suggest you to dump everything to staging...

You can use Profiler or Extended Events.

Why don't you verify this assumption by running the sub-query separately?

javib (3/22/2013)

---

I've also tried this other query, but all this does is bring back all reps that have more than one entry in the table. It doesn't filter the records...

sqldba_newbie (3/22/2013)

---

Let me tell you, i do know using hints should be the last option. I am really in a situation where i need to address a issue by hook...

Google?

Insert all 740K into a staging table and then do a MERGE.

Usually using SUM, WHERE and likely GROUP BY.

Your client application should do all the formatting, not a database server!

Thanks, Gail. It makes much more sense now.

ScottPletcher (2/21/2013)

---

Alexander Suprun (2/21/2013)

---

ScottPletcher (2/21/2013)

---

RAM is always used first to hold temp tables and table variables. But, if (and only if) RAM available for holding such rows is exceeded,...

ScottPletcher (2/21/2013)

---

RAM is always used first to hold temp tables and table variables. But, if (and only if) RAM available for holding such rows is exceeded, then rows are...

Run SQL Profiler against your...

DECLARE @ID INT = 2

SELECT TOP 1 * FROM #tTestTB

WHERE VisOrder < @ID AND TreeType = 'S'

AND EXISTS(SELECT * FROM #tTestTB WHERE...