i need Report to SQL Query kindly Help me.

--Create 2 temp table

create table #temp1

(

[S.no1] int,

Time1 time(7),

UserId1 int,

Date1 datetime,

Status1 varchar(50)

)

insert into #temp1([S.no1],Time1,UserId1,Date1,Status1)

SELECT * FROM [dbdoc].[dbo].[TestTable] WHERE Status='IN'

create table #temp2

(

[S.no2] int,

Time2 time(7),

UserId2 int,

Date2 datetime,

Status2 varchar(50)

)

insert into #temp2([S.no2],Time2,UserId2,Date2,Status2)

SELECT * FROM [dbdoc].[dbo].[TestTable]WHERE Status='OUT'

--Join tables

select #temp1.[S.no1],#temp1.UserId1,#temp1.Date1,(#temp1.Time1),#temp2.Time2,DATEDIFF(MINUTE, #temp1.Time1 ,#temp2.Time2) as t

from #temp1 inner join #temp2

on #temp1.Date1=#temp2.Date2 and #temp1.UserId1= #temp2.UserId2

--select * from #temp1

--select * from #temp2

drop table #temp1

drop table #temp2

sir The related records are comming from which tables and what are the fields

again which database u use like mysql.. 

I understand your problem you want that substract 2 row's time from 1st row and 4th row's time from 3rd row like (in time -in time, out time-last out time). Suppose table name is puchRecord. Use this query.

Regards,

Amit 

Hi,

Your question is not clear to me.Elaborate more.Specify platform,actual problem likewise,and expected output.