春兰秋菊夏清风，三星望月挂夜空，不求独避风雨外，只笑桃源非梦中.

我还没来得急复制

为什么又秒沉

SELECT 'histroy member' ,COUNT(DISTINCT CASE WHEN XMB_CARD_CATEGORY IN (3) AND XMB_CHANGED_CARD_FLAG=1 THEN CST_ID END ) ,COUNT(DISTINCT CASE WHEN XMB_CARD_CATEGORY IN (3) AND XMB_CHANGED_CARD_FLAG=1 AND c.pur_cst_id IS NOT NULL THEN CST_ID END) ,COUNT(DISTINCT CASE WHEN XMB_CARD_CATEGORY IN (3) AND XMB_CHANGED_CARD_FLAG=1 AND b.pur_cst_id IS NOT NULL THEN CST_ID END) ,0FROM dbo.XMEMBERSHIP WITH(NOLOCK) JOIN dbo.BMEMBERSHIP WITH(NOLOCK)ON MMB_ID=XMB_MMB_ID JOIN dbo.BCUSTOMER WITH(NOLOCK) ON CST_ID= MMB_CST_ID LEFT JOIN #pur_re b ON b.pur_cst_id=CST_ID LEFT JOIN #pur_0 c ON c.pur_cst_id=CST_IDWHERE CST_DELETED_FLAG=0 AND cst_id NOT IN (SELECT DISTINCT pur_cst_id FROM #pur_ed WHERE pur_cst_id IS NOT NULL)

点了顶 点了关注 然后呢。。

没人吗

自顶

{print $v['url']/}

每个人在学车的路上都会遇见一群横行霸道的死老头死老太，请不要对他们动怒，他们是上帝的礼物，是上辈子折了翼的天使，如今来考验你的技术，让你顺利通过路考。看，他们多可爱呀～