Not that I advocate switching to a "toy" RDBMS, but MySQL does have the GROUP_CONCAT operator which makes this type of thing a little more elegant. It's something to be...

I suppose Steven King could write his next novel from home, and Tim Burton could draft...

Nice article - I like this approach and will definitely experiment with it the next time I have a change on a large table.

I think you can improve the conciseness...

Hugo Kornelis (1/27/2010)

---

<snip>

Other, minor issues are the unneeded brackets around [name] (name is not on the list of reserved keywords, so no delimitation required); the strangely popular but really rather...

Nicely done and interesting article. I had actually considered writing a similar article, but you have beaten me to the punch 🙂

I like your use of Analysis Services as a...

Greetings, Martyn;

Excuse the self-promotion, but I think this article will be of use to you. Give it a look, and if you need further help mapping the entities in your...

If it's tricks you're after, what would the results be for the following query?

DECLARE @MyVars TABLE (c char(8), [var] char(8));

INSERT INTO @MyVars (c, [var])

SELECT 'I', 'E' UNION ALL

SELECT 'Q', 'X';

SELECT...

John Rowan (9/10/2009)

---

It also gives the database users an idea of which candidate key may have the clustered index on it. I know that Primery Keys do not have...

David Portas (8/14/2009)

---

Yes. You can use OUTPUT to insert to another table...

David Portas (8/14/2009)

---

That would be useful...

Awesome! Unpredictable behavior based on builds (or better yet, Editions). I ran David's script on SS2K5 9.00.4035.00 and SS2K8 10.0.1600.22 and got the error on both (both Developer Editions).

Imagine how...

Matt Miller (8/14/2009)

---

David Portas (8/14/2009)

---

Matt, you missed the point of what I was saying. My UPDATE should not violate the constraint, that's true. But what I wanted to demonstrate was...

> Basically, a student is only allowed to checkout a maximum of 3 tools.

Over the course of their lifetime, or 3 tools at any given point in time?

Probably some confirmation bias going on here, both in the OP and many of the replies.

One question - how are you defining "success"? Is it career success, financial succes(both)? Do...

Hi Scott;

My article here http://www.sqlservercentral.com/articles/Data+Modeling/61528/ may give you some background to help solve this problem.

HTH,

TroyK