That won't work because "_" is itself a wildcard character. Look up escape characters in Books Online.

John

Do both of the processes have the same number as well? If so, it's the same process, probably showing up twice due to parallelism. If it has a...

Yes. If you're doing this because the data you want to insert violates the constraints,...

No it won't, but he only asked to be able to add users to the database.

John

Either:

SET IDENTITY INSERT ON

INSERT INTO WhatsUp_Assyst_replicatie_All.dbo.device

(nDeviceID, nDefaultNetworkInterfaceID)

SELECT nDeviceID, nDefaultNetworkInterfaceID

FROM WhatsUp_Assyst_replicatie.dbo.device

SET IDENTITY INSERT OFF

or:

INSERT INTO WhatsUp_Assyst_replicatie_All.dbo.device

(nDefaultNetworkInterfaceID)

SELECT nDefaultNetworkInterfaceID

FROM WhatsUp_Assyst_replicatie.dbo.device

I would recommend the second method, since you are likely to get duplicates in...

Right-click on the table, choose Script Table as -> CREATE To -> New Query Editor window.

John

I can do better than that. If you post the DDL for your two tables, I'll give you the exact script.

John

In that case, you either have to SET IDENTITY INSERT ON, or omit the identity column from your SELECT list.

John

INSERT INTO device

SELECT *

FROM WhatsUp_Assyst_replicatie2.dbo.Device;

John

There's a db_securityadmin database role - would that work for you?

John

Did you follow the link I posted to watch the video? You need to use DAC.

John

This video[/url] talks about exactly the problem you're having.

John

How can you have a count on each row? It'll either be 1 or 0 (equal or not equal). Please will you provide some sample data and expected...

Join the two tables on number=number and do t1.sec - t2.sec for the second column of your result set. Make sure you know how you will handle the cases...

james.ingamells (8/8/2013)

My SQL knowledge is basic to average and need some help in counting rows in a join where 2 dates match:

SELECT MT.[Organisation ]

,MT.[Assignment Number ]

,MT.[First Name ]

,MT.[Last Name ]

,MT.[Position...