Declare @rightId int = 1405;
SELECT RouteID, @rightId FROM Route
WHERE RouteURI IN
(
'/api/ledger/payment/paymentInfo'
)
for above query i will get one record in result.
But my requirement is if i have @rightId = '1405,23.999'
then i want the three records in result with the above query.
How to implement query for that ?