Jeff Moden (2/2/2009)

---

rich.ramos (2/2/2009)

---

The PeopleTools upgrade would not affect the field order of custom records. And the column order does not affect the way the PeopleSoft application interacts with...

Third post was the only idea I could give you without the entire query.

It would be, my hope, that the join between the two "tables" would occur on the linked server instead of the linking server.

As I said earlier, don't be surprised if it is pulling the entire data set over to your server and then performing the join locally on the server with the...

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