SQL WHEN函数-如何修复语法错误? [英] SQL WHEN function - How to fix Syntax Error?

问题描述

我是SQL编码的新手，到目前为止，我仅遇到一个错误代码. 在第二行WHEN CONVERT:

I am new to SQL coding and I am encountering only one error code so far. At the second line WHEN CONVERT:

(rd.254是我的餐桌日期栏)

CASE WHEN CONVERT(date,rd.F254) Between 
CONVERT(date,getdate()-7) AND CONVERT(date, getdate()-1) THEN rd.F64 END AS QtyLastWeek

WHEN CONVERT(date,rd.F254) <= CONVERT(date,getdate()-8) THEN rd.F64 END AS Qty2WeeksAgo

我正在尝试查找并修复语法.

I am trying to find and fix the syntax.

推荐答案

您缺少逗号和大小写

CASE WHEN CONVERT(date,rd.F254) Between CONVERT(date,getdate()-7) AND CONVERT(date, getdate()-1) THEN 
   rd.F64 
END AS QtyLastWeek,
CASE WHEN CONVERT(date,rd.F254) <= CONVERT(date,getdate()-8) THEN 
   rd.F64 
END AS Qty2WeeksAgo

这篇关于SQL WHEN函数-如何修复语法错误?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！