Posted by Erland Sommarskog on 05/04/07 07:20

Sibongile Khanyile (sibongile.khanyile@sita.co.za) writes:
> If anyone can help... I have a function that takes one parameter and
> bring back quite a lot of records. but with a conventional function the
> field size has a limit of 8000 and i can not use field type 'text'. the
> limit has been reached and the view does not bring back results. an
> option i found was to use a table function. but with my limited
> experience with table udf's, I am failing to use it within a view. I am
> passing a value from the view as a parameter to use in the function and
> it doesnt work.

Which version of SQL Server are you using? If you are on SQL 2000, you may
be out of luck. If you are on SQL 2005 you should look into the new APPLY
operator.

But it could really help if you could clarify you question by posting
your UDF and your view, so we can get idea of what you are working with.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]