You are right... Now it has worked... Thanks a lot...

- Milind

Hi,

The output do not come as I expect.

What i want is all the InTime values of 31days should come in one row. All the OutTime values of 31 days...

Hello,

Following is the script

CREATE TABLE [dbo].[tblInOutTime](

[nCounter] [numeric](18, 0) NOT NULL,

[nCounterWorkPermit] [numeric](18, 0) NOT NULL,

[dtInOut] [datetime] NULL,

[vInOutTag] [varchar](1) NULL

)

insert into tblInOutTime (nCounter,nCounterWorkPermit,dtInOut,vInOutTag) values ('1','1','7/29/2011 14:00','I')

insert into tblInOutTime (nCounter,nCounterWorkPermit,dtInOut,vInOutTag) values ('2','1','7/29/2011...