As I expected; the test for the view takes 20+ second to run and I have not tested it from running a function yet.. that's next

There are highly interested in this issue and I wrapped up my stuff and hoping to finish this thing pdq..

:))

I see 🙂

would this go inside the view also:

GO

SELECT

ed.*

FROM

dbo.EmpData ed

WHERE

ed.ID = '22026'

GO

I modified a little and it runs and returns two records...

select

*

from

openquery(ads_link1111,

'SELECT

[BRGEMP].[ID],

ltrim(rtrim([BRGEMP].[LNAME])) ,

...

I am on a conference call with the development team and my boss about this issue and see if I have job by the end of the day .. hehehe...

yes, that is not a problem I was experimenting something.. but they will be and should be using the @emp_id that comes in as a param..

That's alright if you can not do the phone deal... well, I guess this is going to be a T-Shirt winner after all and after I post the complete scenario...

Would you like me to call you on the phone?

You are more than welcome to call me 949.973.5234

either way, I think we can save some time this way and post...

here is the 99 beers on the wall 😛

please refer to the link in below::

http://www.sqlservercentral.com/Forums/Topic711409-338-1.aspx

It looks good, but there is no way that I can get away with multiple query structure trying to run in a view. This will require some dynamic string building...

I am to a point that need to make a decision on whether I should redesign the function-callers structure rather than trying to convert the existing functions to return the...

yes, of course, not too worry about the a little performance hit, but, we are talking about brining the entire table or even the entire result-set from a possible complex...

...Let me ask you this::

I know that there are some xp and CLRs that can be called from a function, no? If that is the case do you think...

Also, if you recall Lynn I had to use a dynamic statement since there are various parameters from within a proc.. so, I am not sure this would work in...