Community Member Profile

Recent Blog Comments By Ryan DeBraal

• Ask Ben: Pulling Unique SQL Records That Match ALL Join Conditions

  Posted on Jun 23, 2009 at 6:28 PM

  This is what ended up working for me, I'll explain how I see it, and if you can tell me where my logic is incorrect I would really appreciate it...first the lump: Application files Documents by "Tags" SO theres a Document, Tag, and Document_Tag table joining them I want the user... read more »

• Ask Ben: Pulling Unique SQL Records That Match ALL Join Conditions

  Posted on Jun 22, 2009 at 5:55 PM

  Crap! I just rewatched the video at home (as opposed to work) and discovered that the GROUP BY needs to be inside the "inline\temp" selection, no wonder it worked perfectly in SQL Manager Studio yet returned seemingly random results in my application :) I can't gaurentee the validity of thi... read more »

• Ask Ben: Pulling Unique SQL Records That Match ALL Join Conditions

  Posted on Jun 22, 2009 at 2:07 PM

  I am providing my statement as thanks :) I have a tblDocument, tblTag, and a tblDocument_Tag linking them - be sure to adjust the COUNT when you add, remove values to match SELECT DISTINCT doctag.dt_tagKey FROM tblDocument_Tag AS doctag INNER JOIN ( SELECT dt_tagKe... read more »

• Ask Ben: Pulling Unique SQL Records That Match ALL Join Conditions

  Posted on Jun 22, 2009 at 2:03 PM

  I forgot to mention that I did not get a unique result-set, I did have to use a DISTINCT keyword on the first SELECT SQL Server 2005... read more »

• Ask Ben: Pulling Unique SQL Records That Match ALL Join Conditions

  Posted on Jun 22, 2009 at 2:01 PM

  Absolutely wonderful! I searched online for 3 days trying to figure this out - trying combinations of ANDs, CONTAINS, etc. I highly recommend visitors watch the short video, as I didn't realize the importance of the COUNT(*) initially and excluded it. It's very clever to pull in a li... read more »