Home Forums SQL Server 2008 SQL Server Newbies Using Count Distinct in a CASE statement to choose more than one unique record RE: Using Count Distinct in a CASE statement to choose more than one unique record

  • August 12, 2014 at 7:21 am

    #1737208

    Contract_IDProductordercodeStartDateEndDateOfferIDRevision

    111327140101/01/201331/07/2014101010102

    215415200701/01/201306/12/2014202020205

    215415400001/01/201306/12/2014202020205

    215415410101/01/201306/12/2014202020205

    215755990601/01/201306/12/2014202020205

    21247353791001/01/201306/12/2014202020205

    21247695220801/01/201306/12/2014202020205

    21247792800301/01/201306/12/2014202020205

    21247971760601/01/201306/12/2014202020205

    21247972790101/01/201306/12/2014202020205

    311826930501/01/201331/12/2014303030307

    312183000301/01/201331/12/2014303030307

    314574440201/01/201331/12/2014303030307

    315680740001/01/201331/12/2014303030307

    315704700301/01/201331/12/2014303030307