Respected Sir,
I want to calculate the amount for the sales from the 1st jan to tilldate .
im using the asp.net and c#.net .
Loading
Respected Sir,
I want to calculate the amount for the sales from the 1st jan to tilldate .
im using the asp.net and c#.net .
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Blocked AccountPosted May 1, 2008, 4:31 AM
Hi,
You can get the total amount by using this Query in side the Sp
select Sum(amount)as TotalAmount from TableName where [date] between '01/01/2008' and getdate()
Happy Coding!!