Re: GetDate as Parameter for UDF Function returns table
From: Steve Kass (skass_at_drew.edu)
Date: 10/24/04
- Next message: rr17_at_optonline.net: "Re: SQL Server Birth Date!"
- Previous message: Vaxman: "RE: Pros and Cons of starting the SQL services with a user account ins"
- In reply to: Liam Ponder: "GetDate as Parameter for UDF Function returns table"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 24 Oct 2004 10:52:48 -0400
Liam,
Table-valued functions can only receive literal constants and variables
as parameters. Functions, expressions, and column references cannot
be used as parameters.
Steve Kass
Drew University
Liam Ponder wrote:
>Help!!
>
>I am trying to pass GetDate() as a paramter into a function that returns a
>table.
>
>select * from
>dbo.hta2_Calculate_Closed_Inventory_By_Date( GetDate(),'10/30/2004','Company')
>
>This fails but it works if I pass in the date as a string. I need to use
>GetDate.
>
>I cannot create a local variable, this is a view.
>
>
- Next message: rr17_at_optonline.net: "Re: SQL Server Birth Date!"
- Previous message: Vaxman: "RE: Pros and Cons of starting the SQL services with a user account ins"
- In reply to: Liam Ponder: "GetDate as Parameter for UDF Function returns table"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
