<anonymous@discussions.microsoft.com> wrote in message
news:053f01c39d8e$cd1b2150$a101280a@phx.gbl...
> Thanks for the sugesstion, I now get the two records but
> still cannot physically see the difference. Do you or
> anyone know of how to expose raw datetime data?
> >-----Original Message-----
> >Try selecting WHERE sales_dt BETWEEN 10/22/2003 AND
> 10/24/2003
> >
> >You probably have a 10-23 entry with a different time.
> >
> >
> >"Henry Jartu" <hjartu@rsilink.com> wrote in message
> >news:00e501c39d86$2407b810$a501280a@phx.gbl...
> >> Somehow primary constraint was violated as group by
> >> clause to eliminate dupplicates does not catch the
> >> invalid date until attempt to insert data into
> >> destination table:
> >> Where clause produces the dupplicate row
> >> "CONVERT(VARCHAR(50),sales_dt,101) = '10/23/2003'" but
> I
> >> am unable to see the dupplicate and produces the two
> rows
> >> 2003-10-23 00:00:00.000
> >> 2003-10-23 00:00:00.000
> >> However this where clause "sales_dt = '10/23/2003'"
> >> eliminates the dupplicate in the result set and only
> >> produces a single row
> >> 2003-10-23 00:00:00.000
> >> Huge problem don't know which row to delete and primary
> >> key is now violated on a table of over 120 million
> rows.
> >> Running DBCC REINDEX fails now due to the violation in
> >> primry key.
> >>
> >> Someone please help
> >
> >
> >.
> >