ALTER FUNCTION [dbo].[GetFundType] 
(
	-- Add the parameters for the function here
	@FundBodyID int,
	@ACYear varchar(5),
	@CA varchar(5),
	@Element varchar(5) = ''
)
...

Msg 313, Level 16, State 2, Line 1
An insufficient number of arguments were supplied for the procedure or function dbo.getfundtype.

quote:

---

Originally posted by gavinjb

Hi,

I am trying to write a function to use optional paramters

ALTER FUNCTION [dbo].[GetFundType] 
(
	-- Add the parameters for the function here
	@FundBodyID int,
	@ACYear varchar(5),
	@CA varchar(5),
	@Element varchar(5) = ''
)
...

But when I call this function with
select dbo.GetFundType (1, '09/10', 'MyCA') and with no last parameter I get the following error, any ideas:

Msg 313, Level 16, State 2, Line 1
An insufficient number of arguments were supplied for the procedure or function dbo.getfundtype.

Thanks,


Gavin

---

ALTER FUNCTION [dbo].[FULL_NAME] (
@PreFixName nvarchar(20) = Null
,@FirstName nvarchar(40) = Null
,@MiddleName nvarchar(20) = Null
,@LastName nvarchar (40) = Null
)  RETURNS nvarchar(128) --Patient Full Name

/***************************************************************************
Concatenates the parts of a persons name with the proper amout of spaces
***************************************************************************/

AS BEGIN

set @PrefixName   = isnull(@PrefixName, '')

set @FirstName    = isnull(@FirstName, '')

set @MiddleName   = isnull(@MiddleName, '')

set @LastName     = isnull(@LastName, '')