請問如何將varchar轉換成int類型
完成下面的結果:
declare @new table
( code char(20),sdate char(20),sumsales money,sumtax money)
insert into @new
select tihinvoicecode,tihmovedate,tihsmhaccount,tihsmhpay from tmpinvoiceheader union all
select tihinvoicecode,tihmovedate,tihsmhaccount,tihsmhpay from tmpinvoiceheader_bad

select a=min(code),b=max(code),c=min(sdate),d=max(sdate),e=sum(sumsales),f=sum(sumtax)
from @new
group by ( cast(code as int)-1)/50

謝謝!!!!

上面一段代碼最後有錯誤,
即:group by ( cast(code as int)-1)/50這兒提示varchar類型轉換為int類型時語法錯誤!

--add a filter,try

select a=min(code),b=max(code),c=min(sdate),d=max(sdate),e=sum(sumsales),f=sum(sumtax)
from @new
where isnumeric(code)=1 --here
group by ( cast(code as int)-1)/50