Stored procedure - user defined function.

[JHB]

Hi.
I'm really new to MSSQL, so therefore my question can sound stupid.

Is it possible to use a function written in a module in MS-ACCESS in a
stored procedure?
Or how can it be done, it is a complicated function with loop and more.

I'll appreciate all answers also negatives ones.

TIA
Jørn

[John Bell]

Hi

You may be able to call the function from a linked server, but in general I
don't think it will perform well. You would be better re-writting it as a
SQL Server function, stored procedure or an extended stored procedure.
See books online:
mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\ods
sql.chm::/ods_6_con_00_6p9v.htm

John
"JHB" <jo*******@removedettetdcadsl.dk> wrote in message
news:40***********************@dread15.news.tele.d k...

Hi.
I'm really new to MSSQL, so therefore my question can sound stupid.

Is it possible to use a function written in a module in MS-ACCESS in a
stored procedure?
Or how can it be done, it is a complicated function with loop and more.

I'll appreciate all answers also negatives ones.

TIA
Jørn