SQL语句问题
DECLARE @SQL varchar(8000)
SET @SQL='SELECT GoodsCode'
SELECT @SQL= @SQL+ ',SUM(CASE WHEN StoreCode = ' + CAST(StoreCode AS VARCHAR) +
' THEN GoodsSellAmount END) [' + 'StoreCode' + CAST(StoreCode AS VARCHAR) + ']'
FROM (SELECT DISTINCT StoreCode FROM MainStore) a
SET @SQL=@SQL+' FROM MainStore GROUP BY GoodsCode'
EXEC (@SQL)
帮我解释一下,用一条SQL语句怎么写。SELECT @SQL= @SQL.... 这种语句我看不明白