stored procedure:
create procedure procedureName
(
@sla varchar(100) ,
@leftparam varchar(100),
@rightparam varchar(100)
)
as
begin
select rating,trendvalue from rptslastats
where sla= @sla and @leftparam = @rightparam
end
and you have to assign values as
@sla -> '" + dsReportName.Tables[0].Rows[p][0].ToString() + "'
@leftparam varchar(100) -> to_char(asondate,'mon yy')
@rightparam varchar(100) -> to_char(to_date('" + asondate.ToShortDateString() + "','mm/dd/yyyy'),'mon yy')
hope it works fine...