Question

Using the following SQL expression but I m getting an error.

select
  CampaignCustomer.CampaignCustomerID,
  convert(varchar, CampaignCustomer.ModifiedDate, 111) as startdate,
  CampaignCustomer.CampaignID,
  CampaignCustomer.CampaignCallStatusID,
  CampaignCustomer.UserID,
  CampaignCustomerSale.Value,
  Users.Name
from CampaignCustomer
  inner join CampaignCustomerSale
    on CampaignCustomer.CampaignCustomerID = CampaignCustomerSale.CampaignCustomerID
  inner join Users
    on CampaignCustomer.UserID = Users.UserID
where
  CampaignCustomer.CampaignCallStatusID = 21
  and CampaignCustomer.startdate =  2011/11/22       <------- THIS
order by
  startdate desc,
  Users.Name asc

错误:

Msg 207, Level 16, State 1, Line 1
Invalid column name startdate .

我可以肯定一下WHERE条款中的“startdate,但可在我的上查阅。页: 1 什么错误?



Edit:

And no, it is not possible for me to change the datatype to date instead of datetime. The time is needed elsewhere. But in this case, I need only to get all posts on a specific date and I really don t care about what time of the date the modifieddate is :)

或许还需要另一种方法而不是转换?

Answer 1

页: 1 WHERE Clause.

修改如下:

where
  CampaignCustomer.CampaignCallStatusID = 21
  and convert(varchar, CampaignCustomer.ModifiedDate, 111) =  2011/11/22

Answer 2

这是:

select 
  CampaignCustomer.CampaignCustomerID, 
  convert(varchar, CampaignCustomer.ModifiedDate, 111) as startdate, 
  CampaignCustomer.CampaignID, 
  CampaignCustomer.CampaignCallStatusID, 
  CampaignCustomer.UserID, 
  CampaignCustomerSale.Value, 
  Users.Name 
from CampaignCustomer 
  inner join CampaignCustomerSale 
    on CampaignCustomer.CampaignCustomerID = CampaignCustomerSale.CampaignCustomerID 
  inner join Users 
    on CampaignCustomer.UserID = Users.UserID 
where 
  CampaignCustomer.CampaignCallStatusID = 21 
  and convert(varchar, CampaignCustomer.ModifiedDate, 111) =  2011/11/22 
order by 
  startdate desc, 
  Users.Name asc

页: 1 该条款没有具体内容,在以上询问中,我用它所代表的内容取代你的内容。

Answer 3

您只字不提一下一下一下一下Kall的哪些内容? 服务器:

where
  CampaignCustomer.CampaignCallStatusID = 21
  and CAST(CampaignCustomer.ModifiedDate AS DATE) =  20111122

您可将其带至<代码>D-仅为这一比较。

另外,我建议<>途径使用ISO-8601标准格式,如果你需要比较一个显示日期——ISO-8601确定一个日期为。 YYYYMMDD,是SQ的唯一格式永远发挥作用的服务器——无论你有何种语言/区域环境。某一日期的任何其他说明,总是在你的服务器中受到环境的影响——它可能为你工作,但我对其他人说,它会打破。

友情链接