Actuallly Chris, that's already been tried, and it returns the entire database worth of stuff - at least according to the OP, anyway.

ChrisM@Work (8/14/2014)

---

This is worth a try:

SELECT *

INTO...

Have you tried using a variable to contain the EXEC statement? Also, what results are you getting or not getting? Any errors ?

EDIT: Hold the phone......

I guess that will teach me not to trust older MS articles. I don't mess with triggers often, and I personally wouldn't set a trigger on a view,...

sgmunson (8/14/2014)

---

Change each LEFT OUTER JOIN to an INNER JOIN, from my final query (not your modified version), one at a time, in order from topmost to bottommost, testing the...

Change each LEFT OUTER JOIN to an INNER JOIN, from my final query (not your modified version), one at a time, in order from topmost to bottommost, testing the result...

I think you just need to take the point of view of the trigger. Triggers operate with tables, but can fire off of a view, so the INSERTED...

Gentlemen,

You can all argue the merits, or lack thereof, of SSMS all day long, but it's not going to help anyone with anything. There ARE some facts that...

Okay, I got to it sooner. Try this:

WITH OFFICES AS (

SELECT 'KBE ANR' AS OFFICE_CD, 'BELGIUM' AS COUNTRY_DSC UNION ALL

SELECT 'KBE ZEE', 'BELGIUM' UNION ALL

SELECT 'KEU ANR','BELGIUM' UNION...

Okay.... I'll need to refactor the query by moving the table order around and see what I can come up with. Give me a couple hours as...

Have you checked the tables to be sure those fields still have the names that the article was using? That article looked kind of old, and the field...

I fail to understand what the discomfort level is with CTEs. It's kind of like having a subquery, but just that it appears BEFORE the rest of the query...

Something is obviously not right if you're getting those errors. However, without knowing exactly what you have typed into SSMS, we have no way to know what the...

faisalfarouqi (8/13/2014)

---

[font="Comic Sans MS"]Thanks! sgmunson for looking into it. I'll try the index option but the key is quite compley and will utilize a heck lot of space and then...

Indeed, 9 million rows is an awful lot of data. Also, even assuming the report still has to exist, your execution plan is suggesting an index creation that...

Former post content:

Attachment is no good...

Current post content:

Never mind... I did it wrong...

Sorry, folks....