>>Does anyone know how to group a result set on just the date portion of a datetime column using SQL pass-through?
>
>Just select one more column: datepart as date(datetime field) and group on this column.
>
>Vlad

The DatePart function in MS SQL server doesn't allow you to return the entire date portion. I would have to concatenate the year, month and day portions and I'm hoping to avoid that.