ACCESS转MSSQL MS-SQL Server 疑难问题

最新推荐文章于 2022-02-16 21:41:32 发布

fuoplikk99

最新推荐文章于 2022-02-16 21:41:32 发布

阅读量302

点赞数

文章标签： access join null

本文链接：https://blog.csdn.net/fuoplikk99/article/details/6140906

版权

ACCESS转MSSQL MS-SQL Server 疑难问题

TRANSFORM Max(iif(isnull(b.ProjectID),null,a.CurrentWorking)) AS EventContentOfMax
SELECT a.PersonName
FROM Tasks AS a LEFT JOIN [select ProjectID,min(cdate(TaskDate)) as m_TaskDate from Tasks where cdate(TaskDate)>Now group by ProjectID]. AS b ON (cdate(a.TaskDate)=b.m_TaskDate) AND (a.ProjectID=b.ProjectID)
GROUP BY a.PersonName
PIVOT a.ProjectID

帮忙转成MSSQL，先谢了