存储过程:
USE [MODProductReportTest]
GO
/****** Object: StoredProcedure [dbo].[YFp1] Script Date: 10/15/2019 12:36:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[YFp1]
@fileName nvarchar(50)
AS
BEGIN
select @fileName 文件名,'厚度' + 线条 间距1,间距,厚度 into #T1 from YF_BMQ where 文件名=@fileName
DECLARE @sql_str NVARCHAR(4000)
DECLARE @sql_col NVARCHAR(4000)
select @sql_col=AUFNR from (select AUFNR=stuff((select ',['+间距+']'
from (select distinct 间距 from #T1) b for xml path('')),1,1,'')) a
SET @sql_str = 'SELECT * FROM #T1 p PIVOT (MAX(厚度)FOR 间距 IN('+ @sql_col +')) AS pvt' --行转列
exec sp_executesql @sql_str
END
winform界面调用存储过程:
private void ButtonClickSelect()
{
if (comboBox1.Text.Trim() == "")
{
MessageBox.Show("请输入文件名", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;