select s.id,s.ad,(CONCAT(FORMAT(SUM(bd.yon*bd.adet_miktar)),3,'tr_TR' as Miktar,CONCAT('₺',FORMAT( sum( ISNULL(.tutar_satir,0)),2,'tr_TR')) as Tutar
from Temp.dbo.temp_belge_detay as bd
inner join Toyaplus.dbo.stok s on s.id=bd.stok_id
where bd.tarih BETWEEN '@bastar' and '@bittar' and bd.tnm_lokasyon_id=@lokasyon
GROUP BY s.id,s.ad,s.stok_grup_id,s.alis_fiyat
order by ad asc
Hata Kodu
Msg 189, Level 15, State 1, Line 1
The concat function requires 2 to 254 arguments.