You can use SSIS, or write custom query and export to file using BCP.

Looks like problem with connection string, try:

SELECT *

FROM OPENROWSET('SQLNCLI', 'Server=myserver;Database=DBA;UserId=ImaUser;Password=TopSecretPass',

'SELECT * FROM DBA.dbo.LDAP') as a

All done by J. Moden:

http://www.sqlservercentral.com/articles/Tally+Table/72993/

Is it one-off data-fix task? If you have no triggers on the table which you need to execute on delete, if it's not referenced by FK relationships and you need...

KS-321165 (5/29/2012)

---

Hi,

I have two tables A and B which are joined by the EmployeeBadgeID. I have to capture all the records that have changed in both the tables...

Sort out records with duplicate PK, or, if...

Just to Note: not everyone will have ability (or wish) to download attached files from i-net, especially at their work places...

can you post the exact line of SQL you run to create your index?

you will need to use some unique key, try using primary keys in:

row_number() OVER (ORDER BY [YourPKColumnOrColumns])

Have you considered using Full-Text?

or a bit smaller:

;with allrules

as

(

select s.id, min (d.id) mdid

from dbo.Test_Join_Source2 s

join dbo.Test_Join_Destination2 d

on ...

It is done in SETS, using correlated sub-query.

There is another way:

;with allrules

as

(

select s.id, s.name1,s.name2,d.[DESC]

,d.id did

...

Pravasis (5/29/2012)

---

Eugene Elutin (5/29/2012)

---

and what is the priority of your rules? which record from destination table you want to select first?

the one with minimum id where any of the names...

I'm not going to fix the whole your trigger, but the following should give the idea of how it should be done.

The existing part for updating Planning_Applications :

DECLARE @AgentValue nvarchar(50)

set...

and what is the priority of your rules? which record from destination table you want to select first?

the one with minimum id where any of the names match or the...