请看看这个sql语句

Question

sql

Answer 1

帮你格式化一下，什么问题啊？报错？不符合需求？性能问题？INSERT  INTO hfgl_Hffpd
        ( comname ,
          tasktypename ,
          sendman ,
          activitynumber ,
          zysj ,
          createtime ,
          Customername ,
          address ,
          phonenumber ,
          custermercode ,
          tasktype
        )
        SELECT TOP 30 PERCENT
                *
        FROM    ( SELECT    ROW_NUMBER() OVER ( ORDER BY z.createtime DESC ) AS ROWNUM ,
                            cp.comname ,
                            dt.tasktypename ,
                            t.sendman ,
                            t.taskcode ,
                            z.zysj ,
                            z.createtime ,
                            c.customername ,
                            c.address ,
                            c.phonenumber ,
                            c.customercode ,
                            dt.tasktype
                  FROM      zyhd_gdrqjmdhZyd z
                            LEFT JOIN task t ON z.rwdid = t.id
                            LEFT JOIN customer c ON t.customerid = c.ID
                            LEFT JOIN company cp ON t.recievecom = cp.id
                            JOIN dic_tasktype dt ON t.tasktypeid = dt.tasktype
                  WHERE     1 = 1
                ) h
        WHERE   DATEDIFF(dd, h.createtime, GETDATE()) = 2

Answer 2

INSERT  INTO hfgl_Hffpd
        ( comname ,
          tasktypename ,
          sendman ,
          activitynumber ,
          zysj ,
          createtime ,
          Customername ,
          address ,
          phonenumber ,
          custermercode ,
          tasktype
        )
        SELECT TOP 30 PERCENT
           comname ,
          tasktypename ,
          sendman ,
          activitynumber ,
          zysj ,
          createtime ,
          Customername ,
          address ,
          phonenumber ,
          custermercode ,
          tasktype
        FROM    ( SELECT    ROW_NUMBER() OVER ( ORDER BY z.createtime DESC ) AS ROWNUM ,
                            cp.comname ,
                            dt.tasktypename ,
                            t.sendman ,
                            t.taskcode ,
                            z.zysj ,
                            z.createtime ,
                            c.customername ,
                            c.address ,
                            c.phonenumber ,
                            c.customercode ,
                            dt.tasktype
                  FROM      zyhd_gdrqjmdhZyd z
                            LEFT JOIN task t ON z.rwdid = t.id
                            LEFT JOIN customer c ON t.customerid = c.ID
                            LEFT JOIN company cp ON t.recievecom = cp.id
                            JOIN dic_tasktype dt ON t.tasktypeid = dt.tasktype
                  WHERE     1 = 1
                ) h
        WHERE   DATEDIFF(dd, h.createtime, GETDATE()) = 2insert语句前后不一一对应

Answer 3

INSERT  INTO hfgl_Hffpd
        ( comname ,
          tasktypename ,
          sendman ,
          activitynumber ,
          zysj ,
          createtime ,
          Customername ,
          address ,
          phonenumber ,
          custermercode ,
          tasktype
        )
        SELECT TOP 30 PERCENT
           comname ,
          tasktypename ,
          sendman ,
          activitynumber ,
          zysj ,
          createtime ,
          Customername ,
          address ,
          phonenumber ,
          custermercode ,
          tasktype感觉一直啊。  30percent  没有指定ORDER BY 啊