how write a stredprocedure to get the date from 1st jan to tilldate

Question

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 .

Manish Dwivedi · Answer

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!!