Home Forums SQL Server 2008 T-SQL (SS2K8) self joining a table to get Parent Child relationship RE: self joining a table to get Parent Child relationship

  • November 26, 2012 at 4:56 am

    #1562150

    Hi,

    Now i get

    Msg 240, Level 16, State 1, Line 1

    Types don't match between the anchor and the recursive part in column "Dim_CostCentre_Desc" of recursive query "HierarchyBuilder_Cte".