Viewing 7 posts - 1 through 7 (of 7 total)
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...
September 25, 2009 at 1:25 am
#1058357
Perfect it works fine !!!
Thanks,
D
September 23, 2009 at 7:16 pm
#1057833
Hi there,
Please find attached copy of sample data and requirment.
Dreamslogic
July 21, 2009 at 1:10 am
#1027430
Try this
SELECT CAST (floor (cast(getdate () AS SmallDatetime )) AS
July 16, 2009 at 9:02 pm
#1025977
Thanks Very Much 🙂
July 16, 2009 at 5:24 pm
#1025960
Thanks for the article Ken it was really helpful.
June 13, 2009 at 10:40 pm
#1009240
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...
June 13, 2009 at 10:16 pm
#1009236