I have deleted this as I have solved it
Does anyone know how to delete a post?
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?