CAN ANY BODY SUGGEST ME.......
I NEED A QUERY SO THAT
IF I GIVE INPUT AS MONTH.....
THEN MY QUERY SHOULD DISPLAY THE DATA OF
CONSECUTIVE MONTH...
EXAMPLE:
IF I GIVE INPUT AS '12/31/2011'
THEN MY DATA SHOULD BE OF THE MONTH '01/31/2012'
NOW AM USING THIS QUERY:
SELECT MONTH([END]) AS MNTH, YEAR([END]) AS YR, COUNT(TASK) AS
DUENXTMNTH FROM XTASK WHERE status <> 'c' and MONTH([END]) <=12
AND YEAR([END]) <=2012 AND MONTH([END])>11 AND
YEAR([END])>2011 group by STATUS,MONTH([END]),YEAR([END])
IN THIS I NEED TO TWO INPUTS.....
BUT MY REQUIREMNT IS WE NEED ONLY ONE INPUT...
THANKS.....
...
Go to the complete details ...