executing a function - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

executing a function

Author

Topic

sqlnovice123
Constraint Violating Yak Guru

262 Posts

Posted - 2010-03-31 : 17:28:19

Hi,

I have a function that expects two parameters

@TradeDate datetime,
@Maturity datetime:

How do I execute the function?

I tried execute YtM '20240201', '20150301' but I do not see any results.

Thanks for your help

PackRat
Starting Member

26 Posts

Posted - 2010-03-31 : 17:36:24

if its a scalar function;

SELECT dbo.YtM('20240201', '20150301')

or

SET @SomeVar = dbo.YtM('20240201', '20150301')

if its a table valued function

as a table

SELECT [YTM].[column name]
FROM dbo.YtM('20240201', '20150301') [YTM]

or

[CROSS|OUTER] APPLY dbo.YtM('20240201', '20150301') [YTM]

if its actually a procedure
EXEC[UTE] YtM '20240201', '20150301'

_____________________________
wrote this on my TRS-80 COCO4

<PakRat/>

sqlnovice123
Constraint Violating Yak Guru

262 Posts

Posted - 2010-04-01 : 14:29:57

Thanks for your help.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources