Do you have a small segment of one of the scripts that you have to run through openquery (Or one of the whole scripts if they're relatively short)?

Something that's generic...

The *= stuff is the old style. Don't use this. It won't work in 2008 and it's just confusing.

The reason you are filtering more out on the above...

I'd go that route personally (and do). Is that TVF an inline TVF or a Multi-Line TVF?

Ninja's_RGR'us (4/8/2010)

---

Garadin (4/8/2010)

---

Ninja's_RGR'us (4/8/2010)

---

Garadin (4/8/2010)

---

Chris Morris-439714 (4/8/2010)

---

Ninja (Remi?)

Sympathies mate. How much leeway do you have with the db? Can you for instance sneak in a trigger here and there, and...

You've tried... the query I wrote? Or the one you wrote below that is totally different?

If the goal is to eventually to get rid of the table, then...

insert into destinationtable [Fields...]

SELECT DISTINCT [Fields...]

from sourcetable

Ninja's_RGR'us (4/8/2010)

---

Garadin (4/8/2010)

---

Chris Morris-439714 (4/8/2010)

---

Ninja (Remi?)

Sympathies mate. How much leeway do you have with the db? Can you for instance sneak in a trigger here and there, and maybe a...

The query hasn't changed, but the underlying data, index fragmentation, statistics accuracy etc. all has. It could also have just had a "bad" plan.

I've had 1 particular query that...

Here's some information on what might be happening.

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/e90c853b-6018-41b0-9dd1-abd2ac872f16

http://msdn.microsoft.com/en-us/library/ms143380.aspx

Have you tried Linked Servers?

Chris Morris-439714 (4/8/2010)

---

Ninja (Remi?)

Sympathies mate. How much leeway do you have with the db? Can you for instance sneak in a trigger here and there, and maybe a link table?

It's...

Ninja's_RGR'us (4/8/2010)

---

Chris Morris-439714 (4/8/2010)

---

Ninja (Remi?)

Sympathies mate. How much leeway do you have with the db? Can you for instance sneak in a trigger here and there, and maybe a link...

You can change the day of the week, but as I mentioned in an earlier...

Paul White NZ (4/8/2010)

---

Scalar T-SQL functions suck.

Multi-statement T-SQL functions suck more.

In-line T-SQL functions are awesome.

Multi-statement functions do have their uses - but only if the logic cannot be written in...

[Edit] Ack, thought I had scrolled down all the way, apparently I was wrong.

Since I've posted anyways, might as well mention that doing it this way automatically adjusts for language...