How to paas a multivalued parameter in Table-Valued Function

• Hari.Sharma

  SSCertifiable

  Points: 6904

  More actions

  August 1, 2007 at 7:03 am

  #177758

  

  Hi All!

  I have written a Table-Valued Function say GetMonthName. This Functions has one parameter. When I pass a value in this function, its working fine but when I pass multivalued parameter then its showing an error message:

  Procedure or function dbo.DCBL_GetMonthName has too many arguments specified.

  How I can handle this problem?

  Thanks in advance...

  Hari

  Cheers,
  Hari
  Tips & Tricks for SQL BI Developers

• Crispin Proctor

  SSCoach

  Points: 18161

  More actions

  August 1, 2007 at 8:09 am

  #723871

  What is a multi valued parameter? You can only pass one parameter, that may include multi values.

  select * From dbo.MyFunc('1, 2, 3, 4') would be one param.

  Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!