Hello g8r

I'm not sure if I understood, but for the example result of your first post it might be just:

SELECT Visit_Date, COUNT(*)

FROM #Special_Orders

GROUP BY Visit_Date

Greetings

Flo