Database

T2102 wrote:

I have gotten some pivots to work with arbitrary # of columns, but I've had to use dynamic sql.

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

prasanta_prince wrote:

I got one solution

prasanta_prince wrote:

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

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

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

r.kh wrote:

please send me the er of codeproject.com

prasanta_prince wrote:

What do you mean by er ?