CREATE FUNCTION MyFunction
(
    @foo int
)
RETURNS varchar(7500)
AS
RETURN
(
SELECT MAX(MyColumn)
-- Start of Test Execute
-- SELECT TOP 10 *
FROM   MyTable XXX
WHERE  ... some stuff ...
       AND NOT EXISTS
       (
           SELECT *
           FROM   MyTable YYY
           WHERE  ... Some Stuff2 ...
                  AND YYY.ID <> XXX.ID
       )
-- End of Test Execute
)
GO

quote:

---

Originally posted by Kristen

Are sub-selects not allowed in scalar functions?

---

USE Northwind
GO

CREATE FUNCTION udf_myFunction99(@rs int)
RETURNS int
AS
  BEGIN
  	DECLARE @x int
	SELECT @x = 
	       (SELECT COUNT(*) 
		  FROM Orders o 
		 WHERE EXISTS (SELECT * 
				 FROM Orders i 
				WHERE o.OrderId = i.OrderId)
		)
  RETURN @x
  END
GO

SELECT dbo.udf_myFunction99(1)
GO

DROP FUNCTION udf_myFunction99
GO