Kevin, running quickly for one ID and not another usually ends up as parameter sniffing.

System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server...

I didn't go through everything, but that's not a triangular join. This is:

A.RowNum < B.RowNum

A common running...

When you say bandwidth, I think network.

The only way this could start eating tons of network is if you're constantly getting polled by the app server on the same proc...

LutzM (4/26/2011)

---

GilaMonster (4/26/2011)

---

M.Sc, not PhD (yet)

I dabble in a lot of stuff, some works out well, some doesn't. It's been several years since I last wrote fiction of any form....

If you want to do this all in one command, you need to turn cascading deletes on for foreign keys. That's what it's built for.

Nice, no reason to be concerned at all. If you spent time on that instead...

Thanks for the feedback, Nick. Appreciated and glad your found what you needed. Don't mind Phil and I if we abduct your thread for further testing, review, and...

Phil Parkin (4/26/2011)

---

You are looking at the bigger picture whereas I was solving this particular problem.

I made the assumption that the file was already sorted by VendorID within CustomerID...

An abstract of limericks! 🙂

A few items here.

One, this field is a DATETIME, right? There's no DDL so I'm assuming it is.

Second, what parameters are you passing in? Just passing in a...

Phil Parkin (4/26/2011)

---

But it seems that it should be possible without too much difficulty, using a combination of appropriately scoped variables and conditional use of the OutputBuffer.AddRow() method on transition...

vidubhushan 49100 (4/25/2011)

---

Hi Gurus,

I have a database with 3800 tables and because of huge number we decided not use referential integrity between the table. the functional experts and DBAs...

Steve Jones - SSC Editor (4/25/2011)

---

The UK had holidays Fri-Mon, so I struggled to get someone to come in and check on things this weekend. I managed to get someone...

[Jim].[dba].[Murphy] (4/25/2011)

---

Where'd that Uncle Jesse thing come from? I'll have to read back and figure it out. I missed a bunch of posts because of the notification delay.

Ya, one...

You need to turn them into left/right join mechanics, like so:

SELECT

tblacc.*

FROM

tblacc AS a

JOIN

tblreceipt AS r

ONa.rkey = r.rkey

JOIN

tblst AS l

ONa.stkey = l.stkey

LEFT JOIN

tblitem AS i

ONa.stkey = i.stkey

AND a.itkey =...