Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  how can i make the date distinct

Author  Topic  colby Starting Member 6 Posts Posted - 2000-11-20 : 20:23:59 using this sql statement or how would you make it were it would only show the same date one and continue on to the next. instead of having 2 week 3 it will only have one Select count(t.ticket_id) , s.status_type_name ,datepart(ww,t.ticket_request_d) From Ticket t JOIN Requestor r ON (t.req_id = r.req_id) left outer Join Company c ON (c.company_id = r.company_id) Join Status_type s ON (t.status_type_id = s.status_type_id) Join Analyst a ON (t.assigned_to_id = a.analyst_id) Where a.analyst_id = 3 and (ticket_request_d between '01/01/2000' and '11/16/2000 ') GROUP BY s.status_type_name , datepart(ww, t.ticket_request_d)