Must declase Scaler Variable error on Multiselect parameter when I use IN statement in SP ?

• jbalbo

  SSCertifiable

  Points: 7580

  More actions

  February 13, 2014 at 9:06 am

  #288141

  Hi

  I am using a multiselect parameter @DiagnosisType

  My sp states ...

  ALTER PROCEDURE [dbo].[..._count]

  @StartDate datetime,

  @EndDate datetime,

  @Costcenter varchar(3),

  @DiagnosisType varchar(100)

  AS

  SELECT .....

  where (dbo.ClinicalType.Code in (@DiagnosisType))

  Thanks

  Joe

  in (@DiagnosisType))

  @DiagnosisType nvarchar(max)

• KS

  Hall of Fame

  Points: 3323

  More actions

  February 13, 2014 at 9:44 am

  #1688836

  Duplicate post. Original thread available here