Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Issue: Stored Procedure returns duplicate records for types with subtypes RE: Issue: Stored Procedure returns duplicate records for types with subtypes

  • November 25, 2015 at 9:48 am

    #1842352

    itortu (11/25/2015)

    The current output record for type Cash Management Services and sub type One Card is the one actual record, all the other records for type Cash Management Services, are a duplication of that record data, what the out put should present is the records for cash management services sub type one card, and all the other column populated, and all other cash management rows, should only have the sub type populated with the rest of the column NULL.

    Can't find any data in cc_bfi subquery which could be possibly matched to single

    dbo.tblRelationshipSubType row. How one should select exactly 'One Card' row ?