Hi,

Yes this is sample.

Please ignore duplicate entries.

Hello Livi.

Thanks for your efforts.

I would like to know the total hours details like this ( Total hours = first IN - first OUT )

each day i need to see...

action_idcreation_dateevent_nameEmp_Num

1676087/21/2016 10:37:21IN9500

1676097/21/2016 10:37:21IN9372

1676107/21/2016 10:37:22IN9517

1676117/21/2016 10:37:22IN9339

1676127/21/2016 10:37:22OUT9234

1676137/21/2016 10:37:23OUT9311

1676147/21/2016 10:37:24OUT9311

1676157/21/2016 10:37:24OUT9525

1676177/21/2016 10:37:25OUT9270

1676187/21/2016 10:37:25OUT9202

1676197/21/2016 10:37:25IN9179

1676207/21/2016 10:37:26IN9159

1676217/21/2016 10:37:26IN9275

1676227/21/2016 10:37:27IN9400

1676237/21/2016 10:37:27IN9299

1676247/21/2016 10:37:27OUT9247

1676257/21/2016 10:37:27IN9233

1676267/21/2016 10:37:28IN9165

1676277/21/2016 10:37:28OUT9279

1676287/21/2016 10:37:28IN9211

1676297/21/2016 10:37:30OUT9310

1676317/21/2016 10:37:30IN9310

1676327/21/2016 10:37:30OUT9310

1676337/21/2016 10:37:31OUT9265

1676347/21/2016 10:37:31OUT9265

1676357/21/2016 10:37:31OUT9235

1676367/21/2016 10:37:32OUT9235

1676377/21/2016 10:37:32OUT9235

1676387/21/2016 10:37:32OUT9217

1676397/21/2016...

Hi Livingston,

Find below my reply.

will there always be only two rows per emp/date? apart from this action_id is very important.(and Many rows which includes name,email id ,timezone,etc)

will there ever be...

hi thanks. but i am expecting something different...

Hi thanks its worked.

SELECT dbo.ScannedDocs.InvoiceNum AS S

FROM dbo.ScannedDocs;

SELECT dbo.1.InvoiceNum AS T

FROM dbo.1;

Update T SET T.customernum=S.customernum

OUTPUT inserted.*,deleted.*

FROM dbo.ScannedDocs T JOIN

dbo.[1] S

on T.InvoiceNum=S.InvoiceNum

table 1 looks like,

InvoiceNum CustomerNum InvoiceDate

12027637439004283 07.03.2016

12030208629004283 08.05.2016

12028088899004283 19.03.2016

12025513219004283 ...