原语句如下 :
select e.*,w.BufferDays as BufferDays,w.CalendarDate as CalendarDate
from [E_WIPAgingData] e
inner join MCNNT805.[EDashboard].[dbo].[WIP_PMCTracker] w on e.Project=w.subprojectwv COLLATE DATABASE_DEFAUL现在要加个需求:同一条Project有多个Buffer Days的,取Buffer Days 最小的.
select e.*,w.BufferDays as BufferDays,w.CalendarDate as CalendarDate
from [E_WIPAgingData] e
inner join MCNNT805.[EDashboard].[dbo].[WIP_PMCTracker] w on e.Project=w.subprojectwv COLLATE DATABASE_DEFAUL现在要加个需求:同一条Project有多个Buffer Days的,取Buffer Days 最小的.
解决方案 »
- sql server 中如何查看自定义函数的源代码?
- 紧急求一个SQL语句!!!!!!!!非常紧急,今天下午5点前出不来的话就惨了
- 大家帮忙推荐本学习sql server 2005的书。
- 求sql语句
- DBCC CHECKDB 提示以下是什么原因及请教解决方法
- 急啊,如何将ntext字段类型改为nvarchar(1000)的字段类型
- 问问有没方法给sql视图添加自动序号列
- 应用程序的组件中发生了无法处理的异常。。。找不到服务"Microsoft.SqlServer.Management.IRegistrationService"
- 请大家帮我想想有什么办法?谢谢
- sql语句问题,没有思路,怎么查,简单就用sql语句做出来?
- 数据库安装问题
- 使用mysql workbench导入一个sql文件时,出现了这个报错
FROM
(select e.*,w.BufferDays as BufferDays,w.CalendarDate as CalendarDate,
ROW_NUMBER() OVER (PARTITION BY Project ORDER BY BufferDays) AS RN
from [E_WIPAgingData] e
inner join MCNNT805.[EDashboard].[dbo].[WIP_PMCTracker] w on e.Project=w.subprojectwv) AS A
WHERE RN=1
COLLATE DATABASE_DEFAUL
Msg 468, Level 16, State 9, Line 8
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Chinese_PRC_CI_AS" in the equal to operation.
Msg 209, Level 16, State 1, Line 6
Ambiguous column name 'Project'.
from [E_WIPAgingData] e
inner join ( Select *
From MCNNT805.[EDashboard].[dbo].[WIP_PMCTracker] x
Where BufferDays=(Select MIN(BufferDays)
From MCNNT805.[EDashboard].[dbo].[WIP_PMCTracker] y
Where x.subprojectwv=y.subprojectwv)) w on e.Project=w.subprojectwv COLLATE DATABASE_DEFAUL
w.BufferDays AS BufferDays ,
w.CalendarDate AS CalendarDate
FROM [E_WIPAgingData] e
INNER JOIN ( SELECT subprojectwv ,
MIN(BufferDays)
FROM MCNNT805.[EDashboard].[dbo].[WIP_PMCTracker]
GROUP BY subprojectwv
) w ON e.Project = w.subprojectwv COLLATE DATABASE_DEFAUL;