大佬教程收集整理的这篇文章主要介绍了多部分标识符无法绑定,大佬教程大佬觉得挺不错的,现在分享给大家,也给大家做个参考。
基本上,您不匹配表名。
在您的FROM
您有:
FROM [dbo].[RunSequenceBatch] AS RunSeq
您是别名,[dbo].[RunSequenceBatch]
也就是说,从现在开始,[dbo].[RunSequenceBatch]
将被称为RunSeq
但是在您中,GROUP BY
您不会使用别名来引用它。因为别名在查询中唯一公开的名称中,dbo.RunSequenceBatch
所以无法绑定。
改变
GROUP BY dbo.RunSequenceBatch.RunSequenceBatchname
到
GROUP BY RunSeq.RunSequenceBatchname
而且您会没事的。
这是我不希望的查询。
它说:不能绑定多部分标识符“ dbo.RunSequenceBatch.RunSequenceBatchName”。
您能否提一些建议?
提前致谢!!!:)
SELECT '30 May' AS [Date],[RunSeq].[RunSequenceBatchName] AS [Batch Job Name],RunSeqCat.CategoryDescription AS [Development Name],[Systems].Systemname AS [System Area],CAST((SUM(DumpSM37_Env3.Duration) / 60) AS NUMERIC(10,2)) AS [Duration (mins)]
FROM [dbo].[RunSequenceBatch] AS RunSeq
LEFT JOIN DumpSM37_Env3 ON ([RunSeq].[RunSequenceBatchName] = DumpSM37_Env3.[Job]
AND DumpSM37_Env3.[ImportDate] betweeN '30 May 2012 00:00:00' AND '30 May 2012 23:59:59'),[dbo].[RunSequenCEType] AS RunSeqType,[dbo].[RunSequenceFrequency] AS RunSeqFrequency,RunSequenceCategory AS RunSeqCat,Category,[Systems]
WHERE RunSeq.Status = 'Active'
AND RunSeqFrequency.RunSequenceBatchID = RunSeq.RunSequenceBatchID
AND RunSeq.RunSequenCETypEID = RunSeqType.RunSequenCETypEID
AND RunSeqCat.CategoryDescription = Category.Description
AND Category.SystemArea = [Systems].SystemID
AND DumpSM37_Env3.[Duration] > 0
AND RunSeq.RunSequenCETypEID = 1
AND RunSeqCat.RunSequenceBatchID = RunSeq.RunSequenceBatchID
GROUP BY dbo.RunSequenceBatch.RunSequenceBatchName,DumpSM37_Env3.WorkerProcessID,ORDER BY [RunSeqFrequency].[Frequency] ASC,[RunSeqFrequency].[StartTime] ASC
以上是大佬教程为你收集整理的多部分标识符无法绑定全部内容,希望文章能够帮你解决多部分标识符无法绑定所遇到的程序开发问题。
如果觉得大佬教程网站内容还不错,欢迎将大佬教程推荐给程序员好友。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。