--Stok Kodundan
DECLARE @SK NVARCHAR(50)
SET @SK='8690625010014'
SELECT F4Fiyat,F4FiyatH,F4Kdv,F4DovizKodu,SatisKdv,Kodu,* FROM StokFiyat WHERE Kodu=@SK
SELECT F4Fiyat,F4Kdv ,F4DovizKodu,AlisKdv ,SatisKdv,DepartmanKodu ,G.GrupKodu,G.GrupAdi,G.Deger ,Kodu, * FROM STOKKARTI S join GRUP G ON S.DepartmanKodu=G.GrupAdi WHERE Kodu=@SK
SELECT * FROM STOKHAR WHERE StokKodu=@SK order by FaturaTarihi desc
SELECT * FROM StokDB WHERE StokKodu=@SK
SELECT * FROM StokBarkodlari WHERE StokKodu=@SK


