这是我见过最牛B的MSSQL，公司领导的亲戚写的。让我维护我TMD的服了。

[vicvin]

SELECT * FROM (SELECT c.planYear,c.orgId,d.ONAME,e.name AS typeName,f.name AS sizeName,c.type,c.size,c.quantityAll,c.arrivalDate,c.quantitys,c.dealData,
(c.quantityAll-c.quantitys) AS other FROM SM_LabourLedger AS a,SM_LabourLedgerList AS b,
(SELECT d.orgId,d.type,d.size,b.planYear,a.arrivalDate,c.quantity AS quantityAll,d.quantitys,d.dealData FROM SM_GrantPlanList AS a,
SM_GrantPlan AS b,SM_GrantPlanDepList AS c,
(SELECT b.orgId,a.type,a.size,sum(quantity) AS quantitys,max(dealDate) AS dealData FROM SM_LabourLedger AS a,SM_LabourLedgerList AS b
WHERE a.id = b.llId AND b.type = '1' GROUP BY b.orgId,a.type,a.size) AS d
WHERE a.size = d.size AND b.type = d.type AND b.id = a.gpId AND c.orgId = d.orgId) AS c
LEFT JOIN T_ORGANIZATION AS d ON c.orgId = d.OID
LEFT JOIN T_CODETABLE AS e ON e.Code = 'SMEMPSIZETYPE'
LEFT JOIN T_CODETABLE AS f ON f.Code = 'SMEMPSIZENAME'
WHERE a.type = c.type AND a.type = e.value AND a.size = c.size AND a.size = f.value AND b.type = '1' AND b.orgId = c.orgId
GROUP BY c.planYear,c.orgId,c.type,c.size,c.quantityAll,c.arrivalDate,d.ONAME,e.name,f.name,c.quantitys,c.dealData
)AS TEMP

[xi_ha]

习惯了都，就当是一种低度的加密，哈哈，非授权用户想修改也是脑壳要晕乎的。

[七色鸟]

操，这代码写的和我现在公司的差不多，看着吐血，这么热的天看这种代码真他妈的是折磨！

[MarsDavid]

首先BS下LZ的老板的这个写代码的亲戚！！
我也最讨厌 可以用厌恶来形容这种写代码的人。 发自内心的BS。。LZ不用灰心呀 咋个要离开软件行业呢！！

[w_xxxbbb]

仅此一例，可以看出这个系统就没打算让人维护.破而后立掏钱上新项目.

[死神在线]

LZ转行吧

[大力水手]

冲动是魔鬼啊..还是先想想在离职..or 逛暴老板亲戚一顿在离职

[yagebu1983]

我最烦看这种SQL语句！！！
一是乱
二是增加了复杂逻辑

[晓风斜阳]

他不懂开发规范吧？

[w250829594]

[Quote=引用 40 楼 vincent_void 的回复:]
操，这代码写的和我现在公司的差不多，看着吐血，这么热的天看这种代码真他妈的是折磨！
[/Quote]
[Quote=引用 33 楼 pengpeng409 的回复:]
呵呵。。。。。。我也头晕。。。。。。。本来头就疼。。。现在更疼了。。。。
[/Quote]
折磨~~~~

[三断笛]

楼主应该用个SQL格式化工具,我用的是SQL Assistant

SELECT *
FROM   (SELECT c.planYear,c.orgId,d.ONAME,e.name AS typeName,f.name AS sizeName,c.type,c.size,c.quantityAll,c.arrivalDate,
               c.quantitys,c.dealData,(c.quantityAll-c.quantitys) AS other
        FROM   SM_LabourLedger AS a,SM_LabourLedgerList AS b,(SELECT d.orgId,d.type,d.size,b.planYear,a.arrivalDate,c.quantity AS 
                                                                     quantityAll,d.quantitys,d.dealData
                                                              FROM   SM_GrantPlanList AS a,SM_GrantPlan AS b,
                                                                     SM_GrantPlanDepList AS c,(SELECT b.orgId,a.type,a.size,
                                                                                                      SUM(quantity) AS quantitys,MAX(dealDate) AS dealData
                                                                                               FROM   SM_LabourLedger AS 
                                                                                                      a,
                                                                                                      SM_LabourLedgerList AS 
                                                                                                      b
                                                                                               WHERE  a.id = b.llId
                                                                                                      AND b.type = '1'
                                                                                               GROUP BY b.orgId,a.type,a.size
                                                                     ) AS d
                                                              WHERE  a.size = d.size
                                                                     AND b.type = d.type
                                                                     AND b.id = a.gpId
                                                                     AND c.orgId = d.orgId
               ) AS c
               LEFT JOIN T_ORGANIZATION AS d ON  c.orgId = d.OID
               LEFT JOIN T_CODETABLE AS e ON  e.Code = 'SMEMPSIZETYPE'
               LEFT JOIN T_CODETABLE AS f ON  f.Code = 'SMEMPSIZENAME'
        WHERE  a.type = c.type
               AND a.type = e.value
               AND a.size = c.size
               AND a.size = f.value
               AND b.type = '1'
               AND b.orgId = c.orgId
        GROUP BY c.planYear,c.orgId,c.type,c.size,c.quantityAll,c.arrivalDate,d.ONAME,e.name,f.name,c.quantitys,c.dealData
       ) AS TEMP

[三断笛]

这种子查询的应该用CTE或视图才好

[三断笛]

劝楼主淡定,这种东西见多了也就习惯了.在走之前你也可以留下这样一段乱码,折磨后面维护的人

[geniuswjt]

同感啊！！！不整洁的代码看都不想看啊！尼玛啊！

[jikuiyu]

整理后看着不是太晕， 没有整理前我果断删除重写

[koumingjie]

同情楼主啊！！！！

[chtzhking]

同情！~楼主淡定，选择了这一行就一如既往的走下去！~~~

[seeQe]

如果考研究生当然比什么都好,
写程序有新手,老手,高手,大师等等之分,
如果一个新手,
强求他能如一个高手规范那样写,难

[cxmcxm]

太复杂的最好先将结果存到表变量中

[wangxiaofeiwuqiao]

[xiaoxiangqing]

写得有点复杂