SELECT * FROM UserTable WHERE DATEDIFF(day, DateJoined, DateUnSub).
For MySQL: select * from table where DATEDIFF(DateUnsub_, DateJoined_).
I believe the datepart argument is required. – Dustin Laine Jun 23 at 16:42 1 In MySQL there are only two parameters: dev.mysql. Com/doc/refman/5.1/en/… – Christopher Armstrong Jun 23 at 16:43 1 Ahh, OP did not specify.My apologies.
– Dustin Laine Jun 23 at 16:46 I'm not entirely sure which i'm using...sounds silly, I know. I'm working in a . Aspx file, using C#, and connecting to Lyris.
– OhMisterRabbit Jun 23 at 16:48 @Dustin - No apology necessary.. I didn't know what DBMS he was using either. – Christopher Armstrong Jun 23 at 17:07.
As for getting the number of users who unsubscribed each month, you could GROUP BY DATEPART(year, DateUnsub_), DATEPART(month, DateUnsub_) or instead limit on those dateparts to get the list of users. msdn.microsoft.com/en-us/library/ms17442....
I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.