存盤程序中傳入月份（如2019-06），遍歷一個月份中的每一天 ,并列轉行
uj5u.com熱心網友回復：
declare @dt date,@first date,@days int,@sql nvarchar(max)
set @dt = '2019-6-8'
select @first = dateadd(d,-datepart(d,@dt)+1,@dt),@days=31-datepart(d,dateadd(d,31,@first))
select @sql = 'select * from (select dateadd(d,number,@first) as dt,number+1 as dayNumber from master..spt_values where type=''p'' and number<=@days) a pivot(max(dt) for dayNumber in ('
+ stuff((
select ',['+convert(varchar,number+1)+']' from master..spt_values where type='p' and number<=@days for xml path('')
),1,1,'')+')) p'
exec sp_executesql @sql,N'@first date,@days int',@first=@first,@days=@days
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/149518.html
標籤：疑難問題
上一篇：深圳ERP云專案組團