How to fetch the exact data present on particular date

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

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

my query is

SQL

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'

Need urgent help
tnks in advance,

Posted 27-Jun-12 12:13pm

Member 8058334

Updated 27-Jun-12 23:02pm

AshishChaudha

v2

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

barneyman · Answer 1 · 2012-06-27T14:44:00

Solution 1

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

Posted 27-Jun-12 14:44pm

barneyman

Updated 27-Jun-12 14:45pm

v2

ssd_coolguy · Answer 2 · 2012-06-27T18:54:00

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

try below query:-

SQL

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)

Raza us Samad · Answer 3 · 2012-07-04T23:49:00

SQL

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'

How to fetch the exact data present on particular date

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0