行转列实例

关注

原创最新推荐文章于 2026-02-21 09:57:35 发布 343 阅读 AI 写同款· GEO 优化 ›

深入解析SGLang框架：从架构设计到核心组件实现本文深入解析了SGLang框架的架构设计与核心组件实现。SGLang是一个专为大语言模型推理设计的高效框架，其核心优势在于清晰的分层架构、高效的调度策略以及精细的内存管理。文章详细剖析了其客户端接入、服务器端调度、模型执行引擎及Tokenizer/Detokenizer管理器等关键组件，揭示了其实现高性能推理的内部机制。阅读详情

	-- SQL2005
	/*
	DECLARE @CCODE VARCHAR(10)
	DECLARE @COLUMN VARCHAR(2000)
	SET @COLUMN = ''
	DECLARE CUR CURSOR
	FOR SELECT DISTINCT [CCODE] FROM CODE_TEMPLATE WHERE IGRADE = 1 ORDER BY CCODE
	OPEN CUR
	FETCH NEXT FROM CUR INTO @CCODE
	WHILE @@FETCH_STATUS = 0
	BEGIN
		IF LEN(@COLUMN) > 0 SET @COLUMN = @COLUMN + ','
		SET @COLUMN = @COLUMN + '[' + @CCODE + ']'
		FETCH NEXT FROM CUR INTO @CCODE
	END
	CLOSE CUR
	DEALLOCATE CUR

	EXEC('
	SELECT CSECCODE,CASE WHEN IID = 2 THEN ''合计'' ELSE CSECNAME END CSECNAME,'+@COLUMN+'
	FROM (SELECT A.*,B.CSECNAME FROM #RowSet A LEFT JOIN SECTIONS B ON A.CSECCODE = B.CSECCODE) T
		PIVOT (
		SUM (FMONEY)
		FOR 
		[CCODE] IN ('+@COLUMN+')
	) AS P ORDER BY IID,CSECCODE')
	*/

	-- SQL2000
	
	SELECT DISTINCT [CCODE] INTO #TMPCODE FROM CODE_TEMPLATE WHERE IGRADE = 1
	ORDER BY CCODE

	DECLARE @ASQL VARCHAR(8000) 
	SET @ASQL = 'SELECT A.CSECCODE,CASE WHEN IID = 2 THEN ''合计'' ELSE CSECNAME END CSECNAME ' 
	SELECT @ASQL = @ASQL + ' , SUM(CASE CCODE WHEN ''' + CCODE + ''' THEN FMONEY ELSE NULL END) [' + CCODE + ']' 
	FROM #TMPCODE AS A 
	SET @ASQL = @ASQL + ' FROM #RowSet A LEFT JOIN SECTIONS B ON A.CSECCODE = B.CSECCODE 
	GROUP BY A.CSECCODE,IID,B.CSECNAME ORDER BY IID,A.CSECCODE' 
	--PRINT @ASQL	 
	EXEC(@ASQL)

收录于