How can I execute a UDF on multiple rows?

Question

I have a user defined function defined in SQL Server. I want create a single select statement that would be able to execute the function on all rows in a particular column. Is this possible and what would be the best way to do it?

Thank You

I saw this 'Execute table-valued function on multiple rows' and dont believe it answers my question.

Execute table-valued function on multiple rows?

GSerg · Accepted Answer · 2009-04-15 20:39:42Z

4

select dbo.YourFunc(column) as result
from table

PS: Stop thinking procedurally! It's a set-oriented language :)

answered Apr 15, 2009 at 20:39

GSerg

78.8k18 gold badges173 silver badges377 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How can I execute a UDF on multiple rows?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related