thank you sooooooooooooooooooooooooooooooooooooooooooooooooooooo much for your help jack.

your code worked.

thank you soooooooooooooooooooooooooooo much for your help.

i have data in my table.i need to count the open issues for today ,30 days back,90 days back,180 days back.

i wrote a stored procedure

select projectname,count('x') as "today's count",(select...