27,579
社区成员
发帖
与我相关
我的任务
分享
DECLARE @strDate VARCHAR(1000)
DECLARE @Prices INT
SET @strDate=N'2013-04-01','2013-04-02','2013-04-03'
SET @Prices=100
SELECT StoreCode,[2013-04-01],[2013-04-02],[2013-04-03]
FROM(
SELECT [StoreCode],[SalesDate] FROM [Sales].[imp].[Data8IncomeSum]
WHERE prices>@Prices AND SalesDate IN (@strDate)
) AS InComeCount
PIVOT
(COUNT(SalesDate) FOR SalesDate
IN ([2013-04-01],[2013-04-02],[2013-04-03])
) AS ourpivot
DECLARE @strDate VARCHAR(1000)
DECLARE @Prices varchar
--DECLARE @get_str varchar(max)
DECLARE @sql VARCHAR(8000)
SET @strDate=N'''2013-04-01'',''2013-04-02'',''2013-04-03'''
SET @Prices=100
set @sql = '
SELECT StoreCode,[2013-04-01],[2013-04-02],[2013-04-03]
FROM(
SELECT [StoreCode],[SalesDate] FROM [Sales].[imp].[Data8IncomeSum]
WHERE prices>='+@Prices+' AND SalesDate IN ('+@strDate+')
) AS InComeCount
PIVOT
(COUNT(SalesDate) FOR SalesDate
IN ([2013-04-01],[2013-04-02],[2013-04-03])
) AS ourpivot '
exec(@sql)
DECLARE @strDate VARCHAR(1000)
DECLARE @Prices INT
DECLARE @get_str varchar(max)
SET @strDate=N'''2013-04-01'',''2013-04-02'',''2013-04-03'''
SET @Prices=100
set @sql = '
SELECT StoreCode,[2013-04-01],[2013-04-02],[2013-04-03]
FROM(
SELECT [StoreCode],[SalesDate] FROM [Sales].[imp].[Data8IncomeSum]
WHERE prices>@Prices AND SalesDate IN ('+@strDate+')
) AS InComeCount
PIVOT
(COUNT(SalesDate) FOR SalesDate
IN ([2013-04-01],[2013-04-02],[2013-04-03])
) AS ourpivot '
exec(@sql)