Results 1 to 9 of 9

Thread: Selct distinct returns incorrect results in SQL 2000

Threaded View

  1. 11-06-2002, 07:40 AM #1
    rearasi
    rearasi is offline Registered User
    Join Date
    Nov 2002
    Location
    Glen Mills
    Posts
    5

    Question Selct distinct returns incorrect results in SQL 2000

    Hi, I am seeking desperate help.
    We recently upgraded our SQL server from 7.0 TO 2000. Our user are using Bussines objects tools for the reports. When they use the following query " Select distinct (snapshotdate) from tablename group by snapshotdate" returns incorrect results in the meaning of the dates are missing. Whe we use different set of query " that is by using snapshotdate >= date " fundtion it returns correct information. Data is there. Why am I getting this discripence.

    I ran update statistics, rebuild indexes. Optimization and integrity everything performed.
    SQL 2000 service pack 2 is also applied to the server and client.

    All suggestion are welcome. Seeking help sincierly.

    Thanks,
    Ramakrishna
    Last edited by rearasi; 11-06-2002 at 07:54 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules