The key to this is getting the number of days of the previous month of endDate, to work out the case where startDays greater than endDays. This should work.

DECLARE...

We have bacon virtually on-tap here. From 7am to 2pm the smell of bacon can be irresistable.

We even refer to the canteen as 'the lard counter'.

And I'm rather fond...

You want each online course to appear in all regions, so select the onlinecourses only and get the product with the distinct regions, then combine this back into the non-online...

http://lmgtfy.com/?q=difference+between+SQL+Server+2005+%2C2008%2C2008+R2

interrogate

WILLIAM MITCHELL (11/23/2011)

---

Back to the microwave thing...sometimes coworkers will "pause" before the timer runs out, remove their food & walk away, leaving "00:21" or something on the display. I feel...

So I've been repeatedly told ...

or perhaps I meant Brainwishing

Endoctrinate

I'm beginning two cents deja vu here.

so well salted...

Ninja's_RGR'us (11/21/2011)

---

Koen Verbeeck (11/20/2011)

---

Sean Lange (11/18/2011)

---

I don't think you can...

Anyone care to take a look at this

http://www.sqlservercentral.com/Forums/Topic1208130-391-1.aspx

He's then attempting to break down the problem in this

http://www.sqlservercentral.com/Forums/Topic1208227-391-1.aspx

Its not clear exactly whats wanted on first reading, but I think it now...

The main performance problem is in this part:

FROM #Test2 AS T1

CROSS JOIN #Test2 AS TPrev

WHERE T1.ID <> TPrev.ID

So if you have...

OK, with a minor modification this creates the results you want. Instead of comparing each row to the previous row, I use a CROSS JOIN and compare each row...

SQL Probably can do what you want, however its not completely clear what that is. As I understand it you want to know the number of differences to the...