I don't know why this query doesn't work for. can you help me please?
select (200/[traveltimeLkw])*3.6 as v_lkw, [entrytime] ,[vLkwCommon]
FROM [VRZ1010].[vdp_archiv_stv].[dbo].[STV_SVL_Archiv_20175] A
inner join [dbo].[DayCategory] B ON weekdayname='Mo' AND CONVERT(date,A.[entrytime])=B.[day]
where [roadcode]='A23_1' and [from2dk]>=9000 and [to2dk]<=10000