Danke schön !! Wie bekommst du das so hin ??

Gibt es da einen Tip, damit ich es alleine schaffe ??

Gruß

Thomas

Sorry for my Englisch in German is Better 🙂

Here are the sample datas.

Site,LoginID,NST,LoginZeit,LogoutZeit,LogoutDate,Skill1,Skill2,Skill3,DiffInOut,Logindate

Siteone,50001,74587,1899-12-30 20:01:09.000,1899-12-30 21:59:15.000,2006-05-24 00:00:00.000,100,,,7086,2006-05-24 00:00:00.000

Siteone,50001,74628,1899-12-30 09:29:08.000,1899-12-30 11:33:03.000,2006-05-24 00:00:00.000,100,,,7435,2006-05-24 00:00:00.000

Siteone,50002,74558,1899-12-30 13:59:18.000,1899-12-30 17:31:59.000,2006-05-24 00:00:00.000,100,,,12761,2006-05-24 00:00:00.000

Siteone,50006,74534,1899-12-30 22:50:31.000,1899-12-30 02:31:34.000,2006-05-25 00:00:00.000,100,,,13263,2006-05-24 00:00:00.000

Siteone,50007,74511,1899-12-30 13:57:32.000,1899-12-30...

Hallo please test this i have found times ago ,

SELECT TOP 3

FELDA, FELDB, ...

FROM Datenquelle...

Hallo thanks for answere,

you are right . This was one of my first test and i think its ok for test. The problem is that the array isnt in one...

Thanks at all for Help !

I am fixed this and Matched all what i need.

Regards

Thomas

Hey yes of course you are right.

Thomas

Thanks,

i ve found it 🙂

It was an (( in the last then

Thomas

How can I understand from the data you provided which line means what?

01.01.05 01 08:00 09:00

01.01.05 01 11:00 12:00

This are two shifts. NO Changed

In your example the agent work at...

Sorry i am again.

There is a difference.. the dep.

Date u_id start_time stop_time dep

01.01.05 01 08:00...

Hey , sorry for late answere.

at first time i work with this statement:

SELECT distinct t1.personalnummer,t1.agentname,t1.eintrittsdatum,

t1.datum,t1.code,t1.start_moment,t2.stop_moment,t1.groupid

FROM svtcs T1 JOIN svtcs T2 ON (t1.personalnummer=t2.personalnummer)

WHERE t1.stop_moment =

(SELECT MAX(t3.stop_moment)

...

Hey here is the statement i build from your tip:

SELECT distinct t1.personalnummer,t1.agentname,t1.eintrittsdatum,

t1.datum,t1.code,min(t1.start_moment),max(t2.stop_moment),t1.groupid

FROM svtemp T1 JOIN svtemp T2 ON (t1.personalnummer=t2.personalnummer)

group by t1.personalnummer,t1.agentname,t1.eintrittsdatum,

t1.datum,t1.code,t1.groupid

it's OK for build the first part because...

Hallo and thanks for replay,

at this entries

Date u_id start_time stop_time

01.01.05 01 08:00 12:00

01.01.05 01 08:00 09:00

01.01.05 01 11:00 12:00

the agent short this staffed.

The shift is 8:00 till 12:00

so he...

Hey sorry i forget the script i take. I test to modify yours.

With this script you see the Data in the Post before. I think i don't understand anythink :

insert...

Hallo Vasc,

sorry but i was ill the last days. The runs are very good and fast. I had an Problem by the update an last Step insert.

First:The Agent iststart and...

Hallo Vasc,

thia is the third time i will send this Post.

Thanks for tuning my statements. I test i just in Time and give you feedback.

In the last mail i have...