Hallo Vasc,

i test it just for this second.

It WORKS GREAT !!! I Test just any changes and Infos entrys.

Please can you look twice on my script Step1 till Step7?

I ve...

Hallo sorry for answere so late.

If i take the first statement it fill in the data. But if i do it again there fill in the same data and so...

OK this is exact what i want 🙂

INSERT into svlisteks from svliste when we have a different WORKING DATE for the agent (svlisteks contains records for a certain agent from...

The Supervisior only work in the SVLISTEKS.

It can change the

[Zusatzinfo];[Bemerkung]the[Enviroment]is an automatic entry with the username that changed data.

Also they can insert a complete Dataset.

In the SVLISTE are all...

Hey thanks ,

Basic its a table who the Supervisior can insert some Infos

about the Agents. This happend in VB Application.If there is an entry and i fill in Data they...

Hallo Vasc,

the Data from :

INSERT INTO [SVLISTE] VALUES('Amlung, Gabriele','CS','CS','Aug 30 2005 12:00:00:000AM','Aug 30 2005 8:00:00:000AM','Aug 30 2005 2:30:00:000PM','Aug 30 2005 7:59:20:000AM',NULL,NULL,NULL,NULL)

are OK . The Match is great...

Sorry Vasc,

i'll sent the data but i can't see them in the Post. I taste it again sorry.

Thomas

Hallo and Good Morning Vasc and all,

thanks its super and many faster with your source.

So in the Table SVLISTE are the right Data. So i only must update the SVLISTEKS...

Hey @all,

sorry i must go my Boss is phoned me.I look in so far as i can.

Kind regards

Thomas

Just follow the Data for Tables !

--INSERTs generated by 'sp_generate_inserts' stored procedure written by Vyas

--Build number: 22

--Problems/Suggestions? Contact Vyas @ vyaskn@hotmail.com

--http://vyaskn.tripod.com

SET NOCOUNT ON

PRINT 'Inserting values into...

Hey Remi,

sorry Just Now i understand !

I' ll sent step by Step the Table dll with the Data.

So you have the Complete replication.

First all Tables :

CREATE TABLE [SVLISTEKS] (

[Agent] [varchar]...

So i think i have the Data 🙂

Here are the Table with Data from svlisteks:

--INSERTs generated by 'sp_generate_inserts' stored procedure written by Vyas

--Build number: 22

--Problems/Suggestions? Contact Vyas @ vyaskn@hotmail.com

--http://vyaskn.tripod.com

...

Hallo Vasc,

thanks for looking. This Statement is ok.

in Table there are data like this

Thomas 8:00 12:00

then i take a next shift an in data stand

Thomas 8:00 12:00

Thomas 7:00 8:00

so i...

Thanks for all !

Sorry Remi i be stupid and i can't understand how to upload.

But this Forum is great and spent a lot of Time for same like me.

Fun...

Hey Phil,

sorry for the question for your insites .

I work alone but going on search for an german site sql or any who write english for me.

I think only an...