Goran Bibic

Goran Bibic

  • 482
  • 2.9k
  • 197.8k

select two values from table and insert in one column

Jul 1 2019 1:24 AM
Need select two values from table and insert in one column all need to be text

Need to be this type in 1 column

"Document name -count number - Company"
 
201 ULAZNI RACUN OSTALO -(max(number)) - (select company from dbo.partnert))
  1. 201 ULAZNI RACUN OSTALO' + (max(number)) + (select company from dbo.partner)) 
I try this but error is 
 
Conversion failed when converting the varchar value '201 ULAZNI RACUN OSTALO -' to data type int.

Answers (4)