Mam zapytanie jak poniżej:

DECLARE 

@DateImported varchar(10),
@TotalCaseDetailsIdCount int, 
@TotalTransferedCapital decimal(18, 2)

SET @DateImported = @DateImported1

select
    @TotalCaseDetailsIdCount = count(DD.DocumentNumber),
    @TotalTransferedCapital = sum(DD.TransferedCapital)
from
  DocumentDetails as DD
join CaseDetailsView as CDV on CDV.CaseDetailsId = DD.CaseDetailsId
where
CDV.ClientId = 1
and
CDV.ClientProductId in (4,1005,1048,1049)
and
(convert(varchar(10),CDV.DateImported) in (@DateImported1))

SELECT
'<300' as [Kategorie wartości spraw]
,count(DD.DocumentNumber) as [Ilość zleceń]
,sum(DD.TransferedCapital) as [Wartość zleceń]
,sum(CDV.PaymentValue) as [Wartość wpłat]
,sum(case when CDV.CaseStatus = 'Wycofana' then CDV.CurrentCapital else 0 end) as [Wartość wycofań]
,@TotalCaseDetailsIdCount as [Zleceń łącznie]
,@TotalTransferedCapital as [Kapitał lacznie]
,sum(case when CDV.DateImported in (@DateImported) then DD.TransferedCapital else 0 end) as [Wartość zleceń ogólnie]
,(sum(CDV.PaymentValue))/(sum(DD.TransferedCapital)) as [Skuteczność bez wycofań]
,(sum(CDV.PaymentValue))/(sum(DD.TransferedCapital)-sum(case when CDV.CaseStatus = 'Wycofana' then CDV.CurrentCapital else 0 end)) as [Skuteczność z wycofaniami]
from
CaseDetailsView as CDV
join DocumentDetails as DD on CDV.CaseDetailsId = DD.CaseDetailsId
where
DD.TransferedCapital < 300
and
CDV.ClientId = 1
and
CDV.ClientProductId in (4,1005,1048,1049)
and
(convert(varchar(10),CDV.DateImported) in (@DateImported1))
UNION ALL
.............

Wartości do parametru @DateImported1 pobierane są z:

SELECT DISTINCT
  convert(varchar(10),CaseDetailsView.DateImported) as [DateImported]
 FROM
  CaseDetailsView
  where (CaseDetailsView.ClientId = @ClientId or @ClientId IS NULL)
  and (CaseDetailsView.ClientProductId in (@ProductId))
order by  convert(varchar(10),CaseDetailsView.DateImported) ASC

Problem polega na tym, że w momencie wyboru kilku dat wyświetla błąd:

"Błędna składnia w poblizu ","".

W momencie wyboru jednej daty z parametru raport generuje się normalnie.