MS SQL Books

[NewsBot]

Just wondering if anyone could recommend me a ms sql book, 2000 and 2005 mainly but really I need to learn sql other than my current methods of trying something until it works (incl perf checking)..

 

My current question is almost certainly really simple, I have a normalized many to many relationship (three tables)..

 

A, B and C where B is the linking table..

 

Given an Id for A, I need a collection of rows from A where they share the same 'children' from C (note this result must contain a column stating how many children are in common, and the results cannot include the original (ie, I don't want information about how many children are in common with itself)).

 

Edit: this is a ms sql 2000 db.

 

My main question is the book though, cheers in advance guys.

 

 

More...

 

View All Our Microsoft Related Feeds