95.86.62.111/95.86.62.111.tar/95.86.62.111/85/APT5/PregledArkaKartKpm.sql

Text (UTF-16) | 2009-02-09 | 4KB | 55 lines

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO




ALTER     PROCEDURE rk_PregledArkaKartKpm

    @Sifra_Oe        smallint = Null,
    @Sifra_Kor_Od        varchar(20) = Null,
    @Sifra_Kor_Do        varchar(20) = Null,
    @Datum_Ska_Od    smalldatetime = Null,
    @Datum_Ska_Do    smalldatetime = Null,
    @BrKasa        smallint = Null,
    @Grp_Kasa        smallint = Null,
    @Sifra_TipKartKor smallint= null
AS
    Declare @SSQL as varchar(8000)

    Set @SSQL = ' SELECT A.Sifra_Oe, A.Grp_Kasa, A.BrKasa, A.Broj_Ska, A.Sifra_Kor, K.ImeKor,K.Sifra_TipKartKor, A.Sifra_Nac, A.cDatumSka,
                A.Datum_Ska, A.Dolzi, A.Pobaruva, A.FraUpl, A.VnsOnLine, A.Sifra_Kup, A.KlubDolzi, A.Rasknizen
            FROM ArkaKartKpm A
            Left Outer Join ArkaKartKor K ON K.Sifra_Kor = A.Sifra_Kor
            Where 1=1 '
    If @Sifra_Oe Is Not Null
        Set @SSQL = @SSQL + ' And A.Sifra_Oe = ' + Cast(@Sifra_Oe as varchar(6)) + ' '
    If @Sifra_Kor_Od Is Not Null
        Set @SSQL = @SSQL + ' And A.Sifra_Kor >= ''' + @Sifra_Kor_Od + ''' '
    If @Sifra_Kor_Do Is Not Null
        Set @SSQL = @SSQL + ' And A.Sifra_Kor <= ''' + @Sifra_Kor_Do + ''' '
    If @Datum_Ska_Od Is Not Null
        Set @SSQL = @SSQL + ' And A.Datum_Ska >= ''' + Cast(@Datum_Ska_Od as varchar(30)) + ''' '
    If @Datum_Ska_Do Is Not Null
        Set @SSQL = @SSQL + ' And A.Datum_Ska <= ''' + Cast(@Datum_Ska_Do as varchar(30)) + ''' '
    If @BrKasa Is Not Null
        Set @SSQL = @SSQL + ' And A.BrKasa = ' + Cast(@BrKasa as varchar(6)) + ' '
    If @Grp_Kasa Is Not Null
        Set @SSQL = @SSQL + ' And A.Grp_Kasa = ' + Cast(@Grp_Kasa as varchar(6)) + ' '
If @Sifra_TipKartKor Is Not Null
        Set @SSQL = @SSQL + ' And K.Sifra_TipKartKor = ' + Cast(@Sifra_TipKartKor as varchar(6)) + ' '
    Exec(@SSQL)





GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO