Am utilizat comanda astfel, fara echo off
sqlcmd -Q "use test select b.id_document from dosar a inner join v_Document b on a.id_dosar=b.id_dosar where b.tipdocument like '%' "
si rezultatul a fost:
C:\Documents and Settings\..>sqlcmd -Q "use test select b.id_document from dosar a inner join v_Document b on a.id_dosar=b.id_dosar where b.tipdocument like '%' "
Changed database context to 'test_tril'.
id_document
--------------------
(0 rows affected)
Lansata: sqlcmd -Q "use test select b.id_document from dosar a inner join v_Document b on a.id_dosar=b.id_dosar"
afiseaza
Changed database context to 'test_tril'.
id_document
--------------------
180
190
210
...
(160 rows affected)
Multumesc.