I am trying to make this procedure with TSQL.

I want to learn.I want to improve my SQL programming. I am sure about getting only a scalar value returned. 

Is it a wrong...

Thank you.

Kind regards..

Set @sql=' SELECT '+@fiyatgrup+' FROM dbo.GenelSFiyatlari'+

  ' WHERE UrunID = '+@urunid+' AND FiyatKategorisi='''+@ozelkategori+''''

Set @bfiyat = Execute (@sql)  Returns one row with one column 

Thank you Ian.