How to use where clause in sql server?

Question

Hi team

I am using where clause and my return results i get one value record list, is there a way within my IN statement i can also get other values by using where clause statement. See below image results.

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

In summary want to get other values('T0011', 'R600', 'M000'), currently im receiving M250 only, hope make sense now.

Dinesh D · Answer

Hi I think this code will help you. 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 Cast ([DateTime Passed] as Date ) = '2021-08-26' order by [DateTime Passed] desc

Abhishek Chadha · Answer

Might be your data condition is not satisfying for another record as you pass the date-time with seconds you need to convert this date to proper date only for conversion refer below - https://www.sqlshack.com/sql-convert-date-functions-and-formats/ First try to remove the date condition and check if both records are coming to confirm something is not wrong with IN condition

Ganesan C · Answer

You have added two conditions in where clause. Description and DateTime Passed. Might be the only one record value has satisfied this both condition. Pls check remining record's DateTime passed value.