Sorry this is the right answer, I think.

if you want distinct on one column then you will have multiple other columns for that column.

e.g. if you are asking for...

Perfect it works fine !!!

Thanks,

D

Hi there,

Please find attached copy of sample data and requirment.

Thanks,

Dreamslogic

Try this

SELECT CAST (floor (cast(getdate () AS SmallDatetime )) AS

Thanks Very Much 🙂

Thanks for the article Ken it was really helpful.

Hi Steve - Here are the choices

Create a new View

Use a cursor and store the data in a temporary table

Create an Indexed View

Create a User Defined Function to return the...