--THIS IS USE TO SELECT THE RECORD IN THE GIVEN DATE RANGE--
CREATE procedure StoreProcedureName
@From as nvarchar='',
@To as nvarchar=''
As
Select TableName.ID, TableName.TotalAmount, TableName.TotalDiscount , TableName.NetAmount From TableName where CONVERT(nvarchar,PostedDate,101) BETWEEN '04-28-2011' AND '04-28-2011'
Go
