SQL, how to pass multiple values in a single parameter

CREATE procedure [dbo].[sp_rept_Online_QCL_StaticPoolWithLates]

 @EndDate datetime,
 @State char(2)



/******************************************************************
Created by:		
Created on:		4/22/2016
Description:	For the report   QCL Static Pool With Lates 
*******************************************************************/

AS
BEGIN



Select 
	LoanMonth,
	count(LoanMonth) as OriginatedNumber,
	SUM(LoanAmountFinanced) as OriginatedAmt,
	SUM(LoanAmountFinanced*totalPaymentsRequired)/SUM(LoanAmountFinanced) as WeightedTerms,
	SUM(LoanAmountFinanced*LoanAPR)/SUM(LoanAmountFinanced) as WeightedAPR,
	Sum(LoanAmountFinanced*CreditBeacon)/SUM(LoanAmountFinanced) as WeightedBeacon,
	---OPEN LOANS---
	SUM(Case When LoanStatusID in (1,7) Then 1 Else 0 END) as [ActiveNumber],
	SUM(Case When LoanStatusID in (1,7) THEN OPB Else 0 END) as CurrentOPB,
	SUM(Case When LoanStatusID in (1,7) THEN LoanAmountFinanced*LoanAPR Else 0 END)/SUM(Case When LoanStatusID in (1,7) THEN LoanAmountFinanced  END) as WeightedOpenAPR,
	SUM(Case When LoanStatusID in (1,7) THEN LoanAmountFinanced*CreditBeacon Else 0 END)/SUM(Case When LoanStatusID in (1,7) THEN LoanAmountFinanced  END) as WeightedOpenBeacon,
	---CLOSED LOANS---
	SUM(Case When LoanStatusID = 2 Then 1 Else 0 END) as [ClosedNumber],
	SUM(Case When LoanStatusID = 2 THEN LoanAmountFinanced Else 0 END) as [ClosedOriginatedAmt],
	SUM(Case When LoanStatusID = 2 THEN LoanAmountFinanced*LoanAPR Else 0 END)/SUM(Case When LoanStatusID =2 THEN LoanAmountFinanced  END) as WeightedClosedAPR,
	SUM(Case When LoanStatusID = 2 THEN LoanAmountFinanced*CreditBeacon Else 0 END)/SUM(Case When LoanStatusID =2 THEN LoanAmountFinanced  END) as WeightedClosedBeacon,
	---CHARGED OFF LOANS---
	SUM(Case When LoanStatusID in (5,6) OR (LoanStatusID not in (2,8) and  DaysLate>30) Then 1 Else 0 END) as [ChargeOffNumber],
	SUM(Case When LoanStatusID in (5,6) OR (LoanStatusID not in (2,8) and  DaysLate>30) THEN OPB Else 0 END) as [ChargeOffOriginatedAmt],
	SUM(Case When LoanStatusID in (5,6) OR (LoanStatusID not in (2,8) and  DaysLate>30) THEN LoanAmountFinanced*LoanAPR Else 0 END)/SUM(Case When LoanStatusID in (5,6) OR (LoanStatusID not in (2,8) and  DaysLate>30) THEN LoanAmountFinanced  END) as WeightedChargeOffAPR,
	SUM(Case When LoanStatusID in (5,6) OR (LoanStatusID not in (2,8) and  DaysLate>30) THEN LoanAmountFinanced*CreditBeacon Else 0 END)/SUM(Case When LoanStatusID in (5,6) OR (LoanStatusID not in (2,8) and  DaysLate>30) THEN LoanAmountFinanced  END) as WeightedChargeOffBeacon
	

	

From
(Select
	LoanDate,
	DateAdd(d,-Day(LoanDate)+1,convert(char(10),LoanDate,101)) as LoanMonth,
	totalPaymentsRequired,
	LoanAmountFinanced,
	LoanAPR,
	(Select top 1 StatusTransactionTypeID from tblStatusTransactions Where StatusTransactionLoanID=tblLoans.LoanID and StatusTransactionDate <=@EndDate Order by StatusTransactionDate desc)
	LoanStatusID,
	Case When CreditBeacon<100 Then null else CreditBeacon END as CreditBeacon,
	(Select Top 1 OpenPrincipleBalance from tblReportingTransactions Where LoanID=tblLoans.LoanID Order by ReportingTransactionID Desc) as OPB,
	(Select Top 1 DaysLate from tblReportingTransactions Where LoanID=tblLoans.LoanID Order by ReportingTransactionID Desc ) as DaysLate
From
	tblLoans
left join tblCreditApps
on tblCreditApps.CreditCustomerID=tblLoans.CustomerID
inner join tblWebStores  
on tblLoans.LoanStoreID=tblWebStores.LoanStoreID
Where WebStoreState in (@State) and LoanStatusID<>8 and LoanDate<=@EndDate and tblLoans.LoanStoreID between 800 and 849 )tblOut
Group by LoanMonth
Order by LoanMonth

END

GO

Select allOpen in new window