---20201010新VIP卡种类对应查询试图ESM_BAS_VIP_V1New
 if exists(select 1 from sysobjects where id=OBJECT_ID('ESM_BAS_VIP_V1New') and type='V')
 drop view ESM_BAS_VIP_V1New
 GO

CREATE VIEW [dbo].[ESM_BAS_VIP_V1New]
AS
SELECT     vip.id AS 自动编号, vip.vip_id AS 贵宾卡号, kind.VIP_KIND AS 卡种类, vip.vip_name AS 客户姓名,  vip.Vip_Realname as 客户昵称, 
                      CAST(CASE vip.vip_sex WHEN 1 THEN '男' WHEN 0 THEN '女' ELSE '' END AS char(2)) AS 性别, vip.vip_MyId AS 身份证号, vip.vip_reg_date AS 入会时间, 
                      vip.vip_birthday AS 生日, vip.vip_mobil_phone AS 手机, vip.vip_case AS 发卡原因, vip.shp_Id AS 发卡店, vip.vip_bus_tele AS 商务电话, vip.vip_email AS 电子邮件, 
                      vip.vip_bp AS 呼机, vip.vip_add AS 地址, vip.vip_tele AS 电话, vip.vip_type AS 种类, vip.vip_pwd AS 密码, vip.vip_work AS 职业, vip.vip_discount AS 折扣率, 
                      vip.vip_reDiscount AS 允许折上折, vip.vip_upMoney AS 折上折限额, vip.sys_valid AS 状态, vip.sys_memo AS 备注, vip.sys_date AS 日期, vip.VIP_QQ AS QQ, 
                      vip.VIP_microblogging AS 博客, vip.VIP_microchannel AS 微信, DATEPART(year, vip.vip_birthday) AS 生日_年, DATEPART(month, vip.vip_birthday) AS 生日_月, 
                      DATEPART(day, vip.vip_birthday) AS 生日_日
FROM         dbo.BAS_VIP AS vip LEFT OUTER JOIN
                      dbo.BAS_VIP_KINDNew AS kind ON vip.VIP_KIND = kind.VIP_ID
GO