Delete from tfsMeniNast where TagKontrole='Prevknjižbe'
Delete from tfsMeniNast where TagKontrole='Zamudne obresti'
Delete from tfsMeniNast where TagKontrole='Starejši obračuni DDV (do 01.01.2010)'


INSERT INTO tfsMeniSkupina (Program,MeniSkupinaID,MeniSkupinaOpis) SELECT N'Gk' AS Program, N'Mpregledovalec' AS MeniSkupinaID, N'Skupina pregledovalcev v Gk' AS MeniSkupinaOpis WHERE NOT EXISTS (SELECT * FROM tfsMeniSkupina WHERE Program=N'Gk' AND MeniSkupinaID=N'Mpregledovalec')

INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Gk' AS Program, N'MPRegledovalec' AS MeniSkupinaID, N'&Knjiženje' 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'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'&Knjiženje')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Gk' 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'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'&Obdelave')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Gk' 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'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Analitični kontni plan')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Gk' AS Program, N'MPRegledovalec' AS MeniSkupinaID, N'Analize' 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'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Analize')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Gk' 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'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Banke')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Gk' AS Program, N'Mpregledovalec' AS MeniSkupinaID, N'Banke - konto' 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'Gk' AND MeniSkupinaID=N'Mpregledovalec' AND TagKontrole=N'Banke - konto')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Gk' 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'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Davki')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Gk' AS Program, N'MPRegledovalec' AS MeniSkupinaID, N'Dodajanje uporabnikov' AS TagKontrole, 0 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Dodajanje uporabnikov')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Gk' 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'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Države')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Gk' AS Program, N'MPRegledovalec' AS MeniSkupinaID, N'Identifikacijska številka gesla' AS TagKontrole, 0 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Identifikacijska številka gesla')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Gk' AS Program, N'MPRegledovalec' AS MeniSkupinaID, N'Izvoz vknjižb' AS TagKontrole, 0 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Izvoz vknjižb')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Gk' AS Program, N'MPRegledovalec' AS MeniSkupinaID, N'Ključ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'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Ključi')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Gk' AS Program, N'MPRegledovalec' AS MeniSkupinaID, N'Letne obdelave' 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'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Letne obdelave')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Gk' AS Program, N'MPRegledovalec' AS MeniSkupinaID, N'Nadzor delovanja' AS TagKontrole, 0 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Nadzor delovanja' AND Visible=0 AND Enabled=0)
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Gk' AS Program, N'MPRegledovalec' AS MeniSkupinaID, N'Nastavitev kolon DDV' 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'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Nastavitev kolon DDV')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Gk' AS Program, N'MPRegledovalec' AS MeniSkupinaID, N'Nastavitev menijskega dostopa menu' AS TagKontrole, 0 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Nastavitev menijskega dostopa menu')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Gk' AS Program, N'MPRegledovalec' AS MeniSkupinaID, N'Nastavitev oznake zaupnosti izpisov' AS TagKontrole, 0 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Nastavitev oznake zaupnosti izpisov')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Gk' AS Program, N'MPRegledovalec' AS MeniSkupinaID, N'Nastavitev poslovnega leta' AS TagKontrole, 0 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Nastavitev poslovnega leta')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Gk' AS Program, N'MPRegledovalec' AS MeniSkupinaID, N'Nastavitve delovanja programa' AS TagKontrole, 0 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Nastavitve delovanja programa')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Gk' AS Program, N'MPRegledovalec' AS MeniSkupinaID, N'Arhiviranje podatkov' AS TagKontrole, 0 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Arhiviranje podatkov')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Gk' AS Program, N'MPRegledovalec' AS MeniSkupinaID, N'Nastavitve dopisov' AS TagKontrole, 0 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Nastavitve dopisov')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Gk' AS Program, N'MPRegledovalec' AS MeniSkupinaID, N'Obračun DDV' 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'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Obračun DDV')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Gk' AS Program, N'MPRegledovalec' AS MeniSkupinaID, N'Obresti' 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'Obresti')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Gk' AS Program, N'MPRegledovalec' AS MeniSkupinaID, N'Opomini menu' AS TagKontrole, 0 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Opomini menu')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Gk' AS Program, N'MPRegledovalec' AS MeniSkupinaID, N'Plačilni nalogi' 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'Plačilni nalogi')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Gk' AS Program, N'MPRegledovalec' AS MeniSkupinaID, N'Podrobna nastavitev uporabnikov' AS TagKontrole, 0 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Podrobna nastavitev uporabnikov')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Gk' 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'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Poslovni partnerji')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Gk' 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'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Pošte')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Gk' AS Program, N'MPRegledovalec' AS MeniSkupinaID, N'Pregled menijskega dostopa' AS TagKontrole, 0 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Pregled menijskega dostopa')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Gk' AS Program, N'MPRegledovalec' AS MeniSkupinaID, N'Preverjanje skladnosti nastavitev' AS TagKontrole, 0 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Preverjanje skladnosti nastavitev')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Gk' AS Program, N'MPRegledovalec' AS MeniSkupinaID, N'Prevknjižbe odprtih postavk - odpisi' AS TagKontrole, 0 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Prevknjižbe odprtih postavk - odpisi')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Gk' AS Program, N'Mpregledovalec' AS MeniSkupinaID, N'Regije' 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'Gk' AND MeniSkupinaID=N'Mpregledovalec' AND TagKontrole=N'Regije')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Gk' AS Program, N'MPRegledovalec' AS MeniSkupinaID, N'Rekonstrukcija fakturnih knjig' AS TagKontrole, 0 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Rekonstrukcija fakturnih knjig')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Gk' AS Program, N'MPRegledovalec' AS MeniSkupinaID, N'Restavriranje podatkov' AS TagKontrole, 0 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Restavriranje podatkov')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Gk' AS Program, N'MPRegledovalec' AS MeniSkupinaID, N'Ročni vnos knjig za DDV' 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'Ročni vnos knjig za DDV')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Gk' AS Program, N'MPRegledovalec' AS MeniSkupinaID, N'Ročno zapiranje odprtih postavk' AS TagKontrole, 0 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Ročno zapiranje odprtih postavk')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Gk' 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'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Sintetični kontni plan')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Gk' AS Program, N'MPRegledovalec' AS MeniSkupinaID, N'Sistemska opravila' AS TagKontrole, 0 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Sistemska opravila')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Gk' AS Program, N'MPRegledovalec' AS MeniSkupinaID, N'Splošne nastavitve za podjetje' AS TagKontrole, 0 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Splošne nastavitve za podjetje')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Gk' 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'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Sporočila')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Gk' AS Program, N'MPRegledovalec' AS MeniSkupinaID, N'Sprememba datumov (statusov)  DDV' 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'Sprememba datumov (statusov)  DDV')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Gk' AS Program, N'MPRegledovalec' AS MeniSkupinaID, N'Starejši obračuni DDV (do 01.01.2010)' AS TagKontrole, 0 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Starejši obračuni DDV 1')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Gk' AS Program, N'MPRegledovalec' AS MeniSkupinaID, N'Stornacija dnevnika' AS TagKontrole, 0 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Stornacija dnevnika')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Gk' 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'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Stroškovna mesta')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Gk' 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'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Stroškovni nosilci')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Gk' AS Program, N'MPRegledovalec' AS MeniSkupinaID, N'Tečajne liste' 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'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Tečajne liste')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Gk' 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'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Tečajnice')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Gk' AS Program, N'Mpregledovalec' AS MeniSkupinaID, N'Usklajenost evidenčnih vknjižb' AS TagKontrole, 0 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Gk' AND MeniSkupinaID=N'Mpregledovalec' AND TagKontrole=N'Usklajenost evidenčnih vknjižb')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Gk' 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'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Valute')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Gk' AS Program, N'MPRegledovalec' AS MeniSkupinaID, N'Vnos delovodnika' AS TagKontrole, 0 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Vnos delovodnika')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Gk' 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'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Vrste dokumentov')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Gk' AS Program, N'MPRegledovalec' AS MeniSkupinaID, N'Vrste knjiženja' 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'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Vrste knjiženja')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Gk' AS Program, N'Mpregledovalec' AS MeniSkupinaID, N'Vrste poslov' 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'Gk' AND MeniSkupinaID=N'Mpregledovalec' AND TagKontrole=N'Vrste poslov')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled) SELECT N'Gk' AS Program, N'MPRegledovalec' AS MeniSkupinaID, N'Vzdrževalec' AS TagKontrole, 0 AS Visible, 0 AS Enabled WHERE NOT EXISTS (SELECT * FROM tfsMeniNast WHERE Program=N'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Vzdrževalec')
INSERT INTO tfsMeniNast (Program,MeniSkupinaID,TagKontrole,Visible,Enabled,Dodajanje,Spreminjanje,Brisanje) SELECT N'Gk' 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'Gk' AND MeniSkupinaID=N'MPRegledovalec' AND TagKontrole=N'Zaključki')