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

• Next in forum: Re: How to find first not null value in column
• Prev in forum: Re: ORDER BY in VIEW not working
• Thread view: Re: Workstation date

[Reply to this message]