Re: NULL values in a SELECT in another SELECT
- From: "Plamen Ratchev" <Plamen@xxxxxxxxxxxxx>
- Date: Thu, 24 Jan 2008 12:45:13 -0500
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
.
- References:
- NULL values in a SELECT in another SELECT
- From: Hiho
- Re: NULL values in a SELECT in another SELECT
- From: Plamen Ratchev
- Re: NULL values in a SELECT in another SELECT
- From: Hiho
- Re: NULL values in a SELECT in another SELECT
- From: Plamen Ratchev
- Re: NULL values in a SELECT in another SELECT
- From: Hiho
- NULL values in a SELECT in another SELECT
- Prev by Date: Re: NULL values in a SELECT in another SELECT
- Next by Date: Re: Connection Logs in SQL Server
- Previous by thread: Re: NULL values in a SELECT in another SELECT
- Next by thread: Re: NULL values in a SELECT in another SELECT
- Index(es):
Relevant Pages
|
