Posted by Erland Sommarskog on 06/23/06 15:00

ujjc001 (ujjc001@gmail.com) writes:
> how would I use an inline udf in an existing stored procedure? I would
> need to pass in a field such as table.date below :
>
> SELECT
> (
> SELECT XDate FROM TimeFormat (table.Date, 'Month')
> ) AS formattedXDate,
> table.Title,
> table2.Title AS title2.....

Yeah, I asked myself he same thing. In SQL 2005 you could do it if you
use the CROSS APPLY operator, but in SQL 2000 there is not a way, as
far as I can see. Maybe Mike C# has some more tricks up his sleeve?

--
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]