Take a look at the Books Online for the topic OUTPUT clause. That's exactly what you need. It can work with a single row insert, or with batches, and captures...

A "self Join" is when a single table is joined back to itself. You have two tables.

Can you better define what it is you're trying to do?

You can only run it once for a particular set of values, yeah.

Here, an example:

CREATE TABLE dbo.x

(ColNo1 INT NOT NULL,

ColNo2 INT NOT NULL,

Val VARCHAR(50) NULL)

ALTER TABLE dbo.x ADD CONSTRAINT...

It's not the each one is a primary key. You're looking at the GUI and seeing a key next to each column. That means they're part of a compound primary...

Lynn Pettis (11/24/2008)

---

The issue would be support by the vendor, going to SQL Server 2008 before they say their app will work properly with that version, you could lose support....

Absolutely not a cursor.

If you're getting the error that you're violating the primary key, it's simply because you are, in fact, violating the primary key.

The purpose of the primary key...

Another vote for the Inside series of books. Fantastic stuff in there. Other than that, no other books come to mind as absolute must reads. You start to get into,...

Sure sounds like a possible case for transactional replication.

Yes.

If you want records that only meet the criteria defined AND records that don't, it seems a bit odd. What you're saying then is return everything.

The two limiting factors, the...

Actually, it looks like you've changed the structure of the query unnecessarily.

...from (Premium_Access

inner join Premium

on Premium_Access.rollup =...

Please don't cross-post. There are now two different discussions going on about the same topic. Please continue discussion at the other location:

http://www.sqlservercentral.com/Forums/Topic607252-1291-1.aspx?Update=1

This is a cross-post with this http://www.sqlservercentral.com/Forums/Topic607251-149-1.aspx

I'd suggest keeping discussion here.

Yeah, I was going to recommend SQL Compare from Red Gate too. There's also Apex SQL, they have a nice compare utility. Visual Studio Team System Database Edition comes with...

Nice article over here:

http://jmkehayias.blogspot.com/2008/09/monitoring-for-blocked-processes-on-sql.html

Interesting, but I'd need to read this on in more detail to see if it's really good:

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1162653,00.html

Nice one from MS on technet

http://technet.microsoft.com/en-us/magazine/cc434694.aspx

Your options are severely limited.

First, check the execution plan. Identify where the scans are occurring, if any, and see if you can affect them with an index or three. Think...