Mukesh Kumar Tiwari

Mukesh Kumar Tiwari

  • 1.2k
  • 1k
  • 213.2k

Hwo to convert this query in LINQ.

Dec 10 2015 2:26 PM
Hi frnds....
 
i have to  convert this query. So please lead me, or help me out.....
 
SELECT sum(Qty), Sum(round(errprice * Qty,2)) as 'Price' FROM ViewNoSale where tx_number=-1 and First_Name = 'Girish' and canceltime between '2015-12-10 00:00:00' and '2015-12-10 23:59:59' and date_format(Canceltime,'%m-%d-%Y %h:%i:%p') IN (select date_format(NSTime,'%m-%d-%Y %h:%i:%p') from nosale, tx_err_log where tx_err_log.userid=User_id and tx_err_log.registerno=reg_no and NSTime between '2015-12-10 00:00:00' and '2015-12-10 23:59:59')
 
 
 
Thnaks..... 

Answers (1)