Home Forums SQL Server 7,2000 T-SQL eliminating duplicates from stored procedure joins RE: eliminating duplicates from stored procedure joins

  • Data is duplicated in tblFileNames (Case_no#,reportid,type)

    Data is duplicated in userviewed (viewid,reportid)

    Data is not duplicated in Case30 and caseold