Use the OUTPUT clause on the UPDATE statement to return back the rows being updated.

The following code is another way of doing it.

You might want to look at the first link in my signature for better ways to post to make it easier for...

Look at the columns in the WHERE / HAVING clauses, and the JOIN conditions. Usually, your more selective columns would be first in the index.

Also, check the master.sys.dm_db_missing_index_xxx views.

If you can get us table definitions, test data and expected results (see the...

This means that you will return any DateEnd value in 2009, AND any DateEnd value of "1/1/2010 00:00:00.000". Nope,...

The problem with this approach is that you won't be able to use...

You know, the people that help out here are all un-paid volunteers. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables affected, and INSERT statements to put...

Paul White (2/24/2010)

---

RBarryYoung (2/23/2010)

---

Give it a go, Paul. The solution that we (independently) came up with is pretty darn efficient, so I would be particularly interested to see if...

RBarryYoung (2/23/2010)

---

Thats's what the Fair Use doctrine is all about, Wayne. Paid or not, copyright or not, we are still allowed to quote text from sources, within limits. ...

It has often been found to be easier to use a different way than using BETWEEN when working with date ranges:

WHERE DateEnd >= '1/1/2009' and DateEnd < '1/1/2010' will get...

Paul White (2/23/2010)

---

WayneS (2/23/2010)

---

Steve, while I agree, my question is whether a quote from a paid subscription...

johnnycash (2/23/2010)

---

Hello everyone!

I need some assistance and guidance. I have an XML file that I need to bring it into a SQL 2005 table. The problem is that...

Nugby,

I'm afraid that I gave you some bad advice.

From BOL:

TABLE

Specifies that the return value of the table-valued function is a table. Only constants and @local_variables can be passed to...

Steve,

While I agree, my question is whether a quote from a paid subscription site (as where this...

Steve, this is the message I get:

Sorry your search results have expired within our database. Search results are held for around 30 minutes. You will need to perform your search...