update ExportType set command = 'SELECT *, now(*) as ExportDate FROM v_ExportPartnior; ORDER BY ImePGrupa, KratkoIme; ; ImportData; ImportTxtPartnior; Партньори;' where Name = 'Партньори';

go

update ExportType set command = 'SELECT *, now(*) as ExportDate FROM v_ExportStokovi; ORDER BY Sklad, DokData, Vid01, DokIme, DokNomer; ; ImportDok; ImportTxtDok; Стокови разписки;' where Name = 'Стокови разписки';

go

update ExportType set command = 'SELECT *, now(*) as ExportDate FROM v_ExportMerki;ORDER BY MN; ;ImportData;ImportTxtMerki;Мерки;'||Char(13)||Char(10)||'::GO::'||Char(13)||Char(10)||
	'SELECT *, now(*) as ExportDate FROM v_ExportStoki;ORDER BY ImeSGrupa, Ime; ;ImportData;ImportTxtStoki;Стоки - стандартни свойства;'||Char(13)||Char(10)||'::GO::'||Char(13)||Char(10)||
	'SELECT *, now(*) as ExportDate FROM v_ExportStokiOp;ORDER BY ImeSGrupa, Stoka; ;ImportData;ImportTxtStoki;Стоки - опаковки;'||Char(13)||Char(10)||'::GO::'||Char(13)||Char(10)||
	'SELECT *, now(*) as ExportDate FROM v_ExportStokiRN;ORDER BY ImeSGrupaOut, StokaOut; ;ImportData;ImportTxtStoki;Стоки - разходни норми;'||Char(13)||Char(10)||'::GO::'||Char(13)||Char(10)||
	'SELECT *, now(*) as ExportDate FROM v_ExportStokiSvo;ORDER BY ImeSGrupa, Stoka; ;ImportData;ImportTxtStoki;Стоки - допълнителни свойства;'||Char(13)||Char(10)||'::GO::'
	where Name = 'Стоки';

go

update ExportType set command = 'SELECT *, now(*) as ExportDate FROM v_ExportUsers;ORDER BY ImeOtdel, Ime; ;ImportData;ImportTxtUsers;Потребители;' where Name = 'Потребители';

go

update ExportType set command = 'SELECT *, now(*) as ExportDate FROM v_ExportMerki;ORDER BY MN; ;ImportData;ImportTxtMerki;Мерки;' where Name = 'Мерки';

go

update ExportType set command = 'SELECT *, now(*) as ExportDate FROM v_ExportCeni; ORDER BY StokaGrupa, Stoka; ; ImportCeni; ImportTxtCeni; Ценоразписи;' where Name = 'Ценоразписи';

go

update ExportType set command = 'SELECT *, now(*) as ExportDate FROM v_ExportCeniPlan; ORDER BY StokaGrupa, Stoka; ; ImportCeni; ImportTxtCeniPlan; Протоколи за преоценка;' where Name = 'Прот. за преоц.';

go

update ExportType set command = 'SELECT *, now(*) as ExportDate FROM v_ExportFakturi; ORDER BY Sklad, DokData, Vid01, DokIme, DokNomer; ; ImportDok; ImportTxtDok; Фактури;' where Name = 'Фактури';

go

update ExportType set command = 'SELECT *, now(*) as ExportDate FROM v_ExportPlateno; ORDER BY Sklad, DokData, Vid01, PCode, DokNomer; ; ImportData; ImportTxtPlateno; Плащания;' where Name = 'Плащания';

go