SQL - Group by ID

SELECT


    DAVS.RECID as PRIRECID,


    DAVSI.RECID as SECRECID,


    DA.NAME,


    DAVSI.DISPLAYVALUE,


dft.DESCRIPTION,bu.NAME As LocationDetails,dept.NAME As Dept, Cc.NAME as Costcentre
FROM


    dbo.DIMENSIONATTRIBUTEVALUESET                        AS DAVS


LEFT OUTER JOIN


    dbo.DIMENSIONATTRIBUTEVALUESETITEM    AS DAVSI    ON DAVS.RECID = DAVSI.DIMENSIONATTRIBUTEVALUESET


INNER JOIN


     dbo.DIMENSIONATTRIBUTEVALUE   AS  DAV            on DAV.RECID = DAVSI.DIMENSIONATTRIBUTEVALUE


INNER JOIN


     dbo.DIMENSIONATTRIBUTE  AS   DA                  on DA.RECID = DAV.DIMENSIONATTRIBUTE


LEFT JOIN DimensionAttributeDirCategory dadc
    ON dadc.DimensionAttribute = da.RecId


LEFT OUTER JOIN dbo.DIMENSIONFINANCIALTAG dft
ON davsi.DISPLAYVALUE = dft.VALUE
AND da.VIEWNAME = 'DimensionFinancialTag'
LEFT OUTER JOIN dbo.DIMATTRIBUTEOMDEPARTMENT dept
ON davsi.DISPLAYVALUE = dept.VALUE
AND da.VIEWNAME = 'DimAttributeOMDepartment'
LEFT OUTER JOIN dbo.DIMATTRIBUTEOMBUSINESSUNIT bu
ON davsi.DISPLAYVALUE = bu.VALUE
AND da.VIEWNAME = 'DimAttributeOMBusinessUnit'
LEFT OUTER JOIN dbo.DIMATTRIBUTEOMCOSTCENTER cc
ON davsi.DISPLAYVALUE = cc.VALUE
AND da.VIEWNAME = 'DimAttributeOMCostCenter'

Select allOpen in new window