[ pl4stik @ 21.05.2008. 13:10 ] @
Code: CREATE PROCEDURE dbo.SelPoIntervalu DECLARE @Korisnik varchar(50) DECLARE @Kome varchar(50) DECLARE @OdDatuma smalldatetime DECLARE @DoDatuma smalldatetime SET @Korisnik = NULL SET @Kome = NULL SET @OdDatuma = NULL SET @DoDatuma = NULL SELECT IDdokument, Korisnik, Kome, Naziv, Broj, Datum, Opis, Doc, Odobreno FROM dokumenta WHERE (@Korisnik IS NULL OR Korisnik = @Korisnik) AND (@Kome IS NULL OR Kome = @Kome) AND (@OdDatuma IS NULL) AND (@DoDatuma IS NULL) OR (@Korisnik IS NULL OR Korisnik = @Korisnik) AND (@Kome IS NULL OR Kome = @Kome) AND (@DoDatuma IS NULL) AND (Datum >= @OdDatuma) OR (@Korisnik IS NULL OR Korisnik = @Korisnik) AND (@Kome IS NULL OR Kome = @Kome) AND (@OdDatuma IS NULL) AND (Datum <= @DoDatuma) OR (@Korisnik IS NULL OR Korisnik = @Korisnik) AND (@Kome IS NULL OR Kome = @Kome) AND (Datum >= @OdDatuma) AND (Datum <= @DoDatuma) Kad pokusam da sacuvam proc javlja gresku " Incorrect syntax near the keyword 'DECLARE' " |