谢谢jspta 老师,我会建简单的表视图啦。
但是这种复杂的还不会。。。
dim ex1, ex2 as string
ex1="DateDiff( m,MAX(消费日期),GetDate())"
ex2 = vbcrlf & "(Case" & vbcrlf
ex2+ ="When " & ex1 & ">= 13 Then '一星活跃'" & vbcrlf
ex2+ ="When " & ex1 & ">= 10 and " & ex1 & " < 13 Then '二星活跃'" & vbcrlf
ex2+ ="When " & ex1 & ">= 6 and " & ex1 & " < 10 Then '三星活跃'" & vbcrlf
ex2+ ="When " & ex1 & ">= 3 and " & ex1 & " < 6 Then '四星活跃'" & vbcrlf
ex2+ = "Else '五星活跃'" & vbcrlf
ex2+ ="End) As 活跃级别 "
create view 视图1 as Select VIP卡号 , " & ex1 & " AS 几个月没来买 , " & ex2 & " from dbo.rjsytVIP消费信息 group by VIP卡号
提示错误:
此主题相关图片如下:视图1.png
![dvubb 图片点击可在新窗口打开查看](UploadFile/2014-3/20143241973571312.png)