Can you please provide some sample data and your expected output? I don't understand your goals here. Please provide it in the format I gave you in your other post,...

You should really provide your sample data as shown in my signature. I've done this for you this time,.

Couple of solution, one using a subquery, the other using...

Sorry, but I'm not sure i understand your goal here. Are you:
A. Looking for a customers that have only ordered on a specific day (no other odays), and only...

Without actual sample data, this is a little difficult, my answer is guess work.

My guess, however, is that you're starting in the wrong place. I assuming that your...

If it were only so simple for me, J, but those American style dates don't work so well on my British PC;)

Without actually getting some useable data from you (more than one example), this is guess work. I've therefore assumed that every date time has the format of 'MM-dd-yyyy, hh:mm AM/PM'....

I have to ask, but why are you storing your data like this? I don't think the problem is really the need to try and get data about datetimes from...

We have the table DDL, which is great, but we don't have any sample data. Simply telling us that the result you get isn't accurate doesn't give us much information,...

This splits out the two parts, but not the letters and numbers:
CREATE TABLE #Sample ([address] nvarchar(50), --Address has 2 Ds, not 1
            ...

You haven't unticked the the box that states your first line has column headings. In your first screen shot it's ticked.

What defines the rest of your ordering? Do you need to retain the ordering in memberid of a100, then aCVB, then aCvbx, then a105, etc? Does the rest of the...