VBA 中的 SQL 错误

发布于 2024-08-22 08:21:17 字数 666 浏览 7 评论 0原文

我在 SQL (2005) 中有以下代码，它计算系统上的平均用户登录次数：

   with 
  user_total as 
  (
  select COUNT(distinct ID) as counter 
   FROM [dbo].[LOG]
   where [LOG].DESCRIPTION='Login success.' 
         AND  
     Convert(datetime,convert(char(10),[LOG].CREATED_ON,101)) BETWEEN '2009-01- 01'         AND '2009-12-31'

      ),
      USER_avg as
      (
     select  counter/365   as Avarage_Daily_Logins
     from user_total 
     )

      select *
     from USER_avg

现在的问题是，当我将其放入 excel 中的 VBA 宏中以在 strSQL =“此处显示的查询”中的特定单元格中获取结果时“我在 excel 中遇到错误

关键字附近的系统语法不正确

值得一提的是，我不会在多行中破坏 VBA 中的代码..我将所有内容都放在一行中。

原文

I have the following code in SQL (2005) which calculates the avarage user logins on a systm:

   with 
  user_total as 
  (
  select COUNT(distinct ID) as counter 
   FROM [dbo].[LOG]
   where [LOG].DESCRIPTION='Login success.' 
         AND  
     Convert(datetime,convert(char(10),[LOG].CREATED_ON,101)) BETWEEN '2009-01- 01'         AND '2009-12-31'

      ),
      USER_avg as
      (
     select  counter/365   as Avarage_Daily_Logins
     from user_total 
     )

      select *
     from USER_avg

Now the problem is when i put this in a VBA macro in excel to get the result in a spcific cell in strSQL = "QUERY SHOWN ABOVE HERE" argument i get the error in excel