How do I add these statements to this query:( Datediff(DAY, filedate, Getdate()) > 300 ) ( Datediff(DAY, filedate, Getdate()) > 350 ) ( Datediff(DAY, filedate, Getdate()) > 400 )if @doc in ('V01')Begin Select DOC, Reg, FO, CLMS, Age = Datediff(day,max(filedate), getdate()),FileDate = max(FileDate),o.mailingaddressstate as DDS,o.ddsofficecode as DDSCode,Min(ddsrcpt) AS DDSReceipt, DDSAge = Datediff(day,min(ddsrcpt), getdate()), Title = case when min(p.Title) <> max(p.Title) then 'Concurr' else min(p.Title) endFrom (select *, row_number() over (Partition by ddsrcpt order by ddsrcpt) as rownum from pendingdds) pjoin offices.dbo.doorsinfo oon o.officecode = p.fowhere doc in ('V01', 'S67', 'S41', 'S66') AND ( Datediff(DAY, filedate, Getdate()) > 250 ) Group By FO, Reg, DOC, CLMS, o.mailingaddressstate, o.ddsofficecodeorder by p.fo, age , DDSReceipt descEndI have radio buttons on the client side page. The page comes in as a default as 250 pending. If you select 300 I want that info to appear.
adding more to a query
Posted - 2012-02-29 : 13:02:05
. I will have to make four stored procedures to get the items I want out unless you know of another way I could approach this.