Thanks for your help.

Well, found out partially why it takes so long. I am dumping the data from the view into a table... 15 or so minutes now, with 189k rows atm,...

Same as yours Lynn. For FY 2009, it is July 08 - June 09

Here is the where clause..

WHERE DATEPART(m, [Recd Date]) 6 AND @month <= 9...

I have fixed the first function... we have filtered/proxied internet, which wouldnt allow me to post, so I had to email myself everything, not sure how it got lost. ...

So is this standard for linked servers? Or just non-microsoft sql servers?

[Edit] I am a programmer, not a DBA, just happens that I'm the only one here that has a...