Select [" + shortReport[0] + "], CAST(Round([" + shortReport[2]+"]*'"+vatpercent+ "',0) AS bigint) as [Cost1], CAST(Round([" + shortReport[2] + "]-([" + shortReport[2] + "]*'" + vatpercent + "'),0)AS bigint) as [Cost2] From[" + txt_sheet.Text + "$] ", con
i want to use CAST and ROUND combined in my SQL QUERY ERROR: Activated Event Time Duration Thread Activated Historical Code Context Exception: Exception thrown: 'System.Data.OleDb.OleDbException' in System.Data.dll ("IErrorInfo.GetDescription failed with E_FAIL(0x80004005)."). Exception thrown: 'System.Data.OleDb.OleDbException' in System.Data.dll ("IErrorInfo.GetDescription failed with E_FAIL(0x80004005).") 28.33s [13336] Main Thread
User contributions licensed under CC BY-SA 3.0