eh936 (2/15/2011)

---

tfifield (2/15/2011)

---

Thanks for letting me know. I thought your requirement was to list the actual orders for those customers. Of course your query works fine and is...

Here's a quick and dirty example of what I use for this sort of thing. Assuming you have a table called MyTable and it has a column called UpdateCount:

UPDATE...

Craig Farrell (2/15/2011)

---

tfifield (2/15/2011)

---

Craig,

Do you know of a decent tutorial on it? I've been meaning to get into...

abacrotto,

Thank you for your reply. Yes, the creation of the table could be done set-based, however, it is only done once so I don't pay much attention to performance...

Thanks for letting me know. I thought your requirement was to list the actual orders for those customers. Of course your query works fine and is very simple...

It probably gave you an ambiguous column name error since I forgot to specify a table alias in the join in the CTE.

INNER JOIN Customers C ON

O.CustomerID...

Craig,

Do you know of a decent tutorial on it? I've been meaning to get into Service Broker for...

eh936,

The only way I know of to get the order info from just customers with 15 or more orders is to first determine which customers have that many orders and...

Linked servers can work for this type of thing if it's just specific data that needs to be distributed, such as changes to orders or customer information.

You want to look...

Sometimes dates are a bit messy for checking which records need to be updated somewhere else. The 3 ms. gap in the DATETIME data type can mess you up....

I pretty much don't allow Remote Desk Top and SSMS to be run on production servers unless I specifically want to work as a dedicated console on the server. ...

TheSQLGuru (2/2/2011)

---

DO NOT USE LINQ TO SQL, and...

Craig Farrell (2/2/2011)

---

tfifield (2/2/2011)

---

At some point as the number of rows increase within the partition the CROSS APPLY will start to pull away from either MAX or ROW_NUMBER() since it...

Kumar,

You may want to try something like this. It's the best way I've found to join back to the same record set to the one just prior or just...

I've done some bench mark tests comparing ROW_NUMBER() to doing a CROSS APPLY with a TOP 1 type of construct. Even if the TOP 1/CROSS APPLY has a covering...