Try changing the delete query to the following.

DELETEU

FROMServerB.DatabaseB.dbo.User U

WHEREEXISTS( SELECT * FROM deleted d WHERE U.ID = d.ID )

Just an FYI.., both the methods posted above will give you an approximate value but not the exact value. To get the exact value, you have no option but...

Heard about ROW_NUMBER() function with PARTITION BY clause? That's what would do the job here. Here is the sample code from BOL (works on AdventureWorks)

USE AdventureWorks;

GO

WITH OrderedOrders AS

(

...

What you are asking is called "Cross Tab" or "Pivot" query, there are many articles on this forum that explains how to write these kind of queries.

Have a...

Just a correction, need to add the group by clause to the derived subquery.

update pallet set palllet.qcscore = MaxScore

FROM ( SELECT max(score) as MaxScore, palletid from qcd inner join qch...

Tom, I wonder why its not working on your system, it works fine on my machine without granting any explicit permissions on the folder to a normal db_owner user (though...

Tom Brown (5/28/2009)

---

I tried this - changing your table names to match my system

.....

But I'm still getting errors 7399

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" reported an error....

Assuming that the posted code is just an example and not the real code, the error looks like a configuration issue related to not allowing remote connections on the remote...

You need to build dynamic sql and then run the query using EXECUTE statement. For e.g.

DECLARE @sql VARCHAR(MAX), @Table VARCHAR(100)

SET @Table = 'sys.objects'

SET @sql = 'SELECT * FROM '...

Labneh (5/27/2009)

---

I'm sorry for not posting it the right way.

i got it... didn't have to use row_number... here it is in case someone is in a crunch

SELECT T1.*

FROM TableName as...

It looks like another running total problem, which has addressed many a times on this forum. And here is one solution by Jeff Moden that performs better than any...

Look for ROW_NUMBER() function with PARTITION BY clause...

What you are trying to do is to create an indexed view. So, to create an indexed view you have to adhere to the requirements given for creating it.

Here...

Once you have the working linked server connection, you just need to reference the objects by using the four-part naming convention. For e.g.

SELECT * FROM MyAccessServer...SomeTable

[/code]

I don't think there is an option such as "SELECT Trigger" but there are some system objects that stores the information about when the index/table was read/write/seek/scan etc.

Here is an...