Hi,
I have a requirement where I have given a SQL query which I need to Convert into Query Expression which will be used for retrieval of records in console apps.
Please find the query below:-
Select d.new_DepositNo,d.new_EmailID,d.new_MobileNumber,d.new_DepositStatus,d.new_PaymentType,d.new_BankName,d.new_ManAccountsDetails,w.new_WarAmt,w.new_WarDate
From new_depositmaster d With (nolock) Join new_mwarrants w On w.new_depnumber = d.new_DepositNo
Where d.new_DepositStatus = 'R' and d.new_PaymentType in ('RTGS','WARRANT') and cast(w.new_WarDate as date) = cast(GETDATE() as date)
Regards,
Shoaib Khan.
