NewsBot
1
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
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