Doğu Etiketleri

create procedure PRC_DoguHareketNewInvoiceNumber  @MasterId int

as
begin
update Tbl_Dogu_TuvHata set NewInvoiceNumber=InvoiceNumber+'.'  where MasterId=@MasterId
end



exec PRC_DoguHareketNewInvoiceNumber 7511


-------------------------------------------------------


declare @Tabloadi nvarchar (max),
@Sql nvarchar(MAX)



set @Tabloadi='[dbo].[cw_000_firma]'

Set @Sql = 'select * from @TabloAdi'

Set @Sql = REPLACE(@Sql,'@TabloAdi',@Tabloadi)


exec (@Sql)



-------
devam et


declare @DonemId int,
@Id int,
@Id2 int,
@MasterId int


set @MasterId='select Id from TBLARTEMISFIYATBELIRLE where Id=@Id'
set @DonemId= 'select DonemId from TBLARTEMISFIYATBELIRLE  where Id=@Id'


set @Id2= 'select Id from TBLARTEMISMALIYETRAPOR where Donem=@DonemId'


select STOK_KODU from TBLARTEMISFIYATDETAY where MasterId=@MasterId

except

select StokKodu from TBLARTEMISURETILENHALI where MasterId=@Id2