Notes
Notes - notes.io |
@SectorID int,
@ParentSectorID int,
@IncludeOptionDepartman bit,
@IncludeOptionFaaliyet bit,
@IncludeOptionHukukiSebep bit,
@IncludeOptionIdariTedbir bit,
@IncludeOptionIlgiliMevzuat bit,
@IncludeOptionIlgiliPolitika bit,
@IncludeOptionIlgiliSozlesme bit,
@IncludeOptionImhaSebebi bit,
@IncludeOptionImhaSuresi bit,
@IncludeOptionImhaYontemi bit,
@IncludeOptionIslemeAmaci bit,
@IncludeOptionIslemeYontemi bit,
@IncludeOptionKisiGrubu bit,
@IncludeOptionSaklamaOrtami bit,
@IncludeOptionTeknikTedbir bit,
@IncludeOptionUretilenCikti bit,
@IncludeOptionVeri bit,
@IncludeOptionVeriIsleyen bit,
@IncludeOptionVeriKategori bit,
@IncludeOptionVeriKaynagi bit,
@IncludeOptionVeriyiSunan bit,
@IncludeOptionYurtdisiAktarimDayanak bit,
@IncludeOptionYurtdisiAktarimSebep bit,
@IncludeOptionYurtdisiAktarimYontem bit,
@IncludeOptionYurtdisiAktarimZamanlama bit,
@IncludeOptionYurtdisiAlici bit,
@IncludeOptionYurticiAktarimDayanak bit,
@IncludeOptionYurticiAktarimSebep bit,
@IncludeOptionYurticiAktarimYontem bit,
@IncludeOptionYurticiAktarimZamanlama bit,
@IncludeOptionYurticiAlici bit,
@IsDeleted bit
as
IF @IncludeOptionDepartman = 1
begin
select * from OptionDepartman where ((CompanyID is null and UserID is null and SectorID in (@SectorID, @ParentSectorID))) and IsDeleted = @IsDeleted order by Name
end
IF @IncludeOptionFaaliyet = 1
begin
select * from OptionFaaliyet where ((CompanyID is null and UserID is null and SectorID in (@SectorID, @ParentSectorID))) and IsDeleted = @IsDeleted order by Name
end
IF @IncludeOptionHukukiSebep = 1
begin
select * from OptionHukukiSebep where ((CompanyID is null and UserID is null and SectorID in (1, @SectorID, @ParentSectorID))) and IsDeleted = @IsDeleted order by Name
end
IF @IncludeOptionIdariTedbir = 1
begin
select * from OptionIdariTedbir where ((CompanyID is null and UserID is null and SectorID in (1, @SectorID, @ParentSectorID))) and IsDeleted = @IsDeleted order by Sequence
end
IF @IncludeOptionIlgiliMevzuat = 1
begin
select * from OptionIlgiliMevzuat where ((CompanyID is null and UserID is null and SectorID in (@SectorID, @ParentSectorID))) and IsDeleted = @IsDeleted order by Name
end
IF @IncludeOptionIlgiliPolitika = 1
begin
select * from OptionIlgiliPolitika where ((CompanyID is null and UserID is null and SectorID in (1, @SectorID, @ParentSectorID))) and IsDeleted = @IsDeleted order by Name
end
IF @IncludeOptionIlgiliSozlesme = 1
begin
select * from OptionIlgiliSozlesme where ((CompanyID is null and UserID is null and SectorID in (1, @SectorID, @ParentSectorID))) and IsDeleted = @IsDeleted order by Name
end
IF @IncludeOptionImhaSebebi = 1
begin
select * from OptionImhaSebebi where ((CompanyID is null and UserID is null and SectorID in (1, @SectorID, @ParentSectorID))) and IsDeleted = @IsDeleted order by Name
end
IF @IncludeOptionImhaSuresi = 1
begin
select * from OptionImhaSuresi where ((CompanyID is null and UserID is null and SectorID in (1, @SectorID, @ParentSectorID))) and IsDeleted = @IsDeleted order by Name
end
IF @IncludeOptionImhaYontemi = 1
begin
select * from OptionImhaYontemi where ((CompanyID is null and UserID is null and SectorID in (1, @SectorID, @ParentSectorID))) and IsDeleted = @IsDeleted order by Name
end
IF @IncludeOptionIslemeAmaci = 1
begin
select * from OptionIslemeAmaci where ((CompanyID is null and UserID is null and SectorID in (1, @SectorID, @ParentSectorID))) and IsDeleted = @IsDeleted order by Sequence, Name
end
IF @IncludeOptionIslemeYontemi = 1
begin
select * from OptionIslemeYontemi where ((CompanyID is null and UserID is null and SectorID in (@SectorID, @ParentSectorID))) and IsDeleted = @IsDeleted order by Name
end
IF @IncludeOptionKisiGrubu = 1
begin
select * from OptionKisiGrubu where ((CompanyID is null and UserID is null and SectorID in (1, @SectorID, @ParentSectorID))) and IsDeleted = @IsDeleted order by Sequence, Name
end
IF @IncludeOptionSaklamaOrtami = 1
begin
select * from OptionSaklamaOrtami where ((CompanyID is null and UserID is null and SectorID in (1, @SectorID, @ParentSectorID))) and IsDeleted = @IsDeleted order by Name
end
IF @IncludeOptionTeknikTedbir = 1
begin
select * from OptionTeknikTedbir where ((CompanyID is null and UserID is null and SectorID in (1, @SectorID, @ParentSectorID))) and IsDeleted = @IsDeleted order by Sequence
end
IF @IncludeOptionUretilenCikti = 1
begin
select * from OptionUretilenCikti where ((CompanyID is null and UserID is null and SectorID in (1, @SectorID, @ParentSectorID))) and IsDeleted = @IsDeleted
end
IF @IncludeOptionVeri = 1
begin
select * from OptionVeri where ((CompanyID is null and UserID is null and SectorID in (1, @SectorID, @ParentSectorID))) and IsDeleted = @IsDeleted order by OptionVeriKategoriID, Name
end
IF @IncludeOptionVeriIsleyen = 1
begin
select * from OptionVeriIsleyen where ((CompanyID is null and UserID is null and SectorID in (@SectorID, @ParentSectorID))) and IsDeleted = @IsDeleted order by Name
end
IF @IncludeOptionVeriKategori = 1
begin
select * from OptionVeriKategori where ((CompanyID is null and UserID is null and SectorID in (1, @SectorID, @ParentSectorID))) and IsDeleted = @IsDeleted order by Name
end
IF @IncludeOptionVeriKaynagi = 1
begin
select * from OptionVeriKaynagi where ((CompanyID is null and UserID is null and SectorID in (@SectorID, @ParentSectorID))) and IsDeleted = @IsDeleted order by Name
end
IF @IncludeOptionVeriyiSunan = 1
begin
select * from OptionVeriyiSunan where ((CompanyID is null and UserID is null and SectorID in (1, @SectorID, @ParentSectorID))) and IsDeleted = @IsDeleted order by Name
end
IF @IncludeOptionYurtdisiAktarimDayanak = 1
begin
select * from OptionYurtdisiAktarimDayanak where ((CompanyID is null and UserID is null and SectorID in (1, @SectorID, @ParentSectorID))) and IsDeleted = @IsDeleted order by Name
end
IF @IncludeOptionYurtdisiAktarimSebep = 1
begin
select * from OptionYurtdisiAktarimSebep where ((CompanyID is null and UserID is null and SectorID in (1, @SectorID, @ParentSectorID))) and IsDeleted = @IsDeleted order by Name
end
IF @IncludeOptionYurtdisiAktarimYontem = 1
begin
select * from OptionYurtdisiAktarimYontem where ((CompanyID is null and UserID is null and SectorID in (1, @SectorID, @ParentSectorID))) and IsDeleted = @IsDeleted order by Name
end
IF @IncludeOptionYurtdisiAktarimZamanlama = 1
begin
select * from OptionYurtdisiAktarimZamanlama where ((CompanyID is null and UserID is null and SectorID in (1, @SectorID, @ParentSectorID))) and IsDeleted = @IsDeleted order by Name
end
IF @IncludeOptionYurtdisiAlici = 1
begin
select * from OptionYurtdisiAlici where ((CompanyID is null and UserID is null and SectorID in (1, @SectorID, @ParentSectorID))) and IsDeleted = @IsDeleted
end
IF @IncludeOptionYurticiAktarimDayanak = 1
begin
select * from OptionYurticiAktarimDayanak where ((CompanyID is null and UserID is null and SectorID in (1, @SectorID, @ParentSectorID))) and IsDeleted = @IsDeleted order by Name
end
IF @IncludeOptionYurticiAktarimSebep = 1
begin
select * from OptionYurticiAktarimSebep where ((CompanyID is null and UserID is null and SectorID in (1, @SectorID, @ParentSectorID))) and IsDeleted = @IsDeleted order by Name
end
IF @IncludeOptionYurticiAktarimYontem = 1
begin
select * from OptionYurticiAktarimYontem where ((CompanyID is null and UserID is null and SectorID in (1, @SectorID, @ParentSectorID))) and IsDeleted = @IsDeleted order by Name
end
IF @IncludeOptionYurticiAktarimZamanlama = 1
begin
select * from OptionYurticiAktarimZamanlama where ((CompanyID is null and UserID is null and SectorID in (1, @SectorID, @ParentSectorID))) and IsDeleted = @IsDeleted order by Name
end
IF @IncludeOptionYurticiAlici = 1
begin
select * from OptionYurticiAlici where ((CompanyID is null and UserID is null and SectorID in (1, @SectorID, @ParentSectorID))) and IsDeleted = @IsDeleted
end
|
|
Notes.io is a web-based application for taking notes. You can take your notes and share with others people. If you like taking long notes, notes.io is designed for you. To date, over 8,000,000,000 notes created and continuing...
With notes.io;
- * You can take a note from anywhere and any device with internet connection.
- * You can share the notes in social platforms (YouTube, Facebook, Twitter, instagram etc.).
- * You can quickly share your contents without website, blog and e-mail.
- * You don't need to create any Account to share a note. As you wish you can use quick, easy and best shortened notes with sms, websites, e-mail, or messaging services (WhatsApp, iMessage, Telegram, Signal).
- * Notes.io has fabulous infrastructure design for a short link and allows you to share the note as an easy and understandable link.
Fast: Notes.io is built for speed and performance. You can take a notes quickly and browse your archive.
Easy: Notes.io doesn’t require installation. Just write and share note!
Short: Notes.io’s url just 8 character. You’ll get shorten link of your note when you want to share. (Ex: notes.io/q )
Free: Notes.io works for 12 years and has been free since the day it was started.
You immediately create your first note and start sharing with the ones you wish. If you want to contact us, you can use the following communication channels;
Email: [email protected]
Twitter: http://twitter.com/notesio
Instagram: http://instagram.com/notes.io
Facebook: http://facebook.com/notesio
Regards;
Notes.io Team
