when i tried to execute your code following error shown

Msg 8117, Level 16, State 1, Procedure Sp_Login, Line 19

Operand data type bit is invalid for max operator.

code working but it doesn't filtering the condition

Thank you very much .now it is complete

Hi friend iam very eager to your reply.

Hi,friend your second code is working fine.

i need one suggestion.

I want to display date in column header as 01,02,..31 instead of 01 oct 2013,02-oct 2013....31 oct 2013

i tried with datename...