lol.sql

use kcmod
go

select ISTK.Nom_Vag,						
	case
		when ISTK.PoluchOKPO>0 
			then coalesce( 
					(select top 1 '' from dbo.nsDoroga)
					, 'ОКПО грузополучателя - '+cast(ISTK.PoluchOKPO as varchar(123))
					, ''
					)
	end as GruzPol

from dbo.nvVagPrivatAT
join dbo.VagonISTK ISTK on ISTK.Nom_Vag = nvVagPrivatAT.Nom_Vag