call function from stored procedure

[Prasanta_Prince]

How to call function from a Stored Procedure

[Prasanta_Prince]

I got one solution : Here it is,-

SELECT *
FROM table1
WHERE attribute1 IN (SELECT * FROM dbo.fn1('ab'))

modified on Friday, April 15, 2011 10:13 PM

[thatraja]

prasanta_prince wrote:

I got one solution

Glad you got one yourself.

prasanta_prince wrote:

Here it is,-
SELECT *
FROM table1
WHERE attribute1 IN (SELECT * FROM dbo.fn1('ab'))

BTW please put the code in code block always like below.

SELECT *
FROM table1
WHERE attribute1 IN (SELECT * FROM dbo.fn1('ab'))

Cheers.

thatraja

---

**My Tip/Tricks
My Dad had a Heart Attack on this day so don't...
**

[Prasanta_Prince]

Thanks , i will do it from next time..

[SilimSayo]

SET @my_variable =SELECT dbo.my_function(@my_function_parameter)