Sean Lange (6/6/2014)

---

Lynn Pettis (6/6/2014)

---

SwePeso (6/6/2014)

---

Naomi N (6/6/2014)

---

Peter,

I think we wanted customers who bought A and B but not C, so your query will be even simpler,

MIN(productID) = 'A' and...

Luis Cazares (6/6/2014)

---

What...

Peter,

I think we wanted customers who bought A and B but not C, so your query will be even simpler,

MIN(productID) = 'A' and MAX(productID) = 'B'

Also, I have an article on a similar topic which may be of interest and it's related to this topic

http://social.technet.microsoft.com/wiki/contents/articles/22165.t-sql-relational-division.aspx

I would suspect this code to run faster than count distinct. Can you perform tests on a big table?

I would love a copy of the book as well.

There are lots of queries we can do with OVER clause. The most common, I think, is to get top N...

I am getting the exact same error. I have a huge binary file and I want to pass the binary content (as is) from Visual FoxPro to SQL Server using...

Did you get the resolution to this problem? I am reproducing this error by using 2MB file. I am wondering what is the size limit before this error occurs?

Interesting idea, let me try that. I have a very similar requirement. I want to generate a spreadsheet with many worksheets, but I don't want to manually create a template...

Thank you both. The expanding with Numbers table was my idea as well and I see on the second page of pointed discussion that this was the approach taken by...

How will you expand the solution when you have StartDate EndDate fields in your table and you want continuous intervals, e.g.

01/01/2010 - 01/15/2010

01/16/2010 - 02/10/2010

The above two intervals should...

Thank you both!

It is not available in SQL 2008. Does anyone have a code for this SP?

Jeff,

That was one of the best articles I read recently. Terrific job!

BTW, is there a way to contact you privately somehow?

Thanks again.

Check these threads on MSDN

MSDN thread with many helpful links

Lightning Fast Hybrid RUNNING TOTAL - Can you slow it down?[/url]

Wondering if the term 'Quirky Update' is Jeff Moden's invention.