Error Converting Varchar to Bigint Finder

SELECT * FROM openrowset(bulk 'C:\file.csv' ,formatfile='C:\file.xml' ,firstrow=1) as z Where isnumeric(Company) = 0 OR isnumeric(Customer) = 0 OR isnumeric(Salesman) = 0 OR isnumeric(OrderLim) = 0 OR isnumeric(CreditLim) = 0 OR isnumeric(CreditRevdays) = 0 OR isnumeric(HighBal01) = 0 OR isnumeric(HighBal02) = 0 OR isnumeric(HighBal03) = 0 OR isnumeric(HighBal04) = 0 OR isnumeric(HighBal05) = 0 OR isnumeric(HighBal06) = 0 OR isnumeric(HighBal07) = 0 OR isnumeric(HighBal08) = 0 OR isnumeric(HighBal09) = 0 OR isnumeric(HighBal10) = 0 OR isnumeric(HighBal11) = 0 OR isnumeric(HighBal12) = 0 OR isnumeric(HighBal13) = 0 OR isnumeric(PerRtms01) = 0 OR isnumeric(PerRtms02) = 0 OR isnumeric(PerRtms03) = 0 OR isnumeric(PerRtms04) = 0 OR isnumeric(PerRtms05) = 0 OR isnumeric(PerRtms06) = 0 OR isnumeric(PerRtms07) = 0 OR isnumeric(PerRtms08) = 0 OR isnumeric(PerRtms09) = 0 OR isnumeric(PerRtms10) = 0 OR isnumeric(PerRtms11) = 0 OR isnumeric(PerRtms12) = 0 OR isnumeric(PerRtms13) = 0 OR isnumeric(CollectDays01) = 0 OR isnumeric(CollectDays02) = 0 OR isnumeric(CollectDays03) = 0 OR isnumeric(CollectDays04) = 0 OR isnumeric(CollectDays05) = 0 OR isnumeric(CollectDays06) = 0 OR isnumeric(CollectDays07) = 0 OR isnumeric(CollectDays08) = 0 OR isnumeric(CollectDays09) = 0 OR isnumeric(CollectDays10) = 0 OR isnumeric(CollectDays11) = 0 OR isnumeric(Year2Days) = 0 OR isnumeric(DispNbr) = 0 OR isnumeric(DiscGracePd) = 0 OR isnumeric(CrVarPct) = 0 OR isnumeric(DbtRatio01) = 0 OR isnumeric(DbtRatio02) = 0 OR isnumeric(DbtRatio03) = 0 OR isnumeric(DbtRatio04) = 0 OR isnumeric(DbtRatio05) = 0 OR isnumeric(DbtRatio06) = 0 OR isnumeric(DbtRatio07) = 0 OR isnumeric(DbtRatio08) = 0 OR isnumeric(DbtRatio09) = 0 OR isnumeric(DbtRatio10) = 0 OR isnumeric(DbtRatio11) = 0 OR isnumeric(DbtPrYr) = 0 OR isnumeric(FinGracDays) = 0 OR isnumeric(LastDunn) = 0 OR isnumeric(AgingCode) = 0 OR isnumeric(LstDunltrStm) = 0 OR isnumeric(ObjId) = 0

Be the first to comment

You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.