@Fromdate varchar(10), @Todate varchar(10)
SELECT * into #TblPlatinumDate FROM OPENQUERY([MUMFRDBSACT], 'SELECT Distinct(Passenger_Pri_MobileNo) as MobileNo ,COUNT(*)as TripCount from [E2e_Tabcab].[dbo].[FR_TRANS_Booking] a (nolock) where IsCancel = ''0'' and Convert(DATE,PickupDateTime,105) BETWEEN ''+@Fromdate+'' and ''+@Todate+'' GROUP BY Passenger_Pri_MobileNo,IsCancel having count(IsCancel)>= ''46''')
DateTime
Date
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)