Jeff Moden

The problem with the (First in/Last out) rule is there may ins with no outs and vice versa for individuals because of the "tailgating" problem. My question is...

Jeff Moden (11/21/2014)

---

tamer.h (11/21/2014)

---

sometimes many users have two check outs or two checkins, it happens during the day when two users pass together from the gate and they using one...

thank you all for assistance and support.

--Jeff Moden

If the user only has an "in" time on one day and an "out" time the next day, they may be a part...

really I don't have any idea, what is your suggestion?

What do you want to do...

first, thank you very much for your reply.:-)

sorry i didn't understand what do you mean by:

"Not certain on 'L' ,'0' logic.

For a given month"

and would you please explain what is...

Thank you very much for you reply.

first you will find below the CREATE TABLE code showing data types, and actually we can't useing reader_id with CASE ELSE

as it's just a...

Thanks a lot "Mr or Mrs. 500", appreciated.:blush:

Hi HanShi,

I've created result table using the above SELECT INTO statement.

Good Day for All,

and thank you so much for your advices.

I was very confused yesterday but finaly I've modified the code using SELECT INTO as below and it works perfectly

SELECT

nEventLogIdn,...

Hi All,

This is the modified code: and I've got the error "The multi-part identifier "originDB.dbo.neventidn" could not be bound."

SELECT

[originDB].[dbo].[nEventLogIdn],

[originDB].[dbo].[dtDateTime],

[originDB].[dbo].[nReaderIdn],

[originDB].[dbo].[nEventIdn],

[originDB].[dbo].[nUserID],

[originDB].[dbo].[nIsLog],

[originDB].[dbo].[nTNAEvent],

[originDB].[dbo].[nIsUseTA],

[originDB].[dbo].[nType]

INTO [db_dest].[dbo].[result]

FROM...

Thank you ChrisM@Work

it works perfectly.

I'm now trying to copy the result of query to another table in another DB useing INSERT INTO but it always creating a new table...

yes, nDateTime=An elapsed time from Jan.1st 1970 00:00:00 to current time which shows seconds value.

and DATEADD(s, nDateTime, '1970-01-01 00:00:00') converting it to datetime format.

so, is there any way to correct...

i have the same problem and when I have tried to upgrade it givs me a message said that the sql agent is already installed, anybody can help????????????

Dear dva2007

thank you very much for advice, it works v.good.