Jeff Moden (5/24/2011)

---

sqlnaive (5/24/2011)

---

Unfortunately that brings me to the same point where I started. In a complex stored procedure, what should be the thumb rule for implementing temporary data [records...

sqldba_icon (5/23/2011)

---

This job runs once everyday. I have nailed it down to a select statement which has the issue. So if i run this select first time, it will take...

sqldba_icon (5/23/2011)

---

Thanks everyone. The issue which i am trying to trouble shoot is not for an application but just for a long-running job. I do now where the issue is.But...

Jeff Moden (5/17/2011)

---

Howdy folks,

For more information on Cross Tabs, how they work, and why I think they're better than PIVOTs, please see the following article (which also includes some performance...

Jeff Moden (5/15/2011)

---

tfifield (4/6/2011)

---

I would use some variables in the query to make it easier to read and do the whole thing in one pass rather than use 3 subqueries.

Something...

Dan.Humphries (5/11/2011)

---

try this. you can not use a like in a join. but by moving it to the where clause it should work fine.

UPDATE Purchasing

SET Purchasing.IsHardware = 1

FROM...

TheSQLGuru (5/12/2011)

---

tfifield (5/11/2011)

---

Ninja,

You also might want to consider how data is entered for the table. If there are VARCHAR type columns that are initially empty and then get filled...

Ninja,

You also might want to consider how data is entered for the table. If there are VARCHAR type columns that are initially empty and then get filled in later...

Craig Farrell (5/2/2011)

---

Todd, that can get fouled...

I noticed...

Todd,

This should give you what you want. It gives each order and its items for only orders that have the same items.

; WITH CTEItems AS

( SELECT oid, itemid

, COUNT(*)...

Jeff,

Brilliant piece of work! I did something a bit similar but cheated by always appending the last delimiter to the string in the function call. I always felt...

I'm with the Corgi on this one. I've done many migrations from native Access to Access front end with SQL Server back end. I used the upsizing wizard...

Krasavita,

You should check your database options to ensure that recursive triggers aren't enabled. When recursive triggers are enabled an update statement in the trigger on the same table will...

StripedCat (4/25/2011)

---

Jeffrey and Grant: Thank you very much for taking the time to review and respond to my post. I have a developer looking over your posts and...