查询生成器 [英] Query Builder

问题描述

我需要一个趋势报告，但查询不会在数据集或查询构建器中解析。

我的查询是从头开始计算站立支架一年，在SQL中运行良好。

我做错了什么？

Phil

WITH CTE_Table（ dataDate）AS（SELECT     DATEADD（日， - 1，GETDATE（））

         &NBSP ;                        &NBSP ;                        &NBSP ;       
UNION ALL

          &NBSP ;                      &NBSP ;                        &NBSP ;        
SELECT     DATEADD（日， - 1，dataDate）

                &NBSP ;                        &NBSP ;                        &NBSP ;
FROM         CTE_Table

                    &NBSP ;                        &NBSP ;                     
WHERE     DATEDIFF（日，dataDate，DATEADD（天，DATEDIFF（DAY，GETDATE（），DATEADD（YY，DATEDIFF（YY，0，GETDATE（）），0）），GETDATE（）））≤; 0）

    SELECT     dataDate，COUNT（ScaffID）支柱

     FROM         CTE_Table LEFT JOIN

                   &NBSP ;        RequestInfo ON dataDate> RequestInfo.phase1CompleteDate

     WHERE&NBSP;&NBSP;&NBSP;&NBSP; （phase1CompleteDate< = dataDate）AND（workfaceReleasedDate> = dataDate OR

&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP ;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; workfaceReleasedDate IS NULL）AND contractID = 14，disciplineID = 3和已删除= '假'

     GROUP BY dataDate

     ORDER BY dataDate

解决方案

排序呢！

只是把一些虚假的信息数据集中到创建它然后进入配置并将我的查询放入。

选择

<跨度风格=" 颜色：＃FF00FF;字体大小：小 "> GETDATE 的 <跨度风格="颜色：＃808080;字体大小：小 ">（） 的 dataDate 的 ，
0个脚手架

它没有喜欢它点击完成但工作： - ）

Phil

I need a trend report but the query will not parse in the dataset or query builder.

My query is to get a count of standing scaffolds from the beginning of the year and works fine in SQL.

What am I doing wrong?

Phil

WITH CTE_Table(dataDate) AS (SELECT     dateadd(day, - 1, getdate())
                                                                    UNION ALL
                                                                    SELECT     dateadd(day, - 1, dataDate)
                                                                    FROM         CTE_Table
                                                                    WHERE     datediff(day, dataDate, dateadd(day, DATEDIFF(DAY, GETDATE(), DATEADD(yy, DATEDIFF(yy, 0, getdate()), 0)), getdate())) < 0)
    SELECT     dataDate, COUNT(ScaffID) scaffs
     FROM         CTE_Table LEFT JOIN
                            RequestInfo ON dataDate > RequestInfo.phase1CompleteDate
     WHERE     (phase1CompleteDate <= dataDate) AND (workfaceReleasedDate >= dataDate OR
                            workfaceReleasedDate IS NULL) AND contractID = 14 AND disciplineID = 3 AND deleted = 'False'
     GROUP BY dataDate
     ORDER BY dataDate

解决方案

Sorted it!

Just put some false info in the dataset to create it then went into configure and put my query in.

Select

getdate() dataDate, 0 scaffs

It didn't like it when I clicked finish but worked :-)

Phil

这篇关于查询生成器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！