Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
when running in command line, because the number of references B 35 is not listed ?
Load the contents as text:
LOAD text(Código) as Código, Descrição INLINE [
Código, Descrição
'0035', A
'35', B
'0081', C
'80', D
'0030', E
'50', F ] ;
You may try to do that dynamically. Have a look at logic in this nice utility for MSSQL: