Posted by Mike C# on 06/23/06 23:33

Nope, just wrapping it in another scalar UDF LOL. I misread it and didn't
realize he was passing them thar columns in.

"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns97EBAD153EDDAYazorman@127.0.0.1...
> 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]