User defined function within another User Defined function

[VK Cadec]

Hi - As the subject lines suggests - can we do this in SQL 2005? suppose I have a function_A - does certain calculations. CREATE another_function_B (@driver int) RETURNS int AS BEGIN declare @output as int -- checks some certain type of conditions and then executes function_A select @output = dbo.function_A(@driver) return @output END

[Colin Angus Mackay]

I don't see why not. Why didn't you just try it and see?

---

Upcoming Scottish Developers events: * Glasgow: Tell us what you want to see in 2007 My: Website | Blog | Photos

[VK Cadec]

I did - it didn't get any results, which it should have. that is why decided to post a message. I tried to debug the 'function' by using print statements but looks like that doesn't work. How could we write some debug statement?

[ednrgc]

Verify each item outside the UDF. That way you will see if it actually returns data.