2010年3月23日
CTE sample
摘要： ;WITH CTEAS(SELECTEventName, EventValue, ActiveFrom, [version],Ranking = DENSE_RANK() OVER(PARTITION BY EventName, ActiveFrom ORDER BY [version] desc)FROM dbo.Schedulewhere (EventName IN ('ECode', 'EFSchools Image V2', 'ESchools Caption V2', 'ESchools Copy1 V2', ' 阅读全文
posted @ 2010-03-23 10:42 Marco CAO 阅读(166) 评论(0) 推荐(0) 编辑