Using table UDF in a view

[Sibongile Khanyile]

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.
Please help.

*** Sent via Developersdex http://www.developersdex.com ***

[Erland Sommarskog]

Sibongile Khanyile (si****************@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx