is anyone know how to convert sql from TOAD to vs2005, i am building sql for oracle database.
This code work fine in TOAD program, but when I put it in vb.net it give me this error
Error in list of function arguments : 'T' not recognized.
Error in list of function arguments: ')' not recognized.
Unable to parse query text.
SELECT T .NAME, case WHEN T .ORIGNL_QTY = T .COUNT_QTY THEN 100 WHEN T .ORIGNL_QTY = 0 THEN 0 WHEN T .COUNT_QTY = 0 THEN 0 WHEN T .ORIGNL_QTY
> 0 AND T .ORIGNL_QTY > T .COUNT_QTY THEN (1 - round((abs(T .ORIGNL_QTY - T .COUNT_QTY) / T .ORIGNL_QTY), 2))
* 100 WHEN T .COUNT_QTY > 0 AND T .ORIGNL_QTY < T .COUNT_QTY THEN (1 - round((abs(T .ORIGNL_QTY - T .COUNT_QTY) / T .COUNT_QTY), 2))
* 100 END AS PERCENT
FROM TAG T
This code work fine in TOAD program, but when I put it in vb.net it give me this error
Error in list of function arguments : 'T' not recognized.
Error in list of function arguments: ')' not recognized.
Unable to parse query text.