T-SQL合并数据 [英] T-SQL Merging data

问题描述

我已经使用SSIS将数据从XML文件导入到SQL Server. 我在数据库中得到的结果与此类似:

I've imported data from an XML file by using SSIS to SQL Server. The result what I got in the database is similar to this:

+-------+---------+---------+-------+
|  ID   |  Name   |  Brand  | Price |
+-------+---------+---------+-------+
| 2     | NULL    | NULL    | 100   |
| NULL  | SLX     | NULL    | NULL  |
| NULL  | NULL    | Blah    | NULL  |
| NULL  | NULL    | NULL    | 100   |
+-------+---------+---------+-------+

我想要的结果是:

+-------+---------+---------+-------+
|  ID   |  Name   |  Brand  | Price |
+-------+---------+---------+-------+
| 2     | SLX     | Blah    | 100   |
+-------+---------+---------+-------+

在T-SQL中是否有解决此问题的漂亮解决方案? 我已经尝试过使用SELECT MAX(ID)然后使用GROUP BY ID，但是我仍然坚持使用NULL值.我也用MERGE尝试过，但是也失败了. 有人可以给我指示进一步搜索的方向吗?

Is there a pretty solution to solve this in T-SQL? I've already tried it with a SELECT MAX(ID) and then a GROUP BY ID, but I'm still stuck with the NULL values. Also I've tried it with MERGE, but also a failure. Could someone give me a direction where to search further?

推荐答案

您可以在所有列上选择MAX....

You can select MAX on all columns....

SELECT MAX(ID), MAX(NAME), MAX(BRAND), MAX(PRICE)
FROM [TABLE]

单击此处以获取小玩意儿的小提琴...

Click here for a fiddley fidd fiddle...

这篇关于T-SQL合并数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！