I really don't know how to use an openquery in a "view".. plus I really want the Advantage database engine to filter my records in order to minimize the net...

Lynn,

As you can see I have been reading many postings in various forums in order to find the answer I have been looking for.

This is also related to my issues...

...and how do you pass a parameter from a function to a cmd batch file calling a proc??

I know that you can use the % in the batch files and...

hehe of course you can continue..

enjoy

:hehe:

have not we have had kicked this dead horse plenty..

I think we did..

:))

I guess I need to re-visit my previous posting here::

> I get connected to Adv Database via "linked server object" in sql

> use openquery calling the "linked" server--> using--> local...

I type faster ... .

😛

Up until 8 years ago; I was a software engineer and software development manager regionally and I had few rules in the department. Among those rules there were 2 of...

Wow... I guess for the first time I am stuck between a rock and a hard place in a simple TSQL.

It seems like there should be a way to have...

At this stage; I do not have an issue nor worry about the performance and the criterion selections.

All I am interested in is getting the result-set back 😀

-- Here are you and thank you again for your assistance::

--

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE FUNCTION ADV_UDF_GetEmp_ID

(

@EmpID nvarchar(10)

)

RETURNS

@tblGetEmp_ID TABLE...

Hi Lowel,

Here is the thing about the code, I did not know why the indentation were not the same as the "preview" here in the post zone.. however, I had...

Of course Lynn, thank you much!

Interesting observation my friend; however, I am trying to eliminate the "staging" area completely.

I do have a visual foxpro 5 second priodical asynchronization data going to sql from VFP folder(s)...

Good point, although, if stored procedure can do and return what the "function caller" needs then sure..

here is the thing;

There is another application that calls this function:

" select a,...