Msg#: 4615196 posted 9:00 pm on Oct 7, 2013 (gmt 0)
Hi! I am always mixed up between this stuff and i need it to be clear for something i need to do.
I have a table with tasks in it. the same task can be there more than 1 time. So i need them to be unique (group by, distinct?!?!) when i do my select query. But the problem is that i need the rest of the fields associated with this task to be shown. I tried with distinct but it applies to all fields in the select statement from what i've understand. so how can i make this work. I hope im clear enough!