基于动态CTE PIVOT的分析图表设计

The Analysis Charts Design Based on Dynamic CTE PIVOT

在实际业务系统中,经常需要对业务信息的某些方面进行图表分析。通过SqlServer中提供的CTE和PIV-OT技术,结合VS2010提供的Chart控件,介绍一种比较简洁且实用的分析图表设计方法。

People often need to analysis chart in some aspects of business information in the actual business system. This paper introduces a simple and practical design method of analysis Chart ,through the SqlServer providing the CTE and PIV- OT technology and combining VS2010 with Chart control.