Thank you all for replying me. IT GOT SOLVED.

Hi Daniel,

thanks for replying me.

stored procedure is not created by me. so ic an not change it.i have to make use of that and do what ever needed to be...

thanks for replying.

i tookout the header .so based on the expression .

i kept head text using an expression . saying put column name when the row number is...

HI all,

thanks for replying me. i did not grouped them instead gace the order 1 or 2.

I WROTE THE EXPRESSIONS AS YOU SUGGESTED AND IT WORKED OUT.

THANK YOU

THANKS FOR REPLYING ME.

THIS I AHVE ACCOMPLISHED BY WRITING THE QUERY THAT RETURNS THE WAY I WANTED IN THE REPORT.

Thank you

THANKS FOR REPLYING ME

I DID LIKE THIS

select CAST(YEAR(GETDATE()) AS varchar(30))+

CASE WHEN Month(GETDATE()) >9 THEN '' ELSE '0' END

+CAST(Month(GETDATE()) AS varchar(30))

THIS DISPLAYS 201009

I NEED TO GET LAST TWO YEARMONTH FROM...

THANKS FOR REPLYING ME.

In the between clause it is returing only one value not more than one.

it just returns the start date and end date of that period.

I have not...

Thanks for Replying me.

Hello, thats what i wrote. but i needed something different.it is like this.when the denominator is zero it is displaying "Nan"

i dont wnat this way in the report.

I have an...

I GOT THIS ONE.

THANKS FOR REPLYING

hi lutzm,

period month,startmonth,endmonth are of type integers.still can i compare directly.does it give correct period results?

thank you

Hello lutzm,

i am not clear. is it that i can write query some thing like this.

select t2.* from table 1 t1 innerjoin table 2 on (t1.periodmonth beteen t2.statmonth ad t2.endmonth

)

can...

Thank you for your reply.

I got waht i wanted by using substring.

Thanks once agin for your reply.

HI Niraj,

Thanks for your reply. I am done withbthis report.actually i could not explain what i need . i tried comeup with some scenario but not explaned clearly.

now i am...

I am new into sql,

can you please be more clear.

Thank you