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]

Re: Stored procedure - user defined function.

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%20Fil es\Microsoft%20 SQL%20Server\80 \Tools\Books\od s
sql.chm::/ods_6_con_00_6p 9v.htm

John
"JHB" <joern_bea@remo vedettetdcadsl. dk> wrote in message
news:4037bebc$0 $29362$edfadb0f @dread15.news.t ele.dk...[color=blue]
> 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
>
>
>[/color]