Again, Look for my answer here

suppose  you want to run your replace on a TABLE.

Are you going to run your loop on every record ?

wouldn't it be better and  SET BASED to create the replace( replace...

if you follow the table route probably generating the sql dynamically is the fastest way

HTH

Have a look at this

http://support.microsoft.com/default.aspx?scid=kb;en-us;299410

http://www.microsoft.com/technet/scriptcenter/scripts/ad/computer/default.mspx

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adsi/adsi/distributed_query.asp

It was just a missing parenthesis, sorry. Look again

Just a missing parenthesis

SELECT SUM(Order_details.OrderPrice) AS OrderTotal,

MIN(Products.Manufacturer + ' ' + Products.ProductName) AS ProductNameFull2

FROM Order_details INNER JOIN

Orders ON Order_details.LinkToOrders = Orders.OrderID INNER...

manojkanoi, I just posted the answer in a different thread that you started:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=164127

Change

HAVING to a WHERE Clause!

Like

SELECT SUM(Order_details.OrderPrice) AS OrderTotal,

MIN(Products.Manufacturer + ' ' + Products.ProductName) AS ProductNameFull2

FROM Order_details INNER JOIN

Orders ON Order_details.LinkToOrders = Orders.OrderID INNER JOIN

Products ON Order_details.LinkToProducts = Products.SKUCode

WHERE...

LOOK FOR MY ANSWER on your other thread.

BTW I can't see your picture

Think about it this way (replace 'delete' for 'update' if necessary).

If you delete a Room you will have to delete an Employee and from there you delete the device OR...

Tim,

This is a divide and conquer case. As a guidance you can take a look at the following code

Create table #TDups( Person_Id int,

       Role varchar(50),

                     Dte datetime,

                    ...

My approach to that is to use a Job but some others prefer DMO have alook at this thread for a DMO example 

HTH

Adam,

In 'details' type of tables I usually implement an Identity field and all is good ordering by the Identity value but the User wants to see 1,2,3... not 345,456,585, on...

I have done A LOT of ADP work in the past and It is intended as a Client Side in a Client/Server enviroment (You will need a copy at each client...

2 questions:

- why are you opening a transaction when you read?

- what is the error message ?