I am getting error SQL Errors occurred while processing retrieved data: Error converting data type varchar to bigint.
This my Query and its come from the where clause. Anyone help me to resolve this issue?
DECLARE @Inven VARCHAR(500) SET @Inven = CONVERT(varchar,?) SELECT count(tc.Name) FROM Booking b inner join BookingPassenger bp on bp.BookingID = b.BookingID inner join PassengerJourneyLeg pjl on pjl.PassengerID = bp.PassengerID WHERE il.InventoryLegID in (select value from STRING_SPLIT(@Inven, ','))
here ? will be = 12334,9899,343534