如何使用Sql获取像Calander Page的DAte和Month Name [英] How to get DAte and Month Name like Calander Page using Sql

问题描述

使用此查询如何获得类似日历类型的表格

Using This query how get like Calendar type Table like

Sunday	Monday	Tuesday	Wednesday Thursday Friday Saturday
                    1     2         3        4       5
6          7        8     9        10      11      12
13        14
.......

Declare @Month as int =2010, @Year As int =1

SELECT * from (
SELECT
	cast('01' AS varchar) + Number AS [CurDate],
	DAteName(WEEKDAY, cast('01' AS varchar) + Number) AS [MyName]
	
FROM master..spt_values
WHERE type = 'P' 

AND
(CAST(CAST(@year AS VARCHAR) + '-' + CAST(@Month AS VARCHAR) + '-01' AS DATETIME) + Number )
<
DATEADD(mm,1,CAST(CAST(@year AS VARCHAR) + '-' + CAST(@Month AS VARCHAR) + '-01' AS DATETIME))

) k
pivot 
(
	min(CurDate) for MyName in (Sunday,Monday,Tuesday,Wednesday,Thursday,Friday,Saturday) 
)k1

推荐答案

不要。

这些是演示功能，而不是数据检索 - 如果没有别的，月份和日期名称将取决于客户端的文化设置 - SQL服务器计算机i不太可能访问。



使用演示文稿控件或报告生成基于日历的数据，而不是SQL。

Don't.
Those are presentation functions, not data retrieval - if nothing else, the month and day names will depend on the client's culture settings - which the SQL server computer is very unlikely to have access to.

Use presentation controls or reports to generate calendar based data, not SQL.

这篇关于如何使用Sql获取像Calander Page的DAte和Month Name的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！