HOW TO SELECT DATA BETWEEN TWO DATES WITH AGGREGATE FUNCTION?

Question

4.00/5 (1 vote)

See more:

SQL-Server-2008

Hi !
I am trying to select data from table on the basis of two dates with the aggregate (sum) function. but it returns me the NULL value .. i am using this querry in sql server 2008.

SQL

select ISNULL(SUM  (SSI_MAIN_INFORMATION.PI_TOTAL_AMOUNT),0) AS TOTAL_SALES FROM SSI_MAIN_INFORMATION


WHERE PI_DATE >= CAST( @starting_date AS DATETIME)  AND  PI_DATE <= CAST ( @ending_date AS DATETIME)

both the dates which i give to store procedure are exist in data base but it still returns NULL.

Posted 16-Sep-12 3:13am

Asim8748

Add a Solution

Comments

grzelix25\ 16-Sep-12 9:28am

does procedure without aggregation sum function returns any data? The query seems to be ok.

1 solution

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)

Kaushik Saha from Kolkata,India · Accepted Answer · 2012-09-16T03:36:00

May be It will help.

SQL

create procedure my_sp_name
@starting_date datetime,
@ending_date datetime
AS
BEGIN
	
	SET NOCOUNT ON;
	select ISNULL(SUM  (SSI_MAIN_INFORMATION.PI_TOTAL_AMOUNT),0) AS TOTAL_SALES FROM SSI_MAIN_INFORMATION

WHERE PI_DATE >=@starting_date  AND  
---if you store date and time both-----then use below expresson
PI_DATE < dateadd(d,1,@ending_date)
----if you store only date-----then use below expresson
PI_DATE <= @ending_date
END

Happy Coding