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)
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' "
To sto nekoliko miliona ljudi tvrdi da nisi u pravu ne znaci da stvarno nisi - Frank Zappa
https://youtu.be/DLe358DPGXU
https://youtu.be/DLe358DPGXU