如何获取特定日期的确切数据 [英] How to fetch the exact data present on particular date

问题描述

我必须从日期= 06/22/2012
的表中获取count(*)

我的查询是

Hi,
I have to fetch the count(*) from the table where the date =06/22/2012

my query is

alter procedure sp_prodcount
 @SubSite_Id int,
 @callattend varchar(100),
 @callstart1 datetime
  
as
begin

SELECT  count(*) as '22nd june' FROM  Process_Details
WHERE  (SubSite_Id = @SubSite_Id) AND (Call_Attended = @callattend) 
AND  call_start >=(SELECT distinct CONVERT(VARCHAR(10),@callstart1,101)from process_details) 
end

EXECUTE  sp_prodcount 88,'FarheenS','06/22/2012'

需要紧急帮助
提前tnks，

Need urgent help
tnks in advance,

推荐答案

为什么不将开始datetime创建为datecomponent @ midnight，将结束datetime创建为datecomponent @ 2359，然后执行如果我正确地理解了您的问题，请开始< call_start<结束

Why don''t you create a start datetime as your datecomponent@midnight, and an end datetime, as your datecomponent@2359 then do a start<call_start<end

.
您想算一下在DATE有多少个电话

请尝试以下查询:-

if i correctly undersatnd your question..
you want count that how many call attented on peticular DATE

try below query:-

SELECT count(*) as '22nd june' FROM Process_Details
WHERE (SubSite_Id = @SubSite_Id) AND (Call_Attended = @callattend) 
AND CONVERT(VARCHAR(10),call_start,101)  = CONVERT(VARCHAR(10),@callstart1,101)

Create Procedure SP_ProdCount
	@SubSite_Id int,
	@callattend varchar(100),
	@callstart1 datetime
As  
Begin
 
SELECT	Count(*) '22nd june'
FROM	Process_Details
WHERE	(SubSite_Id = @SubSite_Id)
AND	(Call_Attended = @callattend) 
AND	DATEDIFF(D, call_start, @callstart1) >= 0 -- date of 'call_start' is equal or higher than @callstart1 date

End
 
EXECUTE  SP_ProdCount 88,'FarheenS','06/22/2012'

这篇关于如何获取特定日期的确切数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！