May 27, 2008 at 1:05 pm
Hi
I have created a UDf UDF_GETVAL which takes in a param does processsing and returns final val.
It works fine if I use as
Select dbo.UDF_GETVAL('123') From Employee
But When I Give it a dynamic value I get null ..for eg
Select dbo.UDF_GETVAL(Employee.ID) From Employee
Can some one help.
Thanks
May 27, 2008 at 2:00 pm
Well, in the first one you passed in a varchar parameter ('123') and in the second one you passed in int (Employee.ID), apparently.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 27, 2008 at 2:34 pm
Hi
Actually my function accepts a varbinary..
When I give
select udf_getval(binaryvalue) works fine
but select udf_getval(employee.ID) from employee it returns null..
employee.ID is a varbinary.
Thanks
May 27, 2008 at 2:44 pm
guess we would have to see the code then.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply