Hi Team
I am getting a one specific value when im using where clause. Is there a better to get other values when IN statement inside parameters is used? Please have a look at my query below
select
[Station Description]
[Transaction Code],
[DateTime Passed]
from [Tracking_Server_DB].[dbo].TS_Station as stn
inner join [Tracking_Server_DB].[dbo].[Checkpoint Movement] as mv
on stn.[Transaction Code] = mv.[Transaction Code]
where stn.[Station Description] IN ('T0011', 'M250', 'T0011')
and [DateTime Passed] = '2021-08-26 22:49:19.000'
order by [DateTime Passed] desc