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...