摘要: --combine the column ToNo and column ToSName.SELECTt.id,TONo=CASE WHEN t.id=( SELECT MIN(id) FROM @TableHaveEndNumber WHERE TONo=t.TONo ) THEN t.TONo ELSE '' END,TOSName=CASE WHEN t.id=( SELECT MIN(id) FROM @TableHaveE... 阅读全文
posted @ 2012-10-24 15:48 sshh 阅读(879) 评论(0) 推荐(0) 编辑