SELECT MainMan,SUM(TranAllowance) AS TranAllowancesum,?SUM(BasMainService) AS BasMainServicesum,?SUM(FastService) AS FastServicesum,?SUM(DeskService) AS DeskServicesum,?SUM(McDonService) AS McDonServicesum,?SUM(ServerService) AS ServerServicesum,?SUM(NetworkService) AS NetworkServicesum,?SUM(VulnSystemIntegServices) AS VulnSystemIntegServicessum,LEFT(CONVERT(varchar(100), DisDate, 20),7) AS Time ?FROM TestTable??WHERE dateadd(dd,-day(getdate())+1,getdate()) ? AND ?dateadd(dd,-day(getdate()),dateadd(m,1,getdate())) GROUP ? BY MainMan,LEFT(CONVERT(varchar(100), DisDate, 20),7)??在RoadFlow 我需要查詢日期范圍的內容我查詢的時候會顯示查詢錯誤 ?求大神解答!
關于數據庫方面的問題求大神解答
13151891973849923
2017-03-27 17:09:47