SELECT 
	    urLica.name,                      
		urLica.idUrllico, 
		kontakt.nameKontakt,		
		kontakt.idKontakt,		
		kontakt.adresKontakt,		
		kontakt.telefonKontakt,		
		kontakt.other1Kontakt,		
		kontakt.other2Kontakt,		
		users.name AS polzovatel,  
		vib.tip,
		vib.vid, 
		vib.nomerStr, 
		vib.nomer, 
		vib.data, 
		vib.dataDo, 
		vib.summa, 
		vib.summaOpl, 
		vib.komment,
		vib.nomerVhod, 
		vib.vidVhod,  
		vib.proekt,
		vib.so, 
		vib.po, 		
		vib.Percentage, 
		vib.valuta, 
		vib.flag, 
		vib.flag1, 
		vib.driver,
		vib.driverTel,
		vib.driverKoment,
		vib.driverAuto,
		vib.driverRegNom,
		vib.dopInfo                  

	FROM 
	
	(SELECT  
		v.vid, 
		v.nomerStr, 
		v.nomer, 
		v.data, 
		v.dataDo, 
		SUM(v.summa / 100 * (100 - ISNULL(shemaProdaj.procent, 0))) AS summa, 
		v.summaOpl, 
		CAST(v.komment as varchar(4000)) AS komment,
		v.nomerVhod, 
		v.vidVhod,  
		v.proekt,
		v.so, 
		v.po, 		
		0 AS Percentage, 
		v.valuta, 
		v.flag, 
		v.flag1, 
		v.driver,
		v.driverTel,
		v.driverKoment,
		v.driverAuto,
		v.driverRegNom,
		v.dopInfo,
		v.kontragent,
		v.userID,
		v.kontakt,
		(SELECT distinct ''+strukturaTovara.snameZvena 
                 FROM  viborkaTovara AS v2     
			 INNER JOIN tovar ON tovar.idTovar=v2.tovar
				 INNER JOIN strukturaTovara  ON strukturaTovara.idZvena = tovar.vStrukture
                 WHERE v.nomer = v2.nomer
                 FOR XML PATH ('')) as tip                                            
	                            
	FROM         viborkaTovara AS v    
              LEFT OUTER JOIN shemaProdaj ON v.shema =shemaProdaj.idShema
	WHERE v.sklad = @idSklad
	
	GROUP BY v.vid,
		v.nomerStr, 
		v.nomer, 
		v.summaOpl, 
		v.data, 
		CONVERT(varchar(4000), v.komment), 
		v.dataDo,		
		v.nomerVhod, 
		v.vidVhod, 		 
		v.proekt,
		v.so, 
		v.po,
		v.valuta, 
		v.flag, 
		v.flag1, 
		v.driver,
		v.driverTel,
		v.driverKoment,
		v.driverAuto,
		v.driverRegNom,
		v.dopInfo,
		v.vid,
		v.del,
		v.kontragent,
		v.userID,
		v.kontakt
		HAVING (v.vid = @vid) AND (v.del = 0)  AND (SUM(v.kolvo) > SUM(v.aktualnost))  AND ((v.kontragent = @idKontr) OR (@idKontr=-1))) as vib 
		INNER JOIN urLica ON vib.kontragent = urLica.idUrllico  
                          INNER JOIN [dbo].[sotrudniki] AS users ON vib.userID = users.id LEFT OUTER JOIN kontakt	ON vib.kontakt = kontakt.idKontakt