Posted by Plamen Ratchev on 01/24/08 17:45

Just for the sake of replicating what you were trying to do, in SQL Server
2000 you can use UDF:

CREATE FUNCTION dbo.B
( @x CHAR(1) )
RETURNS CHAR
AS
BEGIN
SET @x = (SELECT y FROM Bar WHERE x = @x
UNION
SELECT y FROM Bar WHERE x = @x)
RETURN @x
END

Then you can write the query like:

SELECT x, dbo.B(x)
FROM Foo
WHERE dbo.B(x) IS NOT NULL

HTH,

Plamen Ratchev
http://www.SQLStudio.com

• Next in forum: Re: Connection Logs in SQL Server
• Prev in forum: Re: NULL values in a SELECT in another SELECT
• Thread view: Re: NULL values in a SELECT in another SELECT

[Reply to this message]