Issue with parameters

• mcfarlandparkway

  SSCertifiable

  Points: 7699

  More actions

  December 30, 2016 at 9:43 am

  #320161

  Hello,

  I have a function where I am passing 4 parameters

  FUNCTION [dbo].[Employee]

  (@ID varchar(120),

  @SCR nvarchar(3000),

  @Hw1 varchar(10),

  @HW2 varchar(10) = '%'

  )

  I am calling this function in another stored procedure when I called this

  select * from [dbo].[Employee](@ID,@SCR,'*')

  I am getting this error An insufficient number of arguments were supplied for the procedure or function Even after compiling the function.

• Thom A

  SSC Guru

  Points: 99133

  More actions

  December 30, 2016 at 10:02 am

  #1920124

  This is to be expected. Functions require every parameter to be passed, regardless of if you're going to use them all.

  Try:

  SELECT * FROM dbo.Employee(@ID, @SCR, '*', DEFAULT);

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk