Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /****** Object: StoredProcedure [CDN].[SED_Cechofikator] Script Date: 09/14/2012 12:12:17 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE PROCEDURE [CDN].[SED_Cechofikator] @Filtr varchar(255), @operator varchar(50), @nowaNazwa varchar(20)
- AS
- --------------------------------------------------------------------------------------- wyciaganie gidow z filtra
- declare @pos1 INT;
- declare @pos2 INT;
- declare @GIDTyp SMALLINT ;
- declare @GIDNumer INT ;
- declare @staraNazwa varchar(20)
- SET NOCOUNT ON
- SET @pos1 = Patindex('%TrN_GIDTyp=%', @Filtr)+11
- SET @pos2 = Patindex('%AND TrN_GIDNumer%', @Filtr)-2
- SELECT @GIDTyp = convert(smallint,substring(@filtr,@pos1,@pos2-@pos1+1))
- Set @pos1 = Patindex('%TrN_GIDNumer=%', @Filtr)+13
- Set @pos2 = Patindex('%)%', @Filtr)-1
- if @pos2<0 SET @pos2=len(@Filtr)
- select @GIDNumer = convert(int,substring(@filtr,@pos1,@pos2-@pos1+1))
- ---------------------------------------------------------------------------------------- wyciaganie gida opera
- declare @OpeNumer INT
- SELECT @OpeNumer = Ope_GIDNumer FROM CDN.OpeKarty
- WHERE Ope_Nazwisko = @Operator;
- --------
- --------
- select @staraNazwa = TrN_CechaOpis FROM cdn.TraNag
- WHERE TrN_GIDTyp = @GIDTyp AND TrN_GIDNumer = @GIDNumer
- SET @staraNazwa = IsNull(@staraNazwa, '')
- if (@staraNazwa='') OR (@staraNazwa = 'do spakowania')
- Begin
- UPDATE CDN.TraNag SET TrN_CechaOpis = @nowaNazwa
- WHERE TrN_GIDTyp = @GIDTyp AND TrN_GIDNumer = @GIDNumer
- INSERT INTO CDN.SED_TraNag_Cechofikator
- (SEDTrN_typ, SEDTrN_numer, SEDTrN_wartosc)
- VALUES
- (@GIDTyp, @GIDNumer, @nowaNazwa)
- END
- SET NOCOUNT OFF
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement