I may have things set up wrong. I have the radio button list values as 300, 350 400
So I'm checking for the selected value of the radio button and the request.querystring in the url. Now in store procedure I have this:
if @doc = 'F03'
begin
SELECT
doc,
COUNT(*) AS cnt
FROM
(
Select
doc
FROM pendingdds p
join Offices.dbo.OfficeCodes d
on d.officecode = p.doc
where d.typecode='7' and d.reportsto='F03'
Group By
doc, clms ) AS T
GROUP BY
doc
end
Do I need to set up a case statement to check for the value of the button that's selected?