Posted by Erland Sommarskog on 02/01/06 00:15
lemes_m@yahoo.com (lemes_m@yahoo.com) writes:
> First, I have to notice that I use MS Access 2003 as Front-End.
I will have to notice that I don't know Access.
> Now I got two problems: I tried to create function which uses @SomeDate
> parameter to limit results but I can't get it work.
CREATE FUNCTION someorders (@somedate datetime) RETURNS TABLE AS
RETURN (SELECT OrderID, CustomerID
FROM Northwind.dbo.Orders
WHERE OrderDate >= @somedate)
go
select * from someorders ('19980101')
> Another problem is how to pass @SomeDate value when I execute stored
> procedure which is joined with this function...
Join a procedure with a function?
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
[Back to original message]
|