UFD in Stored Procedure

[emcevoy]

hi

I am wondering if any of you have any samples of using a UFD in a stored procedure to pass the function a datetime.

I am using crystal reports which cannot see UFD's but can pass a stored proc a variable.

If anyone has any samples I would be extremely greatfull!

thanks

Eileen McEvoy
Authorized Crystal Engineer
Crystal Reports Consultant and Trainer

http://www.crystalconsulting.ca

emcevoy@crystalconsulting.ca

 

[nigelrivett]

Do you mean udf?
Do you mean getdate()?

declare @d datetime
select @d = getdate
select id, dbo.myfunc(id, @d)
from tbl



======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.