INSERT INTO tfsMeniSkupina (Program,MeniSkupinaID,MeniSkupinaOpis) SELECT N'Bla' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Pregledovalec v programu Blagajna' AS MeniSkupinaOpis WHERE NOT EXISTS (SELECT * FROM tfsMeniSkupina WHERE Program=N'Bla' AND MeniSkupinaID=N'mPregledovalec' AND MeniSkupinaOpis LIKE N'Pregledovalec v programu Blagajna')
INSERT INTO tfsMeniSkupina (Program,MeniSkupinaID,MeniSkupinaOpis) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Pregledovalec v programu Fakturiranje' AS MeniSkupinaOpis WHERE NOT EXISTS (SELECT * FROM tfsMeniSkupina WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND MeniSkupinaOpis LIKE N'Pregledovalec v programu Fakturiranje')
INSERT INTO tfsMeniSkupina (Program,MeniSkupinaID,MeniSkupinaOpis) SELECT N'Os' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Pregledovalec v programu Osnovna sredstva' AS MeniSkupinaOpis WHERE NOT EXISTS (SELECT * FROM tfsMeniSkupina WHERE Program=N'Os' AND MeniSkupinaID=N'mPregledovalec' AND MeniSkupinaOpis LIKE N'Pregledovalec v programu Osnovna sredstva')

INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Bla' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Arhiviranje podatkov' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Bla' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Arhiviranje podatkov')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Bla' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'&Knjiženje' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Bla' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'&Knjiženje')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Bla' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Podrobna nastavitev uporabnikov' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Bla' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Podrobna nastavitev uporabnikov')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Bla' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Analitični kontni plan' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Bla' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Analitični kontni plan')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Bla' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Zaključki' AS TagKontrole, 0 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Bla' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Zaključki')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Bla' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Besedila' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Bla' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Besedila')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Bla' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Prejemniki in vplačniki' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Bla' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Prejemniki in vplačniki')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Bla' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Sestavljalci dokumentov' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Bla' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Sestavljalci dokumentov')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Bla' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Podpisniki dokumentov' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Bla' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Podpisniki dokumentov')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Bla' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Poslovni partnerji' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Bla' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Poslovni partnerji')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Bla' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Tečajne liste' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Bla' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Tečajne liste')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Bla' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Drugi šifranti' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Bla' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Drugi šifranti')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Bla' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Sintetični kontni plan' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Bla' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Sintetični kontni plan')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Bla' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Davki' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Bla' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Davki')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Bla' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Države' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Bla' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Države')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Bla' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Valute' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Bla' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Valute')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Bla' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Tečajnica' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Bla' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Tečajnica')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Bla' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Vrste dokumentov' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Bla' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Vrste dokumentov')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Bla' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Stroškovna mesta' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Bla' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Stroškovna mesta')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Bla' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Stroškovni nosilci' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Bla' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Stroškovni nosilci')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Bla' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Pošte' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Bla' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Pošte')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Bla' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Obdelave' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Bla' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Obdelave')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Bla' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Nastavitev tekočih številk' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Bla' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Nastavitev tekočih številk')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Bla' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Splošne nastavitve za podjetje' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Bla' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Splošne nastavitve za podjetje')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Bla' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Nastavitve blagajne' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Bla' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Nastavitve blagajne')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Bla' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Nastavitev poslovnega leta' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Bla' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Nastavitev poslovnega leta')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Bla' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Nastavitev obdobja knjiženja' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Bla' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Nastavitev obdobja knjiženja')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Bla' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Uporabniki' AS TagKontrole, 1 AS Visible, 1 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Bla' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Uporabniki')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Bla' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Sistemska opravila' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Bla' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Sistemska opravila')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Bla' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Nadzor delovanja' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Bla' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Nadzor delovanja')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Bla' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Sporočila' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Bla' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Sporočila')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Bla' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Restavriranje podatkov' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Bla' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Restavriranje podatkov')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Bla' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Vzdrževalec' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Bla' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Vzdrževalec')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Poslovni partnerji' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Poslovni partnerji')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Storitve' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Storitve')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Sestavljalci dokumentov' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Sestavljalci dokumentov')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Podpisniki dokumentov' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Podpisniki dokumentov')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Klavzule' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Klavzule')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Tečajne liste' AS TagKontrole, 1 AS Visible, 0 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Tečajne liste')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Ročni vnos tečajnih list' AS TagKontrole, 1 AS Visible, 0 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Ročni vnos tečajnih list')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Priročna besedila' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Priročna besedila')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Drugi šifranti' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Drugi šifranti')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Sintetični kontni plan' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Sintetični kontni plan')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Analitični kontni plan' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Analitični kontni plan')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Banke' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Banke')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Davki' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Davki')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Države' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Države')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Valute' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Valute')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Tečajnice' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Tečajnice')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Vrste dokumentov' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Vrste dokumentov')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Stroškovna mesta' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Stroškovna mesta')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Stroškovni nosilci' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Stroškovni nosilci')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Pošte' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Pošte')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Zaključki' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Zaključki')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Praznik' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Praznik')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Nastavitev obdobja knjiženja' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Nastavitev obdobja knjiženja')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Obdelave' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Obdelave')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Nastavitev tekočih številk' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Nastavitev tekočih številk')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Nastavitve za Fakturiranje' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Nastavitve za Fakturiranje')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Preveri integriteto' AS TagKontrole, 1 AS Visible, 0 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Preveri integriteto')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Vzdrževalec' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Vzdrževalec')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Nastavitev poslovnega leta' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Nastavitev poslovnega leta')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Splošne nastavitve za podjetje' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Splošne nastavitve za podjetje')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Uporabniki' AS TagKontrole, 1 AS Visible, 1 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Uporabniki')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Sistemska opravila' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Sistemska opravila')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Nadzor delovanja' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Nadzor delovanja')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Restavriranje podatkov' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Restavriranje podatkov')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Nastavitev dopisov' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Nastavitev dopisov')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Sporočila' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Sporočila')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Arhiviranje podatkov' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Arhiviranje podatkov')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'&Knjiženje' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'&Knjiženje')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Nastavitev dokumentov' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Nastavitev dokumentov')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Podrobna nastavitev uporabnikov' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Podrobna nastavitev uporabnikov')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Nastavitev menijskega dostopa meni' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Nastavitev menijskega dostopa meni')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Dodajanje uporabnikov' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Dodajanje uporabnikov')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Os' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Za sredstva v uporabi' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Os' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Za sredstva v uporabi')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Os' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Za sredstva v pripravi' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Os' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Za sredstva v pripravi')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Os' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Amortizacijske skupine' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Os' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Amortizacijske skupine')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Os' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Revalorizacijske skupine' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Os' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Revalorizacijske skupine')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Os' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Kontni plan Os' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Os' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Kontni plan Os')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Os' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Nahajališča' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Os' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Nahajališča')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Os' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Nomenklatura' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Os' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Nomenklatura')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Os' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Izvor' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Os' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Izvor')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Os' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Analitični kontni plan' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Os' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Analitični kontni plan')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Os' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Sintetični kontni plan' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Os' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Sintetični kontni plan')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Os' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Stroškovna mesta' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Os' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Stroškovna mesta')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Os' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Skrbniki Os' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Os' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Skrbniki Os')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Os' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Vrste dokumentov' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Os' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Vrste dokumentov')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Os' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'CPV' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Os' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'CPV')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Os' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Poslovni partnerji' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Os' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Poslovni partnerji')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Os' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Proizvajalci' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Os' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Proizvajalci')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Os' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Pošte' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Os' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Pošte')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Os' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Sprememba gesla' AS TagKontrole, 1 AS Visible, 1 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Os' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Sprememba gesla')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Os' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Obdelave' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Os' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Obdelave')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Os' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Kartice Gk' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Os' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Kartice Gk')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Os' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Sporočila' AS TagKontrole, 0 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Os' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Sporočila')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Os' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Arhiviranje podatkov' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Os' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Arhiviranje podatkov')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Os' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Aktiviranje' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Os' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Aktiviranje')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Os' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Sistemska opravila' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Os' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Sistemska opravila')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Os' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Dodatni pregledi' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Os' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Dodatni pregledi')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Os' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Gibanje med nahajališči' AS TagKontrole, 1 AS Visible, 1 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Os' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Gibanje med nahajališči')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Os' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Nastavitve registra' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Os' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Nastavitve registra')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Os' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Nastavitve delovanja programa' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Os' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Nastavitve delovanja programa')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Os' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Nastavitve poslovnega leta' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Os' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Nastavitve poslovnega leta')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Os' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Splošne nastavitve za podjetje' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Os' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Splošne nastavitve za podjetje')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Os' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Uporabniki' AS TagKontrole, 1 AS Visible, 1 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Os' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Uporabniki')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Os' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Dodajanje uporabnikov' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Os' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Dodajanje uporabnikov')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Os' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Podrobna nastavitev uporabnikov' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Os' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Podrobna nastavitev uporabnikov')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Os' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Pregled menijskega dostopa' AS TagKontrole, 1 AS Visible, 0 AS Enabled, N'-' AS Dodajanje, N'-' AS Spreminjanje, N'-' AS Brisanje WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Os' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Pregled menijskega dostopa')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Os' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Nadzor delovanja' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Os' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Nadzor delovanja')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Os' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Resetiranje izračunov' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Os' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Resetiranje izračunov')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Os' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Shrani register' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Os' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Shrani register')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Os' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Povrni register' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Os' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Povrni register')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Os' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Izprazni register' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Os' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Izprazni register')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Os' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Vzdrževalec' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Os' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Vzdrževalec')

INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Os' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Posodobi statistiko' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Os' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Posodobi statistiko')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Bla' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Posodobi statistiko' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Bla' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Posodobi statistiko')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Fa' AS Program, N'mPregledovalec' AS MeniSkupinaID, N'Posodobi statistiko' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Fa' AND MeniSkupinaID=N'mPregledovalec' AND TagKontrole=N'Posodobi statistiko')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Gk' AS Program, N'MPRegledovalec' AS MeniSkupinaID, N'Posodobi statistiko' AS TagKontrole, 1 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Posodobi statistiko')