Problem with varchar return value with osql

• abdel-774383

  SSC Journeyman

  Points: 77

  More actions

  June 9, 2008 at 4:55 am

  #121889

  Hi everybody,

  I'm trying to insert an osql command within a DOS batch file (which contains DOS commands) :

  osql -S Server -U User -P PassWord -Q "select top 1 column1 from table1 a, table2 b where b.id=a.id"

  I would like to use the value of the column1 in the continuation of my batch file.

  I tried by using exit :

  osql -S Server -U User -P PassWord -Q "exit(select top 1 column1 from table1 a, table2 b where b.id=a.id)"

  But my problem is that the column1 is not an integer but a varchar, so I have an error message :

  osql: Error converting exit value.

  Any idea ? Many thanks for your help.

• VickyWinner

  SSC Enthusiast

  Points: 165

  More actions

  March 8, 2011 at 2:07 am

  #1295731

  Hi

  I have the same issue. I get the same below error. Can someone help?

  osql: Error converting exit value.