从现有表创建新表

Question

我正在尝试创建一个新的表，将多个表中的列组合成一个简单的表。我编写了这个查询，当我去检索一些数据时，表中除了列名之外什么都没有。我是不是错过了一步？

Select E.PCR_ID as PreHospital_Report
    , E.eTimes_03 as DateofCall
    , R.eResponse_03 as IncidentID
    , R.eResponse_05 as TypeofService
    , GMR.dAgency_02 as GMR_AGENCY_NAME
    , S.eSituation_11 as Primary_Impression
    , S.eSituation_12 as Secondary_Impression
    , D.eDisposition_12 as Incident_Patient_Disposition
    , P.ePatient_15 as Age
    , P.ePatient_16 as Age_Units
    , V.EVitals_01 as Time_Vitals_Taken
    , V.EVitals_18 as Blood_Gluse_Level
    , V.eVitals_23 as Total_Glasgow_Coma_Scale
    , V.eVitals_26 as Level_of_Responsiveness
INTO GMR_FactTable_Call
FROM eTimes E
LEFT JOIN eResponse R ON E.PCR_ID = R.PCR_ID
LEFT JOIN ePatient P ON E.PCR_ID = P.PCR_ID
LEFT JOIN eVitals V ON E.PCR_ID = V.PCR_ID
LEFT JOIN eSituation S ON E.PCR_ID = S.PCR_ID
LEFT JOIN dAgency GMR ON E.PCR_ID = GMR.PCR_ID
LEFT JOIN eDisposition D ON E.PCR_ID = D.PCR_ID
WHERE E.eTimes_03 >= '01/01/2019'

Answer 1

您当前的WHERE子句可能不像您预期的那样行为。改变这一点：

WHERE E.eTimes_03 >= '01/01/2019'

对此：

WHERE E.eTimes_03 >= '20190101'

如果这解决了问题，则意味着当前的WHERE子句不匹配任何数据。这几乎是一个错误，但重要的是始终记住在查询中使用正确的日期文字。上面的更正版本使用了一种明确的格式，无论服务器设置如何，这种格式都应该工作。