Try the following:

select *

from crudefilo c1

where c1.dt >= DateAdd(day, -30, GetDate())

and c1.dt = (select min(c2.dt)

                  from crudefilo cw

                  where datepart(d,c2.dt) = datepart(d,c1.dt)

                   and datepart(m,c2.dt) = datepart(m,c1.dt)

order by c1.dt

The problem with using the dynamic sql methods to number your rows is that the query will take a long time on large tables. Niether will you get unique row...

Antares:

Thanks for taking the time to respond to this posting. As you advised, we decided to give dbo ownership of all objects in our development environment.

To solve our problem,...