ÈçºÎ°ÑÕâ¾äsqlÓï¾äת»¯Îªaccess¿ÉÓõģ¿

SQL code:

select datename(weekday,riqi) as ÐÇÆÚ,
CUSTOMER_ID,
CUSTOMER_NAME,
CUSTOMER_ADDRESS,
BUY_TIME,
BUY_TIMES,
WRITE_TIMES,
sum(CARD_EN) as CARD_EN,
sum(BUY_MONEY) as BUY_MONEY,
sum(BC_YSJE) as BC_YSJE,
sum(SUM_USE) as SUM_USE,
sum(REMAIN_EN) as REMAIN_EN,
convert(varchar(10),BUY_TIME,120) as [date]
from
T_BUT_RECORD
group by
CUSTOMER_ID,CUSTOMER_NAME,CUSTOMER_ADDRESS,BUY_TIME,BUY_TIMES,WRITE_TIMES,convert(varchar(10),BUY_TIME,120)

union all

select '×ܼÆ',
CUSTOMER_ID,
CUSTOMER_NAME,
CUSTOMER_ADDRESS,
BUY_TIME,BUY_TIMES
,WRITE_TIMES,
sum(BUY_MONEY) as BUY_MONEY,
sum(BC_YSJE) as BC_YSJE,
sum(SUM_USE) as SUM_USE,
sum(REMAIN_EN) as REMAIN_EN,
convert(varchar(10),getdate(),120)
from T_BUT_RECORD
group by CUSTOMER_ID,CUSTOMER_NAME,CUSTOMER_ADDRESS,BUY_TIME,BUY_TIMES,WRITE_TIMES



datename,convert,getdate,Çó¾È°¡~~

---

select format(riqi,'DDD') as ÐÇÆÚ,
    CUSTOMER_ID,
    CUSTOMER_NAME,
    CUSTOMER_ADDRESS,
    BUY_TIME,
    BUY_TIMES,
    WRITE_TIMES,
    sum(CARD_EN) as CARD_EN,
    sum(BUY_MONEY) as BUY_MONEY,
    sum(BC_YSJE) as BC_YSJE,
    sum(SUM_USE) as SUM_USE,