Koen Verbeeck (8/2/2011)

---

LutzM (8/2/2011)

---

I'm not sure if I even should post the rates available over here....

Oh, well ...

45EUR wired flat (phone flat wired to wired and wired to mobile, unlimited...

Since each row is dependent on the value of the prior row, it's not a set-based dataset.

The easiest way I can think of to do this is a recursive CTE....

Ninja, I think you ended up quoting the wrong post.

Ninja's_RGR'us (8/2/2011)

---

Thanks, but I'm not available (and won't be for years).

And no I don't trust it blindly, but I also never had the need to use hints of force the...

TravisDBA (8/1/2011)

---

Kiara (8/1/2011)

---

:hehe: Sadly, my experiences with...

Ninja's_RGR'us (8/1/2011)

---

Are you sure it had nothing...

Of course it's not black-and-white. Nothing in databases ever is.

I'd have to see what they're using tempdb for before I could suggest anything on that point. Heavy use of tempdb is common to a lot of good code,...

Tom.Thomson (8/1/2011)

---

Bad day today. Needed telephone for various things (could use mobile, but (a) expensive and (b) no loudspeaker and area mike so wife and I couldn't have joint...

I guess it depends on whether the recipes will be parsed automatically, or entered manually. Manually, an Ingredients table would allow a drop-down to be used, or a multi-select,...

I started write a refutation of just about everything Joe wrote, because he's wrong at just about every level, even his use of English, but then I decided not to...

Looks like you can also run into this if you have the Via protocol turned on for connections to SQL Server.

Do you have percent symbols in any of the login names? If so, you have a Kerberos issue, and you'll need to remove those.

Recipes table, Steps table, Ingredients table, many-to-many between Steps and Ingredients. Some steps may not have ingredients, of course, unless you do a bill-of-materials style hierarchy for the ingredients...

Select won't take an exclusive lock, just an intent-shared lock, so something is trying to update/insert/delete data and conflicting. Or there's a hint somewhere else in the script/procedure that...