Post
Ask Question
Sandeep Kumar

Sandeep Kumar

  • 1.1k
  • 684
  • 61.7k

Please write linq query of the below sql query

Jun 6 2023 9:47 AM

SELECT Count(*)
     
  FROM [BV_OCM].[dbo].[TblBatch]  WHERE      (DisposalStatus = 17) AND (ScheduleDisposalOn BETWEEN GETDATE() AND DATEADD(day, 1, GETDATE()))

SELECT Count(*)
     
  FROM [BV_OCM].[dbo].[TblBatch]  WHERE     (DisposalStatus = 17) AND (ScheduleDisposalOn BETWEEN dateadd(day,-8,GETDATE()) AND GETDATE())

SELECT Count(*)
     
  FROM [BV_OCM].[dbo].[TblBatch]  WHERE  (DisposalStatus = 17) AND (ScheduleDisposalOn >DATEADD(day, 1, GETDATE()))


Answers (2)