2011-06-01
摘要:
select c.sn, d.sn, c.due_date - d.due_datefrom(select * FROM ImpDn where sn%2 = 0) cjoin (select * from ImpDn where sn%2 = 1) don d.sn+1 = c.sn(select ROW_NUMBER() OVER (ORDER BY NEWID()) AS RowNo FROM ImpDn) 阅读全文
posted @ 2011-06-01 20:03 周泉 阅读(136) 评论(0) 推荐(0) 编辑