noeld (2/2/2009)

---

Lynn Pettis (2/2/2009)

---

Oh, right, the World Cup is the only TRUE...

The change in formating the code may not affect performance. You may want to consider using a view on the linked server and see if that improves performance.

What code? My last comment was based solely on observation.

Your code:

select M.*

from DEV1.StatePA.dbo.Revenue as M ,...

hmm, interesting. OP has yet to answer questions posted.

Well, without the entire query it is difficult to know what needs to change to improve it.

Not sure, but it might be trying to pull all the data from each table over to the server you are running the query from before doing the join.

FYI, I'd...

Okay, never mind. That wasn't a good test. When you delete your post the count is adjusted. We'd have to have Steve tell us if we'd "lose...

RBarryYoung (2/1/2009)

---

Jeff Moden (1/30/2009)

---

Oh, I absolutely agree... when someone said that SSC would have 10-15 million members in 5-10 years, I made the correction that it would have 200 users...

Not too difficult. What have you tried so far?

Change this:

and (year(FromDt) = ' + @year + ')

to this:

and (FromDt >= dateadd(yyyy, cast(' + @year + ' as int) - 1900, 0) and FromDt < dateadd(yyyy, cast(' + @year...

I also have a ',' at the end of the select that will cause an syntax error due to the 'FROM' clause then being added to the dynamic sql.

Either that,...

I think there is a CASE statement missing in the dynamic sql as I have a WHEN but no corresponding CASE.

And you don't have to wait until you are a "Jeff" or "Gail" to write an article. I don't pretend to be at their level and I have written...

As asked before, what is the recovery model for the MOM onepoint database?

Oh, right, the World Cup is the only TRUE World Champsionship Game.

:w00t: