|
select convert(char(10),c_au_dt,120) as 日期,
c_id as 單據(jù)號,
c_au_userno+u.c_name as 操作員,
t.node.value('c_col1[1]','varchar(1000)') as 沃爾瑪卡號,
t.node.value('c_col2[1]','varchar(1000)') as 新象城卡號,
t.node.value('c_col3[1]','varchar(1000)') as 類型,
t.node.value('c_col4[1]','varchar(1000)') as 面值,
t.node.value('c_col5[1]','varchar(1000)') as 手續(xù)費,
t.node.value('c_col6[1]','varchar(1000)') as 合計,
t.node.value('c_col7[1]','varchar(1000)') as 現(xiàn)金,
t.node.value('c_col8[1]','varchar(1000)') as 銀行卡,
t.node.value('c_col9[1]','varchar(1000)') as 付款合計,
t.node.value('c_col10[1]','varchar(1000)') as 備注
from tbc_eform_data td cross apply c_data.nodes('/rows/row/DateList/drows/drow') as t(node),tb_user u
where td.c_au_userno=u.c_userno
and c_eform_guid='770831CD-5A88-4C4F-B70D-A9A681E1FF25'
and td.c_status='已審核'
and (@操作員=''or @操作員 is null or c_au_userno=@操作員)
and (@類型 is null or @類型='' or c_data.value('(/rows/row/DateList/drows/drow/c_col3)[1]','nvarchar(max)')=@類型)
and t.node.value('c_col1[1]','varchar(1000)')<>''
and td.c_status='已審核'
and datediff(day,c_au_dt,@開始日期)<=0
and datediff(day,c_au_dt,@結束日期)>=0
|
加好友 
發(fā)短信
Post By：2012/4/10 15:02:02
