Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
klondikegurl
Starting Member
5 Posts |
 Posted - 2011-07-17 : 05:19:36
|
| NAME DATE PRESENTSbob march 3 2011 1bob june 6 2008 2bob jan 3 2012 3mary feb 14 1986 4mary april 10 2001 5mary jan 3 2012 6kate march 3 2011 7kate jan 3 2012 8kate oct 9 2013 9celia march 3 2011 10celia feb 14 1986 11celia july 4 2011 12celia jan 3 2012 13celia feb 14 1991 14 So the goal is we add the amount of presents kate and celia got on the same days if they got any on the same days What I need to do is kind of like this except with a much bigger data set. Prolly in the 100 000 entries. i need the answer in SQL code or access 2003 query SQL.Thanks! |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-07-17 : 06:55:52
|
| Duplicate post. No replies to this thread please. Direct replies to:[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=163135[/url]--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
Really need somebody's help! (urgent!)