I have tried the 3 databases I could get access too and just cannot duplicate the issue you have. I have seen this same sort of thing noted in the...

OK that threw my theory a bit so I have a new one please try this and let us know what the query decides to do.

SELECT

  TRD......,

  CD.......,

  PD.......,

  Cur......,...

OK I thought so. The thing is this, even thou you have distinct all the rows will be handled first (meaning the function is fired for all rows) then distinct...

Try this as I want to know what happens when you do so then I may have the answer as to what you see that is happening.

DECLARE @x CHAR(8)

SET @x...

I say we start a jihad on all the Oracle DBA's, whose with me?

Oh sorry you meant "It Depends" on what you need...

Try sp_updatestats as well. Large tables tend to fall behind with AUTO STATS because that is based on a percentage of change before it actually runs, there was a thread...

What does you query look like for the actually run that calls the UDF?

Did you verify the connection object is setup correctly? It sounds like the connection object has the issue from what you say. Might be defined as server = localhost or...

Not sure you can do this in a set based method. Are you needing to do this across multiple rows returned by a signle query? If so and you can...

Going back to what I said that is the only business case I have ever been given that would warrant looking at not using any. I saw the comment earlier...

OK I finally found the article I had come across before as I have seen this. Take a look here and should help

http://support.microsoft.com/default.aspx?scid=kb;en-us;298725

How is the connection made? Specific user account or Windows Authentication.

If Windows Authentication keep in mind SQL Agent uses it's service account as the login and thus if it is...

Dumb question and usually the obvious first I ask but what is you maintenance like. Do you rebuild the indexes periodically, update usage, update stats and such to be sure...

OK let me ask the obvious missed question, what version of SQL Server are you running so if there are any known issues we can be sure we talk about...

Honestly for fast access you might want to attach with Access to review that field or Use SQL Reporting Services Deisgner in Visual Studio if RS is available. Otherwise look at...