Stored procedure - user defined function.

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

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

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode test 33Switch to Hybrid Mode Switch to Threaded Mode

1 6th March 15:00 jhb External User Posts: 1	Stored procedure - user defined function. Hi. I'm really new to MSSQL, so therefore my question can sound stupid. 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