Hello people,
I have made following query
this one works fine
Code:
SELECT DISTINCT
CAST (tt.OrderNr AS varchar(10)) + ' – ' + PostIt.Text AS 'Context Matches'
FROM [Teknotrans_dev].dbo.OpusOrder as tt INNER JOIN
[MyDB].dbo.CompanyMain as c On tt.bolagsnr = c.id INNER JOIN
[MyDB].dbo.OpusOrderrow as ord On ord.ordernr = tt.ordernr INNER JOIN
[MyDB].dbo.PostIt as PostIt On PostIt.ordernr = tt.ordernr INNER JOIN
[MyDB].dbo.OrderCompanyName as snSrc ON ord.kallspraknr = snSrc.spraknr INNER JOIN
[MyDB].dbo.OrderCompanyName as snTrg ON ord.malspraknr = snTrg.spraknr
Now is my issue...
I want to include one column more to the cast seperated by "–"
columnname is:
tt.quationnr
the column contains two different values 0 or -1
could someone help me?
Thank you in advance