Deleted

I have deleted this as I have solved it

Does anyone know how to delete a post?

You are not using the same order by as it is in Dense_Rank

order by
				datepart(dd,ppa.activitystartdate)
				,datepart(mm,ppa.activitystartdate)

vs

,[ActivityStartDate]
	,[Day Number]

Thanks I actually solved this myself and then the text of my question, but it seems to have stayed here...

Is there some way to delete a forum post?