471,122 Members | 2,437 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,122 software developers and data experts.

Using table UDF in a view

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 ***
May 4 '07 #1
1 1536
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
May 4 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by Paul Reddin | last post: by
4 posts views Thread by Nathan Sokalski | last post: by
1 post views Thread by ratnakarp | last post: by
8 posts views Thread by Paul Hunter | last post: by
7 posts views Thread by Serge Rielau | last post: by
6 posts views Thread by insirawali | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.