how to pass multiple date values to a single variable in sql

Question

Unable to pass multiple date value.

declare @Exdate date
set @Exdate = '2020-2-26','2020-2-27'

select * 
from X 
where Ex_Date in (@Exdate)

Tag the DBMS that you are using. – Yogesh Sharma Feb 27 '20 at 10:14 — Yogesh Sharma, Feb 27 '20 at 10:14

score 0 · Answer 1 · answered Feb 27 '20 at 10:14

0

You need to call split function :

select x.* 
from X cross apply
     dbo.splitfn(@Exdate, ',') as spt(dateval)
where x.Ex_Date = dateval;

Your variable (@Exdate) should have single string not multiple :

set @Exdate = '2020-2-26, 2020-2-27'

answered Feb 27 '20 at 10:14

Yogesh Sharma

49,081
5
23
49

here the possibility is like the date value may be a single date or multiple. Function needs to work for single date too – Dinesh kumar Mohan Feb 27 '20 at 10:53
@DineshkumarMohan. . . Yes. – Yogesh Sharma Feb 27 '20 at 11:01
@DineshkumarMohan. . . It is pseudo function name, need to change your function name. However, `2016 +` has default split function. You can use it. – Yogesh Sharma Feb 27 '20 at 11:28
@DineshkumarMohan. . . Then look at https://stackoverflow.com/questions/46902892/string-split-in-sql-server-2012/46902994#46902994 – Yogesh Sharma Feb 27 '20 at 11:31
i am using MSSQLServer2012 – Dinesh kumar Mohan Feb 27 '20 at 11:32

score 0 · Answer 2 · answered Feb 27 '20 at 12:37

Is you need different datetime values, you can declare table variable:

declare @Exdate table (
 date_value date
)
insert into @Exdate (date_value)
values ('2020-2-26'),('2020-2-27')
select *
from X where Ex_date in (select date_values from @Exdate)

how to pass multiple date values to a single variable in sql

2 Answers2