为什么我的存储过程无法执行？

I am having trouble abstracting data using a parameter of table type in my stored procedure below. The data that I am abstracting from consists of over 100 columns/variables. In the stored procedure I focus on four variables: Age_CNT (Age), SEX, ADMSNDT (admission date), and DGNS_CD01 (diagnostic code 1). Variable DGNS_CD01 or diagnostic code 1 has multiple possibilities. For example, in the code below I am looking to abstract records with DGNS_CD01 or diagnostic code value of 390, 391, or 459. Since DGNS_CD01 can have multiple values I declare a variable of type table called @DiseaseCodes and insert values 390, 391, and 459. However, when I execute the stored procedure I find that it does not work with parameter @DiseaseCodes and I cannot figure out why. The other parameters work just fine except @DiseaseCodesI am having trouble abstracting data using a pa