Sql-server – Merging almost unique rows together

sql server

I have this table

enter image description here

And i need have this (In source table are thousands values)

enter image description here

How can i do that ?

Here is example database: http://sqlfiddle.com/#!3/4278d

Thank you.

Best Answer

Assuming that each row in the source table only has either variable1, 2 or 3 populated, and there is only one such row for each combination, then this is probably the simplest approach:

SELECT Name, Column2, 
  MAX(Variable1),
  MAX(Variable2),
  MAX(Variable3)
FROM dbo.DataTable
GROUP BY Name, Column2;

SQLfiddle

Related Solutions

SQL Server – Creating Hierarchy of Employee Names with CTE

If you specify the root node in the CTE, it works ok.

WITH Empl_Tab( Id ,
                 ParentId ,
                 LEVEL,
             [Order]
) AS ( SELECT Employee.[EMPl Id] ,  Employee.[reports to the Boss] ,
                0 AS LEVEL ,
              CONVERT([varchar](MAX), Employee.[EMPl Id]) AS [Order]
           FROM Employee
where [reports to the Boss] = 1
        UNION ALL

        SELECT Employee.[EMPl Id] ,
                Employee.[reports to the Boss] ,
                Empl_Tab.LEVEL+1 AS LEVEL ,
             Empl_Tab.[Order] + CONVERT([varchar](30), Employee.[EMPl Id]) AS [Order]
           FROM
                Employee INNER JOIN Empl_Tab
                ON Empl_Tab.Id = Employee.[reports to the Boss] 
     )

SELECT REPLICATE( '.' ,Empl_Tab.Id*1 )+Employee.Name AS Name
  FROM
       Employee INNER JOIN Empl_Tab
       ON Empl_Tab.Id = Employee.[EMPl Id]
  ORDER BY Empl_Tab.[Order]

SQL Fiddle here.

Select Rows with Condition on Two Columns in SQL Server

then u can use this one

SELECT * FROM tablex WHERE Number<>123 OR VAT<>15

Best Answer

Related Solutions

SQL Server – Creating Hierarchy of Employee Names with CTE

Select Rows with Condition on Two Columns in SQL Server

Related Question